DBA Data[Home] [Help]

APPS.POS_ASN_XML dependencies on PO_RELEASES_ALL

Line 568: po_releases_all prl,

564: FROM
565: po_headers_all poh,
566: po_lines_all pol,
567: po_line_locations_all pll,
568: po_releases_all prl,
569: Mtl_system_items_kfv msi
570: WHERE
571: poh.SEGMENT1 = p_po_number AND
572: poh.Vendor_Site_ID IN

Line 649: po_releases_all prl,

645: FROM
646: po_headers_all poh,
647: po_lines_all pol,
648: po_line_locations_all pll,
649: po_releases_all prl,
650: Mtl_system_items_kfv msi
651: WHERE
652: poh.SEGMENT1 = p_po_number AND
653: poh.Vendor_Site_ID IN

Line 706: po_releases_all prl

702: from
703: po_headers_all poh,
704: po_lines_all pol,
705: po_line_locations_all pll,
706: po_releases_all prl
707: where
708: poh.po_header_id = p_po_header_id and
709: poh.po_header_id = pol.po_header_id and
710: pol.line_num = p_document_line_num and

Line 749: po_releases_all prl

745: from
746: po_headers_all poh,
747: po_lines_all pol,
748: po_line_locations_all pll,
749: po_releases_all prl
750: where
751: poh.po_header_id = p_po_header_id and
752: poh.po_header_id = pol.po_header_id and
753: pol.line_num = p_document_line_num and

Line 1061: po_releases_all prl,

1057: FROM
1058: po_headers_all poh,
1059: po_lines_all pol,
1060: po_line_locations_all pll,
1061: po_releases_all prl,
1062: MTL_SYSTEM_ITEMS_KFV MSI
1063: WHERE
1064: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1065: and POL.PO_LINE_ID = PLL.PO_LINE_ID

Line 1139: po_releases_all prl,

1135: FROM
1136: po_headers_all poh,
1137: po_lines_all pol,
1138: po_line_locations_all pll,
1139: po_releases_all prl,
1140: MTL_SYSTEM_ITEMS_KFV MSI
1141: WHERE
1142: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1143: and POL.PO_LINE_ID = PLL.PO_LINE_ID