DBA Data[Home] [Help]

APPS.M4R_3B2IN_PKG dependencies on PO_LINES_ALL

Line 55: po_lines_all pol,

51: SELECT min(poh.ORG_ID)
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

Line 73: po_lines_all pol,

69: SELECT min(poh.ORG_ID)
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

Line 108: po_lines_all pol,

104: into
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

Line 123: po_lines_all pol,

119: into
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

Line 255: po_lines_all pol,

251: p_line_location_id,
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

Line 289: po_lines_all pol,

285: p_ship_to_org_id,
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