DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on ORG_FREIGHT

Line 1840: -- freight_carrier must be valid in ORG_FREIGHT

1836:
1837: END freight_terms;
1838:
1839: -------------------------------------------------------------------------
1840: -- freight_carrier must be valid in ORG_FREIGHT
1841: -------------------------------------------------------------------------
1842: PROCEDURE freight_carrier(p_id_tbl IN po_tbl_number,
1843: p_freight_carrier_tbl IN po_tbl_varchar30,
1844: p_inventory_org_id IN NUMBER,

Line 1889: FROM ORG_FREIGHT

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
1891: organization_id = p_inventory_org_id AND
1892: nvl(disable_date, sysdate + 1) > sysdate);
1893: