eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_CHANGE_ORDER_PK dependencies on STANDARD

Line 593: AND ( item_type_code = 'STANDARD' OR item_type_code = 'OPTION' OR item_type_code = 'INCLUDED')

589: l_shipping_xfaced_flag -- Bug Fix: 4863275
590: FROM OE_ORDER_LINES_ALL
591: WHERE line_id = ato_line_id
592: --Adding item_type_code = 'INCLUDED' for Sun ER#9793792.
593: AND ( item_type_code = 'STANDARD' OR item_type_code = 'OPTION' OR item_type_code = 'INCLUDED')
594: AND line_id = pLineid;
595:
596: lconfig_line_id := PLineid; -- In case of ATO item both config id and model id are same
597:

Line 2537: AND BIC.Bom_item_type = 4 --- Standard item

2533: MTL_SYSTEM_ITEMS MTL
2534: WHERE BOM.Assembly_item_id = pInventory_item_id
2535: AND BOM.Organization_id = pOrg_id
2536: AND BOM.Bill_sequence_id = BIC.Bill_sequence_id
2537: AND BIC.Bom_item_type = 4 --- Standard item
2538: AND BIC.WIP_SUPPLY_TYPE <> 6 --- Non Phantom
2539: AND MTL.Inventory_item_id = BIC.Component_item_id
2540: AND MTL.Organization_id = pOrg_id
2541: AND MTL.Base_item_id Is Not Null -- This condition tells this is a config item.