2259:
2260: END freight_terms;
2261:
2262: -------------------------------------------------------------------------
2263: -- freight_carrier must be valid in ORG_FREIGHT
2264: -------------------------------------------------------------------------
2265: PROCEDURE freight_carrier(p_id_tbl IN po_tbl_number,
2266: p_freight_carrier_tbl IN po_tbl_varchar30,
2267: p_inventory_org_id IN NUMBER,
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
2314: organization_id = p_inventory_org_id AND
2315: nvl(disable_date, sysdate + 1) > sysdate);
2316: