DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on ORG_FREIGHT

Line 2263: -- freight_carrier must be valid in ORG_FREIGHT

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,

Line 2312: FROM ORG_FREIGHT

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: