APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on PO_HEADERS_ALL

Line 1307: , po_headers_all poh

1303: , pol.project_id
1304: , pol.task_id
1305: FROM
1306: po_line_locations_all poll
1307: , po_headers_all poh
1308: , po_lines_all pol
1309: , mtl_units_of_measure muom
1310: , po_releases_all por
1311: WHERE poll.po_header_id = poh.po_header_id

Line 1638: po_headers_all pha,

1634: plla.shipment_num
1635: FROM hr_organization_information hoi,
1636: po_line_locations_all plla,
1637: po_lines_all pla,
1638: po_headers_all pha,
1639: mtl_interorg_parameters mip,
1640: mtl_system_items_b msib
1641: WHERE hoi.org_information_context = 'Customer/Supplier Association'
1642: AND TO_NUMBER(hoi.org_information3) = pha.vendor_id

Line 1714: , po_headers_all pha

1710: , jmf_subcontract_orders jso
1711: , wip_requirement_operations wro
1712: , po_line_locations_all plla
1713: , po_lines_all pla
1714: , po_headers_all pha
1715: WHERE jso.subcontract_po_shipment_id = jsc.subcontract_po_shipment_id
1716: AND jsc.subcontract_po_shipment_id=jsa.subcontract_po_shipment_id(+)
1717: AND jsc.shikyu_component_id = jsa.shikyu_component_id(+)
1718: AND jso.interlock_status = 'P'

Line 1783: l_po_header_num PO_HEADERS_ALL.SEGMENT1%TYPE;

1779: l_allocated_qty NUMBER;
1780: l_qty NUMBER;
1781: l_reference_num VARCHAR2(25);
1782: l_po_need_by_date DATE;
1783: l_po_header_num PO_HEADERS_ALL.SEGMENT1%TYPE;
1784: l_po_line_num PO_LINES.LINE_NUM%TYPE;
1785: l_po_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE;
1786: l_subcontracting_component
1787: NUMBER;

Line 3412: , po_headers_all pha

3408: SELECT jso.subcontract_po_shipment_id
3409: FROM jmf_subcontract_orders jso
3410: , po_line_locations_all plla
3411: , po_lines_all pla
3412: , po_headers_all pha
3413: WHERE jso.interlock_status IN ('N', 'U')
3414: AND plla.line_location_id = jso.subcontract_po_shipment_id
3415: AND plla.po_line_id = pla.po_line_id
3416: AND plla.po_header_id = pha.po_header_id