APPS.PO_OTM_INTEGRATION_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 833: , financials_system_params_all fsp

829: , hr_all_organization_units hou
830: , hr_locations_all hrl
831: , mtl_system_items_kfv msik
832: , mtl_units_of_measure muom
833: , financials_system_params_all fsp
834: , per_all_people_f ppf
835: , ( SELECT psg.index_num1 line_location_id
836: , psg.num1 deliver_to_person_id
837: FROM po_session_gt psg

Line 1344: , financials_system_params_all fsp

1340: , plla.shipment_num
1341: FROM po_headers_archive_all poha
1342: , po_lines_archive_all pola
1343: , po_line_locations_archive_all plla
1344: , financials_system_params_all fsp
1345: , mtl_system_items msi
1346: WHERE poha.po_header_id = p_doc_id
1347: AND poha.revision_num = p_doc_revision
1348: AND pola.po_header_id = poha.po_header_id

Line 1589: , financials_system_params_all fsp

1585: , hr_all_organization_units hou
1586: , hr_locations_all hrl
1587: , mtl_system_items_kfv msik
1588: , mtl_units_of_measure muom
1589: , financials_system_params_all fsp
1590: , per_all_people_f ppf
1591: , ( SELECT psg.index_num1 line_location_id
1592: , psg.num1 deliver_to_person_id
1593: FROM po_session_gt psg

Line 2113: , financials_system_params_all fsp

2109: , po_releases_archive_all pora
2110: , po_lines_archive_all pola
2111: , po_line_locations_archive_all plla
2112: , mtl_system_items msi
2113: , financials_system_params_all fsp
2114: WHERE pora.po_release_id = p_doc_id
2115: AND pora.revision_num = p_doc_revision
2116: AND poha.po_header_id = pora.po_header_id
2117: AND poha.revision_num = p_blanket_revision

Line 2797: financials_system_params_all FSP

2793: l_header_user_hold_flag,
2794: l_inv_org_id
2795: FROM po_headers_all POH,
2796: hr_all_organization_units HOU,
2797: financials_system_params_all FSP
2798: WHERE POH.po_header_id = p_doc_id
2799: AND POH.org_id = HOU.organization_id
2800: AND POH.org_id = FSP.org_id
2801: AND NVL(POH.consigned_consumption_flag, 'N') = 'N';

Line 2960: financials_system_params_all FSP

2956: l_inv_org_id
2957: FROM po_releases_all POR,
2958: po_headers_all POH,
2959: hr_all_organization_units HOU,
2960: financials_system_params_all FSP
2961: WHERE POR.po_release_id = p_doc_id
2962: AND POR.po_header_id = POH.po_header_id
2963: AND POR.org_id = HOU.organization_id
2964: AND POR.org_id = FSP.org_id