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.IBE_CCTBOM_PVT dependencies on BOM_STRUCTURES_B

Line 17: (SELECT bill_sequence_id FROM bom_structures_b

13:
14: cursor l_option_class_csr IS
15: SELECT component_item_id,optional,bom_item_type FROM BOM_EXPLOSIONS
16: WHERE top_bill_sequence_id =
17: (SELECT bill_sequence_id FROM bom_structures_b
18: WHERE assembly_item_id = p_model_id
19: AND organization_id = p_organization_id
20: AND alternate_bom_designator IS NULL)
21: AND EXPLOSION_TYPE = 'ALL'

Line 57: FROM bom_structures_b

53: SELECT count(component_item_id) into l_total_component_items
54: FROM BOM_EXPLOSIONS
55: WHERE top_bill_sequence_id =
56: (SELECT bill_sequence_id
57: FROM bom_structures_b
58: WHERE assembly_item_id = p_model_id
59: AND organization_id = p_organization_id
60: AND alternate_bom_designator IS NULL)
61: AND EXPLOSION_TYPE = 'ALL'

Line 76: FROM bom_structures_b

72: SELECT component_item_id, optional into l_item_id,l_optional
73: FROM BOM_EXPLOSIONS
74: WHERE top_bill_sequence_id =
75: (SELECT bill_sequence_id
76: FROM bom_structures_b
77: WHERE assembly_item_id = p_model_id
78: AND organization_id = p_organization_id
79: AND alternate_bom_designator IS NULL)
80: AND EXPLOSION_TYPE = 'ALL'

Line 389: (SELECT bill_sequence_id FROM bom_structures_b

385: COMPONENT_QUANTITY,
386: COMPONENT_CODE
387: FROM BOM_EXPLOSIONS
388: WHERE top_bill_sequence_id =
389: (SELECT bill_sequence_id FROM bom_structures_b
390: WHERE assembly_item_id = p_model_id
391: AND organization_id = p_organization_id
392: AND alternate_bom_designator IS NULL)
393: AND ORGANIZATION_ID = p_organization_id --gzhang 01/16/2003, bug#2750492