APPS.INVIDIT3 dependencies on MTL_SYSTEM_ITEMS_B

Line 233: ,'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'

229: ,'MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG'
230: ,'MTL_SYSTEM_ITEMS.RESERVABLE_TYPE'
231: ,'MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG'
232: ,'MTL_SYSTEM_ITEMS.SO_TRANSACTIONS_FLAG'
233: ,'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
234: ,'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG')) -- bug 6501149
235: LOOP
236: IF cur.attribute_name = 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE' THEN
237: lot_level := cur.control_level;

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

268: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG' THEN
269: ship_item_level := cur.control_level;
270: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.SO_TRANSACTIONS_FLAG' THEN
271: transaction_level := cur.control_level;
272: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
273: bom_enabled_level := cur.control_level;
274: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG' THEN
275: inv_asset_level := cur.control_level;
276: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' THEN

Line 1479: FROM mtl_system_items_b

1475: CURSOR c_get_item_status(cp_inventory_item_id NUMBER
1476: ,cp_organization_id NUMBER)
1477: IS
1478: SELECT approval_status
1479: FROM mtl_system_items_b
1480: WHERE inventory_item_id = cp_inventory_item_id
1481: AND organization_id = cp_organization_id;
1482:
1483: l_return_value BOOLEAN := FALSE;

Line 1484: l_item_approval_status mtl_system_items_b.approval_status%TYPE;

1480: WHERE inventory_item_id = cp_inventory_item_id
1481: AND organization_id = cp_organization_id;
1482:
1483: l_return_value BOOLEAN := FALSE;
1484: l_item_approval_status mtl_system_items_b.approval_status%TYPE;
1485:
1486: BEGIN
1487:
1488: OPEN c_get_item_status(p_inventory_item_id,p_organization_id);