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.INV_EBI_CHANGE_ORDER_HELPER dependencies on BOM_REFERENCE_DESIGNATORS

Line 1360: bom_reference_designators

1356: IS
1357: SELECT
1358: component_reference_designator reference_designator_name
1359: FROM
1360: bom_reference_designators
1361: WHERE
1362: component_sequence_id = p_component_sequence_id
1363: AND NVL(acd_type,1) = 1; --Only added components are taken
1364:

Line 1417: bom_reference_designators

1413: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.new_routing_revision) new_routing_revision
1414: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.return_status) return_status
1415: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.row_identifier ) row_identifier
1416: FROM
1417: bom_reference_designators
1418: WHERE
1419: component_reference_designator = p_ref_designator_name AND
1420: component_sequence_id = p_component_sequence_id;
1421:

Line 5254: ,bom_reference_designators brd

5250: ,brd.original_system_reference
5251: FROM
5252: bom_inventory_components bic
5253: ,eng_revised_items eri
5254: ,bom_reference_designators brd
5255: WHERE
5256: eri.change_id = p_change_id AND
5257: eri.revised_item_id = p_revised_item_id AND
5258: bic.component_item_id = p_component_id AND