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_UTILITY_PK dependencies on BOM_BILL_OF_MATERIALS

Line 4513: BOM_BILL_OF_MATERIALS BOM

4509: BEGIN
4510: SELECT 'Y'
4511: INTO l_found
4512: FROM BOM_INVENTORY_COMPONENTS BIC,
4513: BOM_BILL_OF_MATERIALS BOM
4514: WHERE BIC.bill_sequence_id = BOM.Common_bill_sequence_id
4515: AND BOM.assembly_item_id = l_model_item_id
4516: AND BOM.Organization_id = p_organization_id
4517: AND BIC.component_item_id = p_inventory_item_id;

Line 4724: from bom_bill_of_materials

4720: select organization_id
4721: , assembly_item_id
4722: into v_organization_id
4723: , v_assembly_item_id
4724: from bom_bill_of_materials
4725: where bill_sequence_id = p_bill_sequence_id ;
4726:
4727:
4728: v_stmt_number := -4 ;

Line 4788: from bom_bill_of_materials

4784: v_stmt_number := -8 ;
4785:
4786: select common_bill_sequence_id
4787: into v_element_bill_seq_id
4788: from bom_bill_of_materials
4789: where assembly_item_id = v_component_item_id
4790: and organization_id = v_organization_id ;
4791:
4792:

Line 4877: bom_bill_of_materials bbom

4873: bic.item_num,
4874: xGrpId
4875: from
4876: bom_inventory_components bic,
4877: bom_bill_of_materials bbom
4878: where bbom.assembly_item_id = p_item_id
4879: and bbom.organization_id = p_org_id
4880: and bbom.alternate_bom_designator is null
4881: and bbom.common_bill_sequence_id = bic.bill_sequence_id

Line 4920: bom_bill_of_materials bbom,

4916: bic.item_num,
4917: xGrpId
4918: from
4919: bom_inventory_components bic,
4920: bom_bill_of_materials bbom,
4921: bom_explosion_temp bet,
4922: mtl_system_items msi
4923: where bbom.assembly_item_id = bet.component_item_id
4924: and bbom.organization_id = bet.organization_id