APPS.POS_ASN_XML dependencies on PO_HEADERS_ALL

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

248: p_line_num,
249: p_po_shipment_line_num,
250: p_error_message
251: from
252: rcv_transactions_interface rti, po_interface_errors pie, po_headers_all poh, po_lines_all pol,
253: po_line_locations_all poll
254: where
255: pie.interface_header_id = rti.header_interface_id and
256: pie.interface_type in ('RECEIVING','RCV-856') and

Line 541: po_headers_all poh,

537:
538: SELECT count(*)
539: INTO l_count_num
540: FROM
541: po_headers_all poh,
542: po_lines_all pol,
543: po_line_locations_all pll,
544: Mtl_system_items_kfv msi
545: WHERE

Line 565: po_headers_all poh,

561:
562: SELECT count(*)
563: INTO l_count_num
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

Line 622: po_headers_all poh,

618:
619: SELECT min(poh.ORG_ID)
620: INTO p_org_id
621: FROM
622: po_headers_all poh,
623: po_lines_all pol,
624: po_line_locations_all pll,
625: Mtl_system_items_kfv msi
626: WHERE

Line 646: po_headers_all poh,

642:
643: SELECT min(poh.ORG_ID)
644: INTO p_org_id
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

Line 674: from po_headers_all

670:
671:
672: select min(po_header_id)
673: into p_po_header_id
674: from po_headers_all
675: where segment1 = p_po_number
676: and org_id = p_org_id;
677:
678:

Line 686: po_headers_all poh,

682: count(*)
683: into
684: x_ship_org_num
685: from
686: po_headers_all poh,
687: po_lines_all pol,
688: po_line_locations_all pll
689: where
690: poh.po_header_id = p_po_header_id and

Line 703: po_headers_all poh,

699: count(*)
700: into
701: x_ship_org_num
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

Line 729: po_headers_all poh,

725: min(pll.ship_to_organization_id)
726: into
727: p_ship_to_org_id
728: from
729: po_headers_all poh,
730: po_lines_all pol,
731: po_line_locations_all pll
732: where
733: poh.po_header_id = p_po_header_id and

Line 746: po_headers_all poh,

742: min(pll.ship_to_organization_id)
743: into
744: p_ship_to_org_id
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

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

1024: /* save the inbound value for ship_to_location_id for matching */
1025:
1026: --x_ship_to_location_id := p_ship_to_location_id;
1027:
1028: select segment1 into x_po_num from po_headers_all where po_header_id=p_po_header_id;
1029:
1030: if ((p_release_num is null) OR (p_release_num = 0)) then
1031:
1032: SELECT

Line 1037: po_headers_all poh,

1033: count(*)
1034: INTO
1035: l_count
1036: FROM
1037: po_headers_all poh,
1038: po_lines_all pol,
1039: po_line_locations_all pll,
1040: MTL_SYSTEM_ITEMS_KFV MSI
1041: WHERE

Line 1058: po_headers_all poh,

1054: count(*)
1055: INTO
1056: l_count
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

Line 1099: po_headers_all poh,

1095: p_po_line_id,
1096: p_line_location_id,
1097: p_ship_to_org_id
1098: FROM
1099: po_headers_all poh,
1100: po_lines_all pol,
1101: po_line_locations_all pll,
1102: MTL_SYSTEM_ITEMS_KFV MSI
1103: WHERE

Line 1136: po_headers_all poh,

1132: p_line_location_id,
1133: p_ship_to_org_id,
1134: p_po_release_id
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