DBA Data[Home] [Help]

APPS.M4R_3B2IN_PKG dependencies on PO_RELEASES_ALL

Line 75: po_releases_all prl,

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
79: nvl(msi.concatenated_segments, -99) = nvl(NVL(p_item_num, msi.concatenated_segments), -99) AND

Line 125: po_releases_all prl

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
129: pol.line_num = p_document_line_num and

Line 291: po_releases_all prl,

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
295: and POL.PO_LINE_ID = PLL.PO_LINE_ID