APPS.FTE_FREIGHT_PRICING dependencies on MTL_CATEGORY_SETS_TL

Line 30: mtl_category_sets_tl mcstl

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
34: AND mc.category_id = mic.category_id

Line 1920: FROM mtl_category_sets mcs, mtl_category_sets_tl mcst

1916:
1917: CURSOR c_get_structure_id
1918: IS
1919: SELECT structure_id
1920: FROM mtl_category_sets mcs, mtl_category_sets_tl mcst
1921: WHERE mcs.category_set_id = mcst.category_set_id
1922: AND mcst.category_set_name='WSH_COMMODITY_CODE'
1923: AND mcst.language='US';
1924: