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

Line 4147: FROM BOM_STRUCTURES_B

4143: THEN
4144: l_bill_sequence_id := p_bill_sequence_id;
4145: SELECT effectivity_control
4146: INTO l_effectivity_control
4147: FROM BOM_STRUCTURES_B
4148: WHERE bill_sequence_id = p_bill_sequence_id;
4149: ELSE
4150: SELECT bill_sequence_id, effectivity_control
4151: INTO l_bill_sequence_id, l_effectivity_control

Line 4152: FROM BOM_STRUCTURES_B

4148: WHERE bill_sequence_id = p_bill_sequence_id;
4149: ELSE
4150: SELECT bill_sequence_id, effectivity_control
4151: INTO l_bill_sequence_id, l_effectivity_control
4152: FROM BOM_STRUCTURES_B
4153: WHERE assembly_item_id = p_assembly_item_id
4154: AND organization_id = p_organization_id
4155: AND ((alternate_bom_designator IS NULL AND
4156: p_alternate_bom_designator IS NULL) OR

Line 4431: FROM BOM_STRUCTURES_B

4427: THEN
4428: l_bill_sequence_id := p_bill_sequence_id;
4429: SELECT effectivity_control, alternate_bom_Designator
4430: INTO l_effectivity_control, l_alt_bom_designator
4431: FROM BOM_STRUCTURES_B
4432: WHERE bill_sequence_id = p_bill_sequence_id;
4433: ELSE
4434: SELECT bill_sequence_id, effectivity_control
4435: INTO l_bill_sequence_id, l_effectivity_control

Line 4436: FROM BOM_STRUCTURES_B

4432: WHERE bill_sequence_id = p_bill_sequence_id;
4433: ELSE
4434: SELECT bill_sequence_id, effectivity_control
4435: INTO l_bill_sequence_id, l_effectivity_control
4436: FROM BOM_STRUCTURES_B
4437: WHERE assembly_item_id = p_assembly_item_id
4438: AND organization_id = p_organization_id
4439: AND ((alternate_bom_designator IS NULL AND
4440: p_alternate_bom_designator IS NULL) OR