[Home] [Help]
286: p_shipment_num_tbl(i),
287: 'VALUE',
288: p_shipment_num_tbl(i),
289: PO_VAL_CONSTANTS.c_shipment_num_unique
290: FROM DUAL
291: WHERE p_shipment_num_tbl(i) IS NOT NULL AND
292: p_po_header_id_tbl(i) IS NOT NULL AND
293: p_po_line_id_tbl(i) IS NOT NULL AND
294: p_shipment_type_tbl(i) IS NOT NULL AND
587: p_ship_to_organization_id_tbl(i),
588: 'SHIP_TO_ORGANIZATION_ID',
589: p_ship_to_organization_id_tbl(i),
590: PO_VAL_CONSTANTS.c_ship_to_organization_id
591: FROM DUAL
592: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
593: AND p_item_revision_tbl(i) IS NOT NULL
594: AND p_item_id_tbl(i) IS NOT NULL
595: AND NOT EXISTS(
628: p_ship_to_organization_id_tbl(i),
629: 'SHIP_TO_ORGANIZATION_ID',
630: p_ship_to_organization_id_tbl(i),
631: PO_VAL_CONSTANTS.c_ship_to_organization_id
632: FROM DUAL
633: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
634: AND p_item_revision_tbl(i) IS NULL
635: AND p_item_id_tbl(i) IS NOT NULL
636: AND NOT EXISTS(SELECT 1
666: p_ship_to_organization_id_tbl(i),
667: 'SHIP_TO_ORGANIZATION_ID',
668: p_ship_to_organization_id_tbl(i),
669: PO_VAL_CONSTANTS.c_ship_to_organization_id
670: FROM DUAL
671: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
672: AND p_item_id_tbl(i) IS NULL
673: AND NOT EXISTS(
674: SELECT 1
705: p_ship_to_location_id_tbl(i),
706: 'SHIP_TO_LOCATION_ID',
707: p_ship_to_location_id_tbl(i),
708: PO_VAL_CONSTANTS.c_loc_ship_to_loc_id_valid
709: FROM DUAL
710: WHERE p_ship_to_location_id_tbl(i) IS NOT NULL
711: AND NOT EXISTS(
712: SELECT 1
713: FROM po_locations_val_v PLV
1017: p_qty_rcv_exception_code_tbl(i),
1018: 'QTY_RCV_EXCEPTION_CODE',
1019: p_qty_rcv_exception_code_tbl(i),
1020: PO_VAL_CONSTANTS.c_qty_ecv_exception_code
1021: FROM DUAL
1022: WHERE p_qty_rcv_exception_code_tbl(i) IS NOT NULL
1023: AND NOT EXISTS(
1024: SELECT 1
1025: FROM po_lookup_codes plc
1416: 'RECEIVING_ROUTING_ID',
1417: p_receiving_routing_id_tbl(i),
1418: 'RECEIVING_ROUTING_ID',
1419: p_receiving_routing_id_tbl(i)
1420: FROM DUAL
1421: WHERE p_receiving_routing_id_tbl(i) IS NOT NULL
1422: AND p_shipment_type_tbl(i) = 'STANDARD'
1423: AND NOT EXISTS(SELECT 1
1424: FROM rcv_routing_headers rrh
1536: p_style_id_tbl(i),
1537: 'STYLE_ID',
1538: p_style_id_tbl(i),
1539: PO_VAL_CONSTANTS.c_loc_style_related_info
1540: FROM DUAL
1541: WHERE EXISTS(SELECT 1
1542: FROM po_doc_style_headers pdsh
1543: WHERE pdsh.style_id = p_style_id_tbl(i) AND
1544: NVL(pdsh.price_breaks_flag, 'N') = 'N');
1614: p_tax_name_tbl(i),
1615: 'VALUE',
1616: p_tax_name_tbl(i),
1617: PO_VAL_CONSTANTS.c_tax_name
1618: FROM DUAL
1619: WHERE p_tax_name_tbl(i) IS NOT NULL
1620: AND p_tax_code_id_tbl(i) IS NULL
1621: AND NOT EXISTS(SELECT 'Y'
1622: FROM ZX_INPUT_CLASSIFICATIONS_V zicv
1657: p_tax_name_tbl(i),
1658: 'VALUE',
1659: p_tax_name_tbl(i),
1660: PO_VAL_CONSTANTS.c_tax_name
1661: FROM DUAL
1662: WHERE p_tax_code_id_tbl(i) IS NOT NULL
1663: AND p_tax_name_tbl(i) IS NOT NULL
1664: AND NOT EXISTS(SELECT 'Y'
1665: FROM ZX_ID_TCC_MAPPING
1738: p_fob_lookup_code_tbl(i),
1739: 'VALUE',
1740: p_fob_lookup_code_tbl(i),
1741: PO_VAL_CONSTANTS.c_loc_fob_lookup_code
1742: FROM DUAL
1743: WHERE p_fob_lookup_code_tbl(i) IS NOT NULL
1744: AND NOT EXISTS(SELECT 1
1745: FROM PO_LOOKUP_CODES
1746: WHERE lookup_type = 'FOB' AND
1809: p_freight_terms_tbl(i),
1810: 'VALUE',
1811: p_freight_terms_tbl(i),
1812: PO_VAL_CONSTANTS.c_loc_freight_terms
1813: FROM DUAL
1814: WHERE p_freight_terms_tbl(i) IS NOT NULL
1815: AND NOT EXISTS(SELECT 1
1816: FROM PO_LOOKUP_CODES
1817: WHERE lookup_type = 'FREIGHT TERMS' AND
1882: p_freight_carrier_tbl(i),
1883: 'VALUE',
1884: p_freight_carrier_tbl(i),
1885: PO_VAL_CONSTANTS.c_loc_freight_carrier
1886: FROM DUAL
1887: WHERE p_freight_carrier_tbl(i) IS NOT NULL
1888: AND NOT EXISTS(SELECT 1
1889: FROM ORG_FREIGHT
1890: WHERE freight_code = p_freight_carrier_tbl(i) AND