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
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