PO Financials/Purchasing Options Listing
Description
Categories: BI Publisher
Application: Purchasing
Source: Financials/Purchasing Options Listing (XML)
Short Name: POXFIPOL_XML
DB package: PO_POXFIPOL_XMLP_PKG
Source: Financials/Purchasing Options Listing (XML)
Short Name: POXFIPOL_XML
DB package: PO_POXFIPOL_XMLP_PKG
Run
PO Financials/Purchasing Options Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT gsb.name Set_of_Books , fsp.user_defined_vendor_num_code Vendor_Number_Entry , fsp.manual_vendor_num_type Vendor_Number_Type , (puc.current_max_unique_identifier + 1) Next_Automatic_Vendor_Number , decode(fsp.rfq_only_site_flag,'Y',:yes,'N',:no,null) RFQ_Only_Site , lot1.location_code Ship_to_Location , lot2.location_code Bill_to_Location , fsp.ship_via_lookup_code Ship_via , fsp.fob_lookup_code FOB , fsp.freight_terms_lookup_code Freight_Terms , to_number('') Quantity_Received_Tolerance , ood.organization_name Inventory_Organization , apt.name Terms , decode(fsp.req_encumbrance_flag,'Y',:yes,'N',:no,null) Use_Requisition_Encumbrance , get1.encumbrance_type Requisition_Encumbrance_Type , decode(fsp.purch_encumbrance_flag,'Y',:yes,'N',:no,null) Use_Purchase_Order_Encumbrance , get2.encumbrance_type Purchase_Order_Encumbrance_Ty , decode(fsp.reserve_at_completion_flag,'Y',:yes,'N',:no,null) Reserve_at_Completion , pbg.name Business_Group , decode(fsp.use_positions_flag,'Y',:yes,'N',:no,null) Use_Approval_Hierarchies , fsp.receipt_acceptance_days &select_rev FROM financials_system_parameters fsp , gl_sets_of_books gsb , po_unique_identifier_control puc , hr_locations_all_tl lot1 , hr_locations_all_tl lot2 , org_organization_definitions ood , ap_terms apt , gl_encumbrance_types get1 , gl_encumbrance_types get2 , per_business_groups pbg , hr_lookups hlo &from_rev WHERE puc.table_name = 'PO_VENDORS' AND fsp.ship_to_location_id = lot1.location_id(+) AND fsp.bill_to_location_id = lot2.location_id(+) AND LOT1.LANGUAGE(+) = USERENV('LANG') AND LOT2.LANGUAGE(+) = USERENV('LANG') AND fsp.inventory_organization_id = ood.organization_id (+) AND fsp.terms_id = apt.term_id(+) AND fsp.req_encumbrance_type_id = get1.encumbrance_type_id (+) AND fsp.purch_encumbrance_type_id = get2.encumbrance_type_id (+) AND (fsp.business_group_id = pbg.business_group_id AND hlo.lookup_type = 'EMP_NUM_GEN_METHOD' AND pbg.method_of_generation_emp_num = hlo.lookup_code) AND gsb.set_of_books_id = fsp.set_of_books_id &where_rev |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Title |
|
Char |