APPS.POS_ASN_XML dependencies on PO_HEADERS_ALL

Line 242: rcv_transactions_interface rti, po_interface_errors pie, po_headers_all poh, po_lines_all pol,

238: p_line_num,
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

Line 520: po_headers_all poh,

516:
517: SELECT count(*)
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

Line 544: po_headers_all poh,

540:
541: SELECT count(*)
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

Line 601: po_headers_all poh,

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

Line 625: po_headers_all poh,

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

Line 653: from po_headers_all

649:
650:
651: select min(po_header_id)
652: into p_po_header_id
653: from po_headers_all
654: where segment1 = p_po_number
655: and org_id = p_org_id;
656:
657:

Line 665: po_headers_all poh,

661: count(*)
662: into
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

Line 682: po_headers_all poh,

678: count(*)
679: into
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

Line 708: po_headers_all poh,

704: min(pll.ship_to_organization_id)
705: into
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

Line 725: po_headers_all poh,

721: min(pll.ship_to_organization_id)
722: into
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

Line 997: select segment1 into x_po_num from po_headers_all where po_header_id=p_po_header_id;

993: /* save the inbound value for ship_to_location_id for matching */
994:
995: x_ship_to_location_id := p_ship_to_location_id;
996:
997: select segment1 into x_po_num from po_headers_all where po_header_id=p_po_header_id;
998:
999: if ((p_release_num is null) OR (p_release_num = 0)) then
1000:
1001: SELECT

Line 1006: po_headers_all poh,

1002: count(*)
1003: INTO
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

Line 1027: po_headers_all poh,

1023: count(*)
1024: INTO
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

Line 1068: po_headers_all poh,

1064: p_po_line_id,
1065: p_line_location_id,
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

Line 1105: po_headers_all poh,

1101: p_line_location_id,
1102: p_ship_to_org_id,
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