DBA Data[Home] [Help]

APPS.FTE_FREIGHT_PRICING dependencies on MTL_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

Line 1928: FROM mtl_categories_b

1924:
1925: CURSOR c_get_def_category(c_classification_code VARCHAR2, c_structure_id NUMBER)
1926: IS
1927: SELECT category_id
1928: FROM mtl_categories_b
1929: WHERE segment1=c_classification_code
1930: AND segment4='Y'
1931: AND structure_id=c_structure_id;
1932: