APPS.CTO_CHANGE_ORDER_PK dependencies on STANDARD

Line 591: AND ( item_type_code = 'STANDARD' OR item_type_code = 'OPTION' )

587: l_source_type_code,
588: l_shipping_xfaced_flag -- Bug Fix: 4863275
589: FROM OE_ORDER_LINES_ALL
590: WHERE line_id = ato_line_id
591: AND ( item_type_code = 'STANDARD' OR item_type_code = 'OPTION' )
592: AND line_id = pLineid;
593:
594: lconfig_line_id := PLineid; -- In case of ATO item both config id and model id are same
595:

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

2296: MTL_SYSTEM_ITEMS MTL
2297: WHERE BOM.Assembly_item_id = pInventory_item_id
2298: AND BOM.Organization_id = pOrg_id
2299: AND BOM.Bill_sequence_id = BIC.Bill_sequence_id
2300: AND BIC.Bom_item_type = 4 --- Standard item
2301: AND BIC.WIP_SUPPLY_TYPE <> 6 --- Non Phantom
2302: AND MTL.Inventory_item_id = BIC.Component_item_id
2303: AND MTL.Organization_id = pOrg_id
2304: AND MTL.Base_item_id Is Not Null -- This condition tells this is a config item.