APPS.GML_RCV_DIR_RCPT_APIS dependencies on PO_LINES

Line 273: PO_LINES POL,

269: pod.task_id task_id
270: FROM
271: PO_HEADERS POH,
272: PO_LINE_LOCATIONS POLL,
273: PO_LINES POL,
274: PO_RELEASES POR,
275: MTL_SYSTEM_ITEMS MSI,
276: MTL_UNITS_OF_MEASURE mum,
277: PO_DISTRIBUTIONS POD

Line 731: PO_LINES POL,

727: pod.task_id task_id
728: FROM
729: PO_HEADERS POH,
730: PO_LINE_LOCATIONS POLL,
731: PO_LINES POL,
732: PO_RELEASES POR,
733: MTL_SYSTEM_ITEMS MSI,
734: MTL_UNITS_OF_MEASURE mum,
735: PO_DISTRIBUTIONS POD

Line 2189: PO_LINES POL,

2185: RCV_SHIPMENT_LINES RSL,
2186: RCV_SHIPMENT_HEADERS RSH,
2187: PO_HEADERS POH,
2188: PO_LINE_LOCATIONS POLL,
2189: PO_LINES POL,
2190: PO_RELEASES POR,
2191: MTL_SYSTEM_ITEMS MSI,
2192: MTL_UNITS_OF_MEASURE MUM,
2193: PO_DISTRIBUTIONS POD

Line 2813: FROM po_lines_all pola

2809: AND msi.organization_id = p_organization_id
2810: AND wlpn.lpn_id = wlpnc.parent_lpn_id
2811: AND (wlpnc.source_line_id IN
2812: (SELECT pola.po_line_id
2813: FROM po_lines_all pola
2814: WHERE pola.po_header_id = Nvl(p_po_header_id, pola.po_header_id))
2815: OR wlpnc.source_line_id IS NULL)
2816: ) lpnc
2817: WHERE lpnc.inventory_item_id = mln.inventory_item_id(+)