DBA Data[Home] [Help]

APPS.FTE_FREIGHT_PRICING dependencies on MTL_ITEM_CATEGORIES

Line 29: FROM mtl_categories mc, mtl_item_categories mic,

25: -- FROM wsh_global_parameters;
26:
27: CURSOR get_category(c_item_id IN NUMBER,c_org_id IN NUMBER,c_classification_code IN VARCHAR2) IS
28: SELECT mc.category_id
29: FROM mtl_categories mc, mtl_item_categories mic,
30: mtl_category_sets_tl mcstl
31: WHERE mic.inventory_item_id = c_item_id
32: AND mic.organization_id = c_org_id
33: AND mic.category_set_id = mcstl.category_set_id