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 |