APPS.POS_ASN_XML dependencies on PO_LINE_LOCATIONS_ALL

Line 243: po_line_locations_all poll

239: p_po_shipment_line_num,
240: p_error_message
241: from
242: rcv_transactions_interface rti, po_interface_errors pie, po_headers_all poh, po_lines_all pol,
243: po_line_locations_all poll
244: where
245: pie.interface_header_id = rti.header_interface_id and
246: pie.interface_type in ('RECEIVING','RCV-856') and
247: rti.po_header_id = poh.po_header_id and

Line 522: po_line_locations_all pll,

518: INTO l_count_num
519: FROM
520: po_headers_all poh,
521: po_lines_all pol,
522: po_line_locations_all pll,
523: Mtl_system_items_kfv msi
524: WHERE
525: poh.SEGMENT1 = p_po_number AND
526: poh.Vendor_Site_ID IN

Line 546: po_line_locations_all pll,

542: INTO l_count_num
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

Line 603: po_line_locations_all pll,

599: INTO p_org_id
600: FROM
601: po_headers_all poh,
602: po_lines_all pol,
603: po_line_locations_all pll,
604: Mtl_system_items_kfv msi
605: WHERE
606: poh.SEGMENT1 = p_po_number AND
607: poh.Vendor_Site_ID IN

Line 627: po_line_locations_all pll,

623: INTO p_org_id
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

Line 667: po_line_locations_all pll

663: x_ship_org_num
664: from
665: po_headers_all poh,
666: po_lines_all pol,
667: po_line_locations_all pll
668: where
669: poh.po_header_id = p_po_header_id and
670: poh.po_header_id = pol.po_header_id and
671: pol.line_num = p_document_line_num and

Line 684: po_line_locations_all pll,

680: x_ship_org_num
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

Line 710: po_line_locations_all pll

706: p_ship_to_org_id
707: from
708: po_headers_all poh,
709: po_lines_all pol,
710: po_line_locations_all pll
711: where
712: poh.po_header_id = p_po_header_id and
713: poh.po_header_id = pol.po_header_id and
714: pol.line_num = p_document_line_num and

Line 727: po_line_locations_all pll,

723: p_ship_to_org_id
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

Line 1008: po_line_locations_all pll,

1004: l_count
1005: FROM
1006: po_headers_all poh,
1007: po_lines_all pol,
1008: po_line_locations_all pll,
1009: MTL_SYSTEM_ITEMS_KFV MSI
1010: WHERE
1011: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1012: and POL.PO_LINE_ID = PLL.PO_LINE_ID

Line 1029: po_line_locations_all pll,

1025: l_count
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

Line 1070: po_line_locations_all pll,

1066: p_ship_to_org_id
1067: FROM
1068: po_headers_all poh,
1069: po_lines_all pol,
1070: po_line_locations_all pll,
1071: MTL_SYSTEM_ITEMS_KFV MSI
1072: WHERE
1073: POH.PO_HEADER_ID = POL.PO_HEADER_ID
1074: and POL.PO_LINE_ID = PLL.PO_LINE_ID

Line 1107: po_line_locations_all pll,

1103: p_po_release_id
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