DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 427: financials_system_parameters fsp

423: po_lines_all po2, -- CLM Apprvl
424: po_lookup_codes lkp1,
425: mtl_system_items_kfv msi,
426: mtl_units_of_measure muom, -- bug 2401933.add
427: financials_system_parameters fsp
428: WHERE pol.po_header_id = v_document_id
429: AND lkp1.lookup_code(+) = pol.contract_type
430: AND lkp1.lookup_type(+) = decode(pol.order_type_lookup_code,
431: 'QUANTITY', 'PO_FEDERAL_CONTRACT_TYPES_QTY',

Line 494: financials_system_parameters fsp

490: po_lines_draft_all po2, -- CLM Apprvl
491: po_lookup_codes lkp1,
492: mtl_system_items_kfv msi,
493: mtl_units_of_measure muom, -- bug 2401933.add
494: financials_system_parameters fsp
495: WHERE pol.po_header_id = v_document_id
496: AND nvl(pol.draft_id, -1) = nvl(v_draft_id, -1)
497: AND lkp1.lookup_code(+) = pol.contract_type
498: AND lkp1.lookup_type(+) = decode(pol.order_type_lookup_code,

Line 540: financials_system_parameters fsp

536: hr_locations_all hrl,
537: hz_locations hz,
538: org_organization_definitions ood,
539: mtl_units_of_measure muom, -- Bug 2401933.add
540: financials_system_parameters fsp
541: where PLL.PO_RELEASE_ID = v_document_id
542: and PLL.po_line_id = POL.po_line_id
543: and PLL.ship_to_location_id = HRL.location_id (+)
544: and PLL.ship_to_location_id = HZ.location_id (+)