eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INVIDIT1 dependencies on MTL_SYSTEM_ITEMS

Line 361: if v_status_attr = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then

357: LOOP
358: FETCH status_attr_control INTO v_status_attr, v_status_ctrl;
359: EXIT when status_attr_control%NOTFOUND;
360:
361: if v_status_attr = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then
362: X_bom_enabled_status := v_status_ctrl;
363:
364: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' then
365: X_purchasable_status := v_status_ctrl;

Line 364: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' then

360:
361: if v_status_attr = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then
362: X_bom_enabled_status := v_status_ctrl;
363:
364: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' then
365: X_purchasable_status := v_status_ctrl;
366:
367: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' then
368: X_transactable_status := v_status_ctrl;

Line 367: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' then

363:
364: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' then
365: X_purchasable_status := v_status_ctrl;
366:
367: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' then
368: X_transactable_status := v_status_ctrl;
369:
370: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' then
371: X_stockable_status := v_status_ctrl;

Line 370: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' then

366:
367: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' then
368: X_transactable_status := v_status_ctrl;
369:
370: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' then
371: X_stockable_status := v_status_ctrl;
372:
373: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then
374: X_wip_status := v_status_ctrl;

Line 373: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then

369:
370: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' then
371: X_stockable_status := v_status_ctrl;
372:
373: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then
374: X_wip_status := v_status_ctrl;
375:
376: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' then
377: X_cust_ord_status := v_status_ctrl;

Line 376: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' then

372:
373: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then
374: X_wip_status := v_status_ctrl;
375:
376: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' then
377: X_cust_ord_status := v_status_ctrl;
378:
379: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' then
380: X_int_ord_status := v_status_ctrl;

Line 379: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' then

375:
376: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' then
377: X_cust_ord_status := v_status_ctrl;
378:
379: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' then
380: X_int_ord_status := v_status_ctrl;
381:
382: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' then
383: X_invoiceable_status := v_status_ctrl;

Line 382: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' then

378:
379: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' then
380: X_int_ord_status := v_status_ctrl;
381:
382: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' then
383: X_invoiceable_status := v_status_ctrl;
384: /* Start Bug 3713912 */
385: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG' then
386: X_recipe_enabled_status := v_status_ctrl;

Line 385: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG' then

381:
382: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' then
383: X_invoiceable_status := v_status_ctrl;
384: /* Start Bug 3713912 */
385: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG' then
386: X_recipe_enabled_status := v_status_ctrl;
387: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG' then
388: X_process_exec_enabled_status := v_status_ctrl;
389: /* End Bug 3713912 */

Line 387: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG' then

383: X_invoiceable_status := v_status_ctrl;
384: /* Start Bug 3713912 */
385: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG' then
386: X_recipe_enabled_status := v_status_ctrl;
387: elsif v_status_attr = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG' then
388: X_process_exec_enabled_status := v_status_ctrl;
389: /* End Bug 3713912 */
390:
391: end if;

Line 1088: FROM mtl_system_items

1084: IF x_secondary_uom_class IS NULL THEN
1085: BEGIN
1086: SELECT secondary_uom_code
1087: INTO l_sec_uom_code
1088: FROM mtl_system_items
1089: WHERE inventory_item_id = X_item_id
1090: AND secondary_uom_code IS NOT NULL
1091: AND rownum = 1;
1092: EXCEPTION

Line 1223: from mtl_system_items

1219: into source_item
1220: from dual
1221: where X_source_org in (
1222: select organization_id
1223: from mtl_system_items
1224: where (inventory_item_id = nvl(X_new_item_id, -11)
1225: or inventory_item_id = nvl(X_item_id, -11))
1226: )
1227: and rownum = 1;

Line 1235: from mtl_system_items_b

1231: Note that source_org is already validated against OOD view in INVPVD6B.pls*/
1232:
1233: select count(1)
1234: into source_item
1235: from mtl_system_items_b
1236: where (inventory_item_id = nvl(X_new_item_id, -11)
1237: or inventory_item_id = nvl(X_item_id, -11))
1238: and organization_id= X_source_org;
1239:

Line 1340: ' FROM MTL_SYSTEM_ITEMS_VL MSI '||

1336: sql_stmt := 'INSERT INTO MTL_CATALOG_SEARCH_ITEMS ( ' ||
1337: ' SELECT :handle, MSI.INVENTORY_ITEM_ID, '||
1338: ' MSI.ORGANIZATION_ID,MSI.DESCRIPTION, '||
1339: ' MSI.PRIMARY_UOM_CODE, MSI.RESERVABLE_TYPE '||
1340: ' FROM MTL_SYSTEM_ITEMS_VL MSI '||
1341: ' WHERE 1= 1 ';
1342:
1343: IF p_org_id IS NOT NULL THEN
1344: sql_stmt := sql_stmt || ' AND MSI.ORGANIZATION_ID = :p_org_id ';