[Home] [Help]
5: G_STOCK_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG';
6: G_TRANSACTIONS_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG';
7: G_PURCHASING_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG';
8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';
9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';
10: G_CUSTOMER_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG';
11: G_INTERNAL_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG';
12: G_BOM_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG';
13:
8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';
9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';
10: G_CUSTOMER_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG';
11: G_INTERNAL_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG';
12: G_BOM_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG';
13:
14: G_ITEM NUMBER := 1;
15: G_ITEM_ORG NUMBER := 2;
16: G_PWIDTH NUMBER := 132;
159: end if;
160: /* 5523531 - Condition only applies when Transactable flag of item is changed by the status */
161: SELECT count(*) INTO is_bom_enabled_upd
162: FROM mtl_status_attribute_values
163: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
164: AND attribute_value = 'N'
165: AND inventory_item_status_code = p_pending_status;
166:
167: /*commented for bug 5479302
194: Sum(Decode(mav.attribute_name,G_CUSTOMER_ENABLED ,Decode(mav.attribute_value,'N',Decode(msi.orderable_on_web_flag,'Y',1,0),0),0)) uncheck_orderable_err
195: INTO G_TRANSACTABLE
196: ,G_PURCHASABLE
197: ,G_ORDERABLE
198: FROM mtl_system_items_b msi
199: ,mtl_status_attribute_values mav
200: WHERE msi.inventory_item_id = p_Item_Id
201: AND msi.organization_id = p_Org_Id
202: AND mav.inventory_item_status_code = p_pending_status