APPS.M4R_3B2IN_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 56: po_line_locations_all pll,

52: INTO p_org_id
53: FROM
54: po_headers_all poh,
55: po_lines_all pol,
56: po_line_locations_all pll,
57: Mtl_system_items_kfv msi
58: WHERE
59: poh.SEGMENT1 = p_po_number AND
60: nvl(msi.concatenated_segments, -99) = nvl(NVL(p_item_num, msi.concatenated_segments), -99) AND

Line 74: po_line_locations_all pll,

70: INTO p_org_id
71: FROM
72: po_headers_all poh,
73: po_lines_all pol,
74: po_line_locations_all pll,
75: po_releases_all prl,
76: Mtl_system_items_kfv msi
77: WHERE
78: poh.SEGMENT1 = p_po_number AND

Line 109: po_line_locations_all pll

105: p_ship_to_org_id
106: from
107: po_headers_all poh,
108: po_lines_all pol,
109: po_line_locations_all pll
110: where
111: poh.po_header_id = p_po_header_id and
112: poh.po_header_id = pol.po_header_id and
113: pol.line_num = p_document_line_num and

Line 124: po_line_locations_all pll,

120: p_ship_to_org_id
121: from
122: po_headers_all poh,
123: po_lines_all pol,
124: po_line_locations_all pll,
125: po_releases_all prl
126: where
127: poh.po_header_id = p_po_header_id and
128: poh.po_header_id = pol.po_header_id and

Line 256: po_line_locations_all pll,

252: p_ship_to_org_id
253: FROM
254: po_headers_all poh,
255: po_lines_all pol,
256: po_line_locations_all pll,
257: MTL_SYSTEM_ITEMS_KFV MSI
258: WHERE
259: POH.PO_HEADER_ID = POL.PO_HEADER_ID
260: and POL.PO_LINE_ID = PLL.PO_LINE_ID

Line 290: po_line_locations_all pll,

286: p_po_release_id
287: FROM
288: po_headers_all poh,
289: po_lines_all pol,
290: po_line_locations_all pll,
291: po_releases_all prl,
292: MTL_SYSTEM_ITEMS_KFV MSI
293: WHERE
294: POH.PO_HEADER_ID = POL.PO_HEADER_ID