DBA Data[Home] [Help]

APPS.INVATTR dependencies on MTL_SYSTEM_ITEMS

Line 17: from mtl_system_items

13: INVOICEABLE_ITEM_FLAG,
14: BOM_ITEM_TYPE,
15: CUSTOMER_ORDER_FLAG,
16: INTERNAL_ORDER_FLAG
17: from mtl_system_items
18: where inventory_item_id = item_id
19: and organization_id in ( select organization_id
20: from mtl_parameters where master_organization_id =master_org_id
21: and organization_id <> master_org_id);

Line 137: update mtl_system_items

133: else
134: B_BUILD_IN_WIP := 'Z' ;
135: end if ;
136:
137: update mtl_system_items
138: set
139: stock_enabled_flag = decode(B_STOCK_ENABLED,'N','N',stock_enabled_flag),
140: mtl_transactions_enabled_flag = decode(B_MTL_TRANSACTIONS_ENABLED,'N','N',mtl_transactions_enabled_flag),
141: purchasing_enabled_flag = decode(B_PURCHASING_ENABLED,'N','N',purchasing_enabled_flag),