DBA Data[Home] [Help]

APPS.INVIDIT1 dependencies on MTL_SYSTEM_ITEMS_B

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 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 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: