APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_ITEM_CATEGORIES

Line 983: from mtl_item_categories

979: delete from csp_excess_lists cel
980: where cel.excess_status = 'P'
981: and cel.inventory_item_id in
982: (select inventory_item_id
983: from mtl_item_categories
984: where category_set_id = br_rec.category_set_id
985: and category_id = nvl(br_rec.category_id,category_id)
986: and organization_id = cel.organization_id);
987: end if;

Line 2260: from MTL_ITEM_CATEGORIES

2256: and nvl(end_active_date, sysdate + 1)
2257: union
2258: select rule_id from csp_return_routing_rules
2259: where inv_cat_set_id in (select distinct category_set_id
2260: from MTL_ITEM_CATEGORIES
2261: where inventory_item_id = v_item_id
2262: and organization_id = v_source_org_id)
2263: and nvl(source_type, 'I') = 'I' and enabled = 'Y'
2264: and sysdate between nvl(start_active_date, sysdate)

Line 2269: from MTL_ITEM_CATEGORIES

2265: and nvl(end_active_date, sysdate + 1)
2266: union
2267: select rule_id from csp_return_routing_rules
2268: where inv_cat_id in (select distinct category_id
2269: from MTL_ITEM_CATEGORIES
2270: where inventory_item_id = v_item_id
2271: and organization_id = v_source_org_id)
2272: and nvl(source_type, 'I') = 'I' and enabled = 'Y'
2273: and sysdate between nvl(start_active_date, sysdate)

Line 2293: MTL_ITEM_CATEGORIES mtl

2289: and decode(inv_cat_id, 0, null, inv_cat_id) is null
2290: and decode(inv_item_id, 0, null, inv_item_id) is null
2291: ) prob,
2292: csp_return_routing_rules r,
2293: MTL_ITEM_CATEGORIES mtl
2294: where r.rule_id = prob.rule_id
2295: and mtl.inventory_item_id = v_item_id
2296: and mtl.organization_id = v_source_org_id
2297: and nvl(decode(r.source_org_id, 0, null, r.source_org_id), v_source_org_id) = v_source_org_id

Line 2336: from MTL_ITEM_CATEGORIES

2332: and nvl(end_active_date, sysdate + 1)
2333: union
2334: select rule_id from csp_return_routing_rules
2335: where inv_cat_set_id in (select distinct category_set_id
2336: from MTL_ITEM_CATEGORIES
2337: where inventory_item_id = v_item_id
2338: and organization_id = cs_std.get_item_valdn_orgzn_id)
2339: and nvl(source_type, v_source_terr_type) = v_source_terr_type and enabled = 'Y'
2340: and sysdate between nvl(start_active_date, sysdate)

Line 2345: from MTL_ITEM_CATEGORIES

2341: and nvl(end_active_date, sysdate + 1)
2342: union
2343: select rule_id from csp_return_routing_rules
2344: where inv_cat_id in (select distinct category_id
2345: from MTL_ITEM_CATEGORIES
2346: where inventory_item_id = v_item_id
2347: and organization_id = cs_std.get_item_valdn_orgzn_id)
2348: and nvl(source_type, v_source_terr_type) = v_source_terr_type and enabled = 'Y'
2349: and sysdate between nvl(start_active_date, sysdate)

Line 2368: MTL_ITEM_CATEGORIES mtl

2364: and decode(inv_cat_id, 0, null, inv_cat_id) is null
2365: and decode(inv_item_id, 0, null, inv_item_id) is null
2366: ) prob,
2367: csp_return_routing_rules r,
2368: MTL_ITEM_CATEGORIES mtl
2369: where r.rule_id = prob.rule_id
2370: and mtl.inventory_item_id = v_item_id
2371: and mtl.organization_id = cs_std.get_item_valdn_orgzn_id
2372: and nvl(decode(r.source_terr_id, 0, null, r.source_terr_id), v_source_terr_id) = v_source_terr_id