APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on PO_HEADERS_ALL

Line 1360: , po_headers_all poh

1356: , pol.project_id
1357: , pol.task_id
1358: FROM
1359: po_line_locations_all poll
1360: , po_headers_all poh
1361: , po_lines_all pol
1362: , mtl_units_of_measure muom
1363: , po_releases_all por
1364: WHERE poll.po_header_id = poh.po_header_id

Line 1807: po_headers_all pha,

1803: plla.shipment_num
1804: FROM hr_organization_information hoi,
1805: po_line_locations_all plla,
1806: po_lines_all pla,
1807: po_headers_all pha,
1808: mtl_interorg_parameters mip,
1809: mtl_system_items_b msib
1810: WHERE hoi.org_information_context = 'Customer/Supplier Association'
1811: AND TO_NUMBER(hoi.org_information3) = pha.vendor_id

Line 1887: , po_headers_all pha

1883: , jmf_subcontract_orders jso
1884: , wip_requirement_operations wro
1885: , po_line_locations_all plla
1886: , po_lines_all pla
1887: , po_headers_all pha
1888: WHERE jso.subcontract_po_shipment_id = jsc.subcontract_po_shipment_id
1889: AND jsc.subcontract_po_shipment_id=jsa.subcontract_po_shipment_id(+)
1890: AND jsc.shikyu_component_id = jsa.shikyu_component_id(+)
1891: AND jso.interlock_status = 'P'

Line 1958: l_po_header_num PO_HEADERS_ALL.SEGMENT1%TYPE;

1954: l_allocated_qty NUMBER;
1955: l_qty NUMBER;
1956: l_reference_num VARCHAR2(25);
1957: l_po_need_by_date DATE;
1958: l_po_header_num PO_HEADERS_ALL.SEGMENT1%TYPE;
1959: l_po_line_num PO_LINES.LINE_NUM%TYPE;
1960: l_po_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE;
1961: l_subcontracting_component
1962: NUMBER;

Line 3711: , po_headers_all pha

3707: SELECT jso.subcontract_po_shipment_id
3708: FROM jmf_subcontract_orders jso
3709: , po_line_locations_all plla
3710: , po_lines_all pla
3711: , po_headers_all pha
3712: WHERE jso.interlock_status IN ('N', 'U')
3713: AND plla.line_location_id = jso.subcontract_po_shipment_id
3714: AND plla.po_line_id = pla.po_line_id
3715: AND plla.po_header_id = pha.po_header_id