DBA Data[Home] [Help]

APPS.POS_ASN_XML dependencies on PO_RELEASES_ALL

Line 547: po_releases_all prl,

543: FROM
544: po_headers_all poh,
545: po_lines_all pol,
546: po_line_locations_all pll,
547: po_releases_all prl,
548: Mtl_system_items_kfv msi
549: WHERE
550: poh.SEGMENT1 = p_po_number AND
551: poh.Vendor_Site_ID IN

Line 628: po_releases_all prl,

624: FROM
625: po_headers_all poh,
626: po_lines_all pol,
627: po_line_locations_all pll,
628: po_releases_all prl,
629: Mtl_system_items_kfv msi
630: WHERE
631: poh.SEGMENT1 = p_po_number AND
632: poh.Vendor_Site_ID IN

Line 685: po_releases_all prl

681: from
682: po_headers_all poh,
683: po_lines_all pol,
684: po_line_locations_all pll,
685: po_releases_all prl
686: where
687: poh.po_header_id = p_po_header_id and
688: poh.po_header_id = pol.po_header_id and
689: pol.line_num = p_document_line_num and

Line 728: po_releases_all prl

724: from
725: po_headers_all poh,
726: po_lines_all pol,
727: po_line_locations_all pll,
728: po_releases_all prl
729: where
730: poh.po_header_id = p_po_header_id and
731: poh.po_header_id = pol.po_header_id and
732: pol.line_num = p_document_line_num and

Line 1030: po_releases_all prl,

1026: FROM
1027: po_headers_all poh,
1028: po_lines_all pol,
1029: po_line_locations_all pll,
1030: po_releases_all prl,
1031: MTL_SYSTEM_ITEMS_KFV MSI
1032: WHERE
1033: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1034: and POL.PO_LINE_ID = PLL.PO_LINE_ID

Line 1108: po_releases_all prl,

1104: FROM
1105: po_headers_all poh,
1106: po_lines_all pol,
1107: po_line_locations_all pll,
1108: po_releases_all prl,
1109: MTL_SYSTEM_ITEMS_KFV MSI
1110: WHERE
1111: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1112: and POL.PO_LINE_ID = PLL.PO_LINE_ID