APPS.INVIDIT3 dependencies on MTL_SYSTEM_ITEMS_B

Line 247: ,'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'

243: ,'MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG'
244: ,'MTL_SYSTEM_ITEMS.RESERVABLE_TYPE'
245: ,'MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG'
246: ,'MTL_SYSTEM_ITEMS.SO_TRANSACTIONS_FLAG'
247: ,'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
248: ,'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG')) -- bug 6501149
249: LOOP
250: IF cur.attribute_name = 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE' THEN
251: lot_level := cur.control_level;

Line 286: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN

282: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG' THEN
283: ship_item_level := cur.control_level;
284: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.SO_TRANSACTIONS_FLAG' THEN
285: transaction_level := cur.control_level;
286: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
287: bom_enabled_level := cur.control_level;
288: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG' THEN
289: inv_asset_level := cur.control_level;
290: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' THEN

Line 1670: FROM mtl_system_items_b

1666: CURSOR c_get_item_status(cp_inventory_item_id NUMBER
1667: ,cp_organization_id NUMBER)
1668: IS
1669: SELECT approval_status
1670: FROM mtl_system_items_b
1671: WHERE inventory_item_id = cp_inventory_item_id
1672: AND organization_id = cp_organization_id;
1673:
1674: l_return_value BOOLEAN := FALSE;

Line 1675: l_item_approval_status mtl_system_items_b.approval_status%TYPE;

1671: WHERE inventory_item_id = cp_inventory_item_id
1672: AND organization_id = cp_organization_id;
1673:
1674: l_return_value BOOLEAN := FALSE;
1675: l_item_approval_status mtl_system_items_b.approval_status%TYPE;
1676:
1677: BEGIN
1678:
1679: OPEN c_get_item_status(p_inventory_item_id,p_organization_id);