APPS.BOM_DELETE_ITEMS dependencies on MTL_CATALOG_SEARCH_ITEMS

Line 209: -- CATALOG SEARCH: GET ITEMS FROM MTL_CATALOG_SEARCH_ITEMS

205: END IF;
206:
207: IF process_type = 1 THEN
208:
209: -- CATALOG SEARCH: GET ITEMS FROM MTL_CATALOG_SEARCH_ITEMS
210:
211: IF catalog_search_id > 0 THEN
212: stmt_num := 4;
213:

Line 256: MTL_CATALOG_SEARCH_ITEMS MCSI,

252: SYSDATE,
253: userid,
254: last_login_id
255: FROM
256: MTL_CATALOG_SEARCH_ITEMS MCSI,
257: MTL_SYSTEM_ITEMS MSI,
258: MTL_ITEM_FLEXFIELDS MIF
259: WHERE MSI.INVENTORY_ITEM_ID = MCSI.INVENTORY_ITEM_ID
260: AND MSI.ORGANIZATION_ID = MCSI.ORGANIZATION_ID

Line 273: DELETE MTL_CATALOG_SEARCH_ITEMS

269: FROM BOM_DELETE_ENTITIES
270: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id
271: AND ORGANIZATION_ID = org_id);
272:
273: DELETE MTL_CATALOG_SEARCH_ITEMS
274: WHERE GROUP_HANDLE_ID = catalog_search_id;
275:
276: -- CASE 2 BOM
277: -- CASE 4 COMPONENT

Line 317: MTL_CATALOG_SEARCH_ITEMS MCSI,

313: SYSDATE,
314: userid,
315: last_login_id
316: FROM
317: MTL_CATALOG_SEARCH_ITEMS MCSI,
318: BOM_BILL_OF_MATERIALS BOM,
319: MTL_ITEM_FLEXFIELDS MIF
320: WHERE MCSI.INVENTORY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID
321: AND MCSI.ORGANIZATION_ID = BOM.ORGANIZATION_ID

Line 332: DELETE MTL_CATALOG_SEARCH_ITEMS

328: SELECT NVL(BILL_SEQUENCE_ID, 0)
329: FROM BOM_DELETE_ENTITIES
330: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id);
331:
332: DELETE MTL_CATALOG_SEARCH_ITEMS
333: WHERE GROUP_HANDLE_ID = catalog_search_id;
334:
335: -- CASE 3 ROUTING
336: -- CASE 5 OPERATION

Line 376: MTL_CATALOG_SEARCH_ITEMS MCSI,

372: SYSDATE,
373: userid,
374: last_login_id
375: FROM
376: MTL_CATALOG_SEARCH_ITEMS MCSI,
377: BOM_OPERATIONAL_ROUTINGS BOR,
378: MTL_ITEM_FLEXFIELDS MIF
379: WHERE MCSI.ORGANIZATION_ID = org_id
380: AND MCSI.INVENTORY_ITEM_ID = BOR.ASSEMBLY_ITEM_ID

Line 391: DELETE MTL_CATALOG_SEARCH_ITEMS

387: SELECT NVL(ROUTING_SEQUENCE_ID, 0)
388: FROM BOM_DELETE_ENTITIES
389: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id
390: AND ORGANIZATION_ID = org_id);
391: DELETE MTL_CATALOG_SEARCH_ITEMS
392: WHERE GROUP_HANDLE_ID = catalog_search_id;
393:
394: ELSE
395: var_text := 'catalog search id';