[Home] [Help]
771: ' mif.purchasing_item_flag "PURCHASING ITEM FLAG", '||
772: ' mif.customer_order_flag "CUSTOMER ORDER FLAG", '||
773: ' mif.internal_order_flag "INTERNAL ORDER FLAG", '||
774: ' mif.invoiceable_item_flag "INVOICEABLE ITEM FLAG", '||
775: ' decode(mif.bom_item_type,1,''Model'',2,''Option Class'',3,''Planning'',4,''Standard'',5,''Product Family'') "BOM ITEM TYPE", '||
776: ' decode(stock_enabled_flag,inventory_item_flag,null,''N'',null,''Y'',stock_enabled_flag) "STOCK ENABLED FLAG", '||
777: ' decode(mtl_transactions_enabled_flag,stock_enabled_flag,null,''N'',null,''Y'',mtl_transactions_enabled_flag) "MTL TRANSACTIONS ENABLED FLAG", '||
778: ' decode(purchasing_enabled_flag,purchasing_item_flag,null,''N'',null,''Y'',purchasing_enabled_flag) "PURCHASING ENABLED FLAG", '||
779: ' decode(customer_order_enabled_flag,customer_order_flag,null,''N'',null,''Y'',customer_order_enabled_flag) "CUSTOMER ORDER ENABLED FLAG", '||
820:
3. Purchasable (purchasing_enabled_flag) Must be set to No
821:
If Purchased (purchasing_item_flag) is set to No.
822:
4. Build in WIP (build_in_wip_flag) Must be set to No
823:
If Inventory Item (inventory_item_flag) is set to No
824:
OR BOM Item Type (bom_item_type) is NOT set to Standard.
825:
5. Customer Orders Enabled (customer_order_enabled_flag) Must be set to No
826:
If Customer Ordered Item (customer_order_flag) is set to No.
827:
6. Internal Orders Enabled (internal_order_enabled_flag) Must be set to No
828:
If Internal Ordered Item (internal_order_flag) is set to No.
996:
');
997:
998: reportStr := '
ACTION:
999:
These two date fields have to be nulled out.
1000:
Nulling them out will not effect any standard functionality in Items form.
1001:
Please use the below update statements to null out these two date fields.
1002:
Important: Please try these scripts on a TEST instance first.
1003:
1004: The below update statement can be used to correct a specific item.