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 4489: BOM_BILL_OF_MATERIALS BOM

4485: BEGIN
4486: SELECT 'Y'
4487: INTO l_found
4488: FROM BOM_INVENTORY_COMPONENTS BIC,
4489: BOM_BILL_OF_MATERIALS BOM
4490: WHERE BIC.bill_sequence_id = BOM.Common_bill_sequence_id
4491: AND BOM.assembly_item_id = l_model_item_id
4492: AND BOM.Organization_id = p_organization_id
4493: AND BIC.component_item_id = p_inventory_item_id;

Line 4700: from bom_bill_of_materials

4696: select organization_id
4697: , assembly_item_id
4698: into v_organization_id
4699: , v_assembly_item_id
4700: from bom_bill_of_materials
4701: where bill_sequence_id = p_bill_sequence_id ;
4702:
4703:
4704: v_stmt_number := -4 ;

Line 4764: from bom_bill_of_materials

4760: v_stmt_number := -8 ;
4761:
4762: select common_bill_sequence_id
4763: into v_element_bill_seq_id
4764: from bom_bill_of_materials
4765: where assembly_item_id = v_component_item_id
4766: and organization_id = v_organization_id ;
4767:
4768:

Line 4853: bom_bill_of_materials bbom

4849: bic.item_num,
4850: xGrpId
4851: from
4852: bom_inventory_components bic,
4853: bom_bill_of_materials bbom
4854: where bbom.assembly_item_id = p_item_id
4855: and bbom.organization_id = p_org_id
4856: and bbom.alternate_bom_designator is null
4857: and bbom.common_bill_sequence_id = bic.bill_sequence_id

Line 4896: bom_bill_of_materials bbom,

4892: bic.item_num,
4893: xGrpId
4894: from
4895: bom_inventory_components bic,
4896: bom_bill_of_materials bbom,
4897: bom_explosion_temp bet,
4898: mtl_system_items msi
4899: where bbom.assembly_item_id = bet.component_item_id
4900: and bbom.organization_id = bet.organization_id