[Home] [Help]
719: ' mif.purchasing_item_flag "PURCHASING ITEM FLAG", '||
720: ' mif.customer_order_flag "CUSTOMER ORDER FLAG", '||
721: ' mif.internal_order_flag "INTERNAL ORDER FLAG", '||
722: ' mif.invoiceable_item_flag "INVOICEABLE ITEM FLAG", '||
723: ' decode(mif.bom_item_type,1,''Model'',2,''Option Class'',3,''Planning'',4,''Standard'',5,''Product Family'') "BOM ITEM TYPE", '||
724: ' decode(stock_enabled_flag,inventory_item_flag,null,''N'',null,''Y'',stock_enabled_flag) "STOCK ENABLED FLAG", '||
725: ' decode(mtl_transactions_enabled_flag,stock_enabled_flag,null,''N'',null,''Y'',mtl_transactions_enabled_flag) "MTL TRANSACTIONS ENABLED FLAG", '||
726: ' decode(purchasing_enabled_flag,purchasing_item_flag,null,''N'',null,''Y'',purchasing_enabled_flag) "PURCHASING ENABLED FLAG", '||
727: ' decode(customer_order_enabled_flag,customer_order_flag,null,''N'',null,''Y'',customer_order_enabled_flag) "CUSTOMER ORDER ENABLED FLAG", '||
768:
3. Purchasable (purchasing_enabled_flag) Must be set to No
769:
If Purchased (purchasing_item_flag) is set to No.
770:
4. Build in WIP (build_in_wip_flag) Must be set to No
771:
If Inventory Item (inventory_item_flag) is set to No
772:
OR BOM Item Type (bom_item_type) is NOT set to Standard.
773:
5. Customer Orders Enabled (customer_order_enabled_flag) Must be set to No
774:
If Customer Ordered Item (customer_order_flag) is set to No.
775:
6. Internal Orders Enabled (internal_order_enabled_flag) Must be set to No
776:
If Internal Ordered Item (internal_order_flag) is set to No.
944:
');
945:
946: reportStr := '
ACTION:
947:
These two date fields have to be nulled out.
948:
Nulling them out will not effect any standard functionality in Items form.
949:
Please use the below update statements to null out these two date fields.
950:
Important: Please try these scripts on a TEST instance first.
951:
952: The below update statement can be used to correct a specific item.