DBA Data[Home] [Help]

APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on MTL_ITEM_CATEGORIES

Line 82: FROM mtl_item_categories itemcat

78: )
79: AND msi.organization_id = b_organization_id
80: AND msi.inventory_item_id IN
81: (SELECT itemcat.inventory_item_id
82: FROM mtl_item_categories itemcat
83: WHERE itemcat.category_id = b_category_id
84: AND itemcat.organization_id = b_organization_id
85: AND (b_changed = 'Y'
86: OR itemcat.creation_date >= NVL(b_last_run_date, itemcat.CREATION_DATE)

Line 106: FROM mtl_item_categories itemcat

102: )
103: AND msi.organization_id = b_organization_id
104: AND msi.inventory_item_id IN
105: (SELECT itemcat.inventory_item_id
106: FROM mtl_item_categories itemcat
107: WHERE itemcat.category_set_id = b_category_set_id
108: AND itemcat.organization_id = b_organization_id
109: AND (b_changed = 'Y'
110: OR itemcat.creation_date >= NVL(b_last_run_date, itemcat.CREATION_DATE)

Line 130: FROM mtl_item_categories itemcat

126: )
127: AND msi.organization_id = b_organization_id
128: AND msi.inventory_item_id IN
129: (SELECT itemcat.inventory_item_id
130: FROM mtl_item_categories itemcat
131: WHERE itemcat.category_set_id = b_category_set_id
132: AND itemcat.category_id = b_category_id
133: AND itemcat.organization_id = b_organization_id
134: AND (b_changed = 'Y'

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

170: IF (l_stmt1 IS NOT NULL) THEN
171: l_stmt := l_stmt || ' AND ';
172: l_stmt := l_stmt || ' inventory_item_id IN';
173: l_stmt := l_stmt || ' (SELECT inventory_item_id';
174: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';
175: l_stmt := l_stmt || ' WHERE ' || l_stmt1;
176: l_stmt := l_stmt || ' AND itemcat.organization_id = :3 )';
177: END IF;
178:

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

207:
208: IF (l_stmt1 IS NOT NULL) THEN
209: l_stmt := l_stmt || ' AND NOT EXISTS ';
210: l_stmt := l_stmt || ' (SELECT 1';
211: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';
212: l_stmt := l_stmt || ' WHERE ' || l_stmt1;
213: l_stmt := l_stmt || ' AND itemcat.organization_id = :3 ';
214: l_stmt := l_stmt || ' AND acc.inventory_item_id = itemcat.inventory_item_id ';
215: l_stmt := l_stmt || ' UNION ';

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

551:
552: IF (l_stmt1 IS NOT NULL) THEN
553: l_stmt := l_stmt || ' AND EXISTS (';
554: l_stmt := l_stmt || ' SELECT 1 ';
555: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';
556: l_stmt := l_stmt || ' WHERE ' || l_stmt1;
557: l_stmt := l_stmt || ' AND itemcat.organization_id = :3 ';
558: l_stmt := l_stmt || ' AND acc.inventory_item_id = itemcat.inventory_item_id )';
559: END IF;