[Home] [Help]
519: p_shipment_num_tbl(i),
520: 'VALUE',
521: p_shipment_num_tbl(i),
522: PO_VAL_CONSTANTS.c_shipment_num_unique
523: FROM DUAL
524: WHERE p_shipment_num_tbl(i) IS NOT NULL AND
525: p_po_header_id_tbl(i) IS NOT NULL AND
526: p_po_line_id_tbl(i) IS NOT NULL AND
527: p_shipment_type_tbl(i) IS NOT NULL AND
951: p_ship_to_organization_id_tbl(i),
952: 'SHIP_TO_ORGANIZATION_ID',
953: p_ship_to_organization_id_tbl(i),
954: PO_VAL_CONSTANTS.c_ship_to_organization_id
955: FROM DUAL
956: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
957: AND p_item_revision_tbl(i) IS NOT NULL
958: AND p_item_id_tbl(i) IS NOT NULL
959: AND NOT EXISTS(
992: p_ship_to_organization_id_tbl(i),
993: 'SHIP_TO_ORGANIZATION_ID',
994: p_ship_to_organization_id_tbl(i),
995: PO_VAL_CONSTANTS.c_ship_to_organization_id
996: FROM DUAL
997: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
998: AND p_item_revision_tbl(i) IS NULL
999: AND p_item_id_tbl(i) IS NOT NULL
1000: AND NOT EXISTS(SELECT 1
1030: p_ship_to_organization_id_tbl(i),
1031: 'SHIP_TO_ORGANIZATION_ID',
1032: p_ship_to_organization_id_tbl(i),
1033: PO_VAL_CONSTANTS.c_ship_to_organization_id
1034: FROM DUAL
1035: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
1036: AND p_item_id_tbl(i) IS NULL
1037: AND NOT EXISTS(
1038: SELECT 1
1069: p_ship_to_location_id_tbl(i),
1070: 'SHIP_TO_LOCATION_ID',
1071: p_ship_to_location_id_tbl(i),
1072: PO_VAL_CONSTANTS.c_loc_ship_to_loc_id_valid
1073: FROM DUAL
1074: WHERE p_ship_to_location_id_tbl(i) IS NOT NULL
1075: AND NOT EXISTS(
1076: SELECT 1
1077: FROM po_locations_val_v PLV
1381: p_qty_rcv_exception_code_tbl(i),
1382: 'QTY_RCV_EXCEPTION_CODE',
1383: p_qty_rcv_exception_code_tbl(i),
1384: PO_VAL_CONSTANTS.c_qty_ecv_exception_code
1385: FROM DUAL
1386: WHERE p_qty_rcv_exception_code_tbl(i) IS NOT NULL
1387: AND NOT EXISTS(
1388: SELECT 1
1389: FROM po_lookup_codes plc
1780: 'RECEIVING_ROUTING_ID',
1781: p_receiving_routing_id_tbl(i),
1782: 'RECEIVING_ROUTING_ID',
1783: p_receiving_routing_id_tbl(i)
1784: FROM DUAL
1785: WHERE p_receiving_routing_id_tbl(i) IS NOT NULL
1786: AND p_shipment_type_tbl(i) = 'STANDARD'
1787: AND NOT EXISTS(SELECT 1
1788: FROM rcv_routing_headers rrh
1959: p_style_id_tbl(i),
1960: 'STYLE_ID',
1961: p_style_id_tbl(i),
1962: PO_VAL_CONSTANTS.c_loc_style_related_info
1963: FROM DUAL
1964: WHERE EXISTS(SELECT 1
1965: FROM po_doc_style_headers pdsh
1966: WHERE pdsh.style_id = p_style_id_tbl(i) AND
1967: NVL(pdsh.price_breaks_flag, 'N') = 'N');
2037: p_tax_name_tbl(i),
2038: 'VALUE',
2039: p_tax_name_tbl(i),
2040: PO_VAL_CONSTANTS.c_tax_name
2041: FROM DUAL
2042: WHERE p_tax_name_tbl(i) IS NOT NULL
2043: AND p_tax_code_id_tbl(i) IS NULL
2044: AND NOT EXISTS(SELECT 'Y'
2045: FROM ZX_INPUT_CLASSIFICATIONS_V zicv
2080: p_tax_name_tbl(i),
2081: 'VALUE',
2082: p_tax_name_tbl(i),
2083: PO_VAL_CONSTANTS.c_tax_name
2084: FROM DUAL
2085: WHERE p_tax_code_id_tbl(i) IS NOT NULL
2086: AND p_tax_name_tbl(i) IS NOT NULL
2087: AND NOT EXISTS(SELECT 'Y'
2088: FROM ZX_ID_TCC_MAPPING
2161: p_fob_lookup_code_tbl(i),
2162: 'VALUE',
2163: p_fob_lookup_code_tbl(i),
2164: PO_VAL_CONSTANTS.c_loc_fob_lookup_code
2165: FROM DUAL
2166: WHERE p_fob_lookup_code_tbl(i) IS NOT NULL
2167: AND NOT EXISTS(SELECT 1
2168: FROM PO_LOOKUP_CODES
2169: WHERE lookup_type = 'FOB' AND
2232: p_freight_terms_tbl(i),
2233: 'VALUE',
2234: p_freight_terms_tbl(i),
2235: PO_VAL_CONSTANTS.c_loc_freight_terms
2236: FROM DUAL
2237: WHERE p_freight_terms_tbl(i) IS NOT NULL
2238: AND NOT EXISTS(SELECT 1
2239: FROM PO_LOOKUP_CODES
2240: WHERE lookup_type = 'FREIGHT TERMS' AND
2305: p_freight_carrier_tbl(i),
2306: 'VALUE',
2307: p_freight_carrier_tbl(i),
2308: PO_VAL_CONSTANTS.c_loc_freight_carrier
2309: FROM DUAL
2310: WHERE p_freight_carrier_tbl(i) IS NOT NULL
2311: AND NOT EXISTS(SELECT 1
2312: FROM ORG_FREIGHT
2313: WHERE freight_code = p_freight_carrier_tbl(i) AND