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.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on AHL_WORKORDER_OPERATIONS

Line 624: AHL_WORKORDER_OPERATIONS OP,

620: c_visit_id NUMBER) IS
621: SELECT OP.operation_sequence_num, DECODE(APC.part_change_type, 'R', APC.removal_date, 'I', APC.installation_date),
622: APC.removal_code,REM.meaning,APC.removal_reason_id,RSN.reason_name,APC.removed_instance_id
623: FROM AHL_PART_CHANGES APC,
624: AHL_WORKORDER_OPERATIONS OP,
625: MTL_TRANSACTION_REASONS RSN,
626: FND_LOOKUPS REM
627: WHERE APC.part_change_id = (SELECT max(APC1.part_change_id)
628: FROM AHL_PART_CHANGES APC1,

Line 629: AHL_WORKORDER_OPERATIONS OP1

625: MTL_TRANSACTION_REASONS RSN,
626: FND_LOOKUPS REM
627: WHERE APC.part_change_id = (SELECT max(APC1.part_change_id)
628: FROM AHL_PART_CHANGES APC1,
629: AHL_WORKORDER_OPERATIONS OP1
630: WHERE APC1.unit_config_header_id = p_unit_header_id
631: AND APC1.mc_relationship_id = c_path_position_id -- Table AHL_PART_CHANGES stores path position id in mc_relationship_id field
632: AND APC1.part_change_type = p_bulk_process_flag
633: AND DECODE(APC1.part_change_type, 'R', nvl(c_instance_id,-1), 'I', APC1.installed_instance_id) = nvl(c_instance_id,-1)

Line 1599: AHL_WORKORDER_OPERATIONS OP

1595: c_instance_id NUMBER) IS
1596: SELECT OP.operation_sequence_num,
1597: APC.installation_date
1598: FROM AHL_PART_CHANGES APC,
1599: AHL_WORKORDER_OPERATIONS OP
1600: WHERE APC.part_change_id = (SELECT max(APC1.part_change_id)
1601: FROM AHL_PART_CHANGES APC1,
1602: AHL_WORKORDER_OPERATIONS OP1
1603: WHERE APC1.unit_config_header_id = p_unit_header_id

Line 1602: AHL_WORKORDER_OPERATIONS OP1

1598: FROM AHL_PART_CHANGES APC,
1599: AHL_WORKORDER_OPERATIONS OP
1600: WHERE APC.part_change_id = (SELECT max(APC1.part_change_id)
1601: FROM AHL_PART_CHANGES APC1,
1602: AHL_WORKORDER_OPERATIONS OP1
1603: WHERE APC1.unit_config_header_id = p_unit_header_id
1604: AND APC1.mc_relationship_id = c_path_position_id -- Table AHL_PART_CHANGES stores path position id in mc_relationship_id field
1605: AND APC1.part_change_type = 'I'
1606: AND APC1.installed_instance_id = c_instance_id