APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on MTL_ITEM_CATEGORIES

Line 71: FROM mtl_item_categories itemcat

67: b_changed VARCHAR2, b_last_run_date DATE, b_category_id NUMBER)
68: IS
69: SELECT csm_mtl_system_items_acc_s.NEXTVAL, itemcat.inventory_item_id,
70: itemcat.organization_id, b_user_id
71: FROM mtl_item_categories itemcat
72: WHERE itemcat.category_id = b_category_id
73: AND itemcat.organization_id = b_organization_id
74: AND NOT EXISTS
75: (SELECT 1

Line 88: FROM mtl_item_categories itemcat

84: b_changed VARCHAR2, b_last_run_date DATE, b_category_set_id NUMBER)
85: IS
86: SELECT csm_mtl_system_items_acc_s.NEXTVAL, itemcat.inventory_item_id,
87: itemcat.organization_id, b_user_id
88: FROM mtl_item_categories itemcat
89: WHERE itemcat.category_set_id = b_category_set_id
90: AND itemcat.organization_id = b_organization_id
91: AND NOT EXISTS
92: (SELECT 1

Line 105: FROM mtl_item_categories itemcat

101: b_changed VARCHAR2, b_last_run_date DATE, b_category_id NUMBER, b_category_set_id NUMBER)
102: IS
103: SELECT csm_mtl_system_items_acc_s.NEXTVAL, itemcat.inventory_item_id,
104: itemcat.organization_id, b_user_id
105: FROM mtl_item_categories itemcat
106: WHERE itemcat.category_set_id = b_category_set_id
107: AND itemcat.category_id = b_category_id
108: AND itemcat.organization_id = b_organization_id
109: AND NOT EXISTS

Line 263: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';

259: IF (l_stmt1 IS NOT NULL) THEN
260: l_stmt := l_stmt || ' AND ';
261: l_stmt := l_stmt || ' inventory_item_id IN';
262: l_stmt := l_stmt || ' (SELECT inventory_item_id';
263: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';
264: l_stmt := l_stmt || ' WHERE ' || l_stmt1;
265: l_stmt := l_stmt || ' AND itemcat.organization_id = :3 )';
266: END IF;
267:

Line 300: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';

296:
297: IF (l_stmt1 IS NOT NULL) THEN
298: l_stmt := l_stmt || ' AND NOT EXISTS ';
299: l_stmt := l_stmt || ' (SELECT 1';
300: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';
301: l_stmt := l_stmt || ' WHERE ' || l_stmt1;
302: l_stmt := l_stmt || ' AND itemcat.organization_id = :3 ';
303: l_stmt := l_stmt || ' AND acc.inventory_item_id = itemcat.inventory_item_id) ';
304: l_stmt := l_stmt || ' AND NOT EXISTS ';

Line 891: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';

887:
888: IF (l_stmt1 IS NOT NULL) THEN
889: l_stmt := l_stmt || ' AND EXISTS (';
890: l_stmt := l_stmt || ' SELECT 1 ';
891: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';
892: l_stmt := l_stmt || ' WHERE ' || l_stmt1;
893: l_stmt := l_stmt || ' AND itemcat.organization_id = :3 ';
894: l_stmt := l_stmt || ' AND acc.inventory_item_id = itemcat.inventory_item_id )';
895: END IF;