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_DISP_UTIL_PVT dependencies on FND_LOOKUP_VALUES

Line 852: FND_LOOKUP_VALUES_VL PCODE

848: PCODE.MEANING PROBLEM_MEANING,
849: INC.SUMMARY
850: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_MC_PATH_POSITIONS pp,
851: CS_INCIDENTS_ALL_VL INC, CS_INCIDENT_SEVERITIES_VL SEV,
852: FND_LOOKUP_VALUES_VL PCODE
853: WHERE disp.path_pos_common_id = pp.path_pos_common_id
854: AND pp.path_position_id = p_path_position_id
855: AND disp.part_change_id IS NULL
856: AND disp.workorder_id = p_workorder_id

Line 913: FND_LOOKUP_VALUES PCODE,

909: MTL_MATERIAL_STATUSES_TL COND,
910: CS_INCIDENTS_ALL_B INC,
911: CS_INCIDENTS_ALL_TL INCL,
912: CS_INCIDENT_SEVERITIES_TL SEV,
913: FND_LOOKUP_VALUES PCODE,
914: FND_LOOKUP_VALUES FND1,
915: FND_LOOKUP_VALUES FND2,
916: FND_LOOKUP_VALUES FND3
917: WHERE pp.path_pos_common_id IN (

Line 914: FND_LOOKUP_VALUES FND1,

910: CS_INCIDENTS_ALL_B INC,
911: CS_INCIDENTS_ALL_TL INCL,
912: CS_INCIDENT_SEVERITIES_TL SEV,
913: FND_LOOKUP_VALUES PCODE,
914: FND_LOOKUP_VALUES FND1,
915: FND_LOOKUP_VALUES FND2,
916: FND_LOOKUP_VALUES FND3
917: WHERE pp.path_pos_common_id IN (
918: SELECT PATH_POS_COMMON_ID

Line 915: FND_LOOKUP_VALUES FND2,

911: CS_INCIDENTS_ALL_TL INCL,
912: CS_INCIDENT_SEVERITIES_TL SEV,
913: FND_LOOKUP_VALUES PCODE,
914: FND_LOOKUP_VALUES FND1,
915: FND_LOOKUP_VALUES FND2,
916: FND_LOOKUP_VALUES FND3
917: WHERE pp.path_pos_common_id IN (
918: SELECT PATH_POS_COMMON_ID
919: FROM AHL_MC_PATH_POSITIONS

Line 916: FND_LOOKUP_VALUES FND3

912: CS_INCIDENT_SEVERITIES_TL SEV,
913: FND_LOOKUP_VALUES PCODE,
914: FND_LOOKUP_VALUES FND1,
915: FND_LOOKUP_VALUES FND2,
916: FND_LOOKUP_VALUES FND3
917: WHERE pp.path_pos_common_id IN (
918: SELECT PATH_POS_COMMON_ID
919: FROM AHL_MC_PATH_POSITIONS
920: WHERE PATH_POSITION_ID = p_path_position_id

Line 999: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE

995: PCODE.MEANING PROBLEM_MEANING,
996: INC.SUMMARY
997: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_MC_PATH_POSITIONS pp,
998: CS_INCIDENTS_ALL_VL INC,
999: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE
1000: WHERE disp.path_pos_common_id =pp.path_pos_common_id
1001: AND pp.path_position_id = p_path_position_id
1002: AND disp.part_change_id IS NULL
1003: AND disp.workorder_id = p_workorder_id

Line 1055: FND_LOOKUP_VALUES PCODE,

1051: AHL_MC_PATH_POSITIONS pp,
1052: CS_INCIDENTS_ALL_B INC,
1053: CS_INCIDENTS_ALL_TL INCL,
1054: CS_INCIDENT_SEVERITIES_TL SEV,
1055: FND_LOOKUP_VALUES PCODE,
1056: MTL_SYSTEM_ITEMS_KFV MTL,
1057: CSI_ITEM_INSTANCES CSI,
1058: AHL_ITEM_GROUPS_B GRP,
1059: MTL_MATERIAL_STATUSES_TL COND,

Line 1060: FND_LOOKUP_VALUES FND1,

1056: MTL_SYSTEM_ITEMS_KFV MTL,
1057: CSI_ITEM_INSTANCES CSI,
1058: AHL_ITEM_GROUPS_B GRP,
1059: MTL_MATERIAL_STATUSES_TL COND,
1060: FND_LOOKUP_VALUES FND1,
1061: FND_LOOKUP_VALUES FND2,
1062: FND_LOOKUP_VALUES FND3
1063: WHERE pp.path_pos_common_id IN (
1064: SELECT PATH_POS_COMMON_ID

Line 1061: FND_LOOKUP_VALUES FND2,

1057: CSI_ITEM_INSTANCES CSI,
1058: AHL_ITEM_GROUPS_B GRP,
1059: MTL_MATERIAL_STATUSES_TL COND,
1060: FND_LOOKUP_VALUES FND1,
1061: FND_LOOKUP_VALUES FND2,
1062: FND_LOOKUP_VALUES FND3
1063: WHERE pp.path_pos_common_id IN (
1064: SELECT PATH_POS_COMMON_ID
1065: FROM AHL_MC_PATH_POSITIONS

Line 1062: FND_LOOKUP_VALUES FND3

1058: AHL_ITEM_GROUPS_B GRP,
1059: MTL_MATERIAL_STATUSES_TL COND,
1060: FND_LOOKUP_VALUES FND1,
1061: FND_LOOKUP_VALUES FND2,
1062: FND_LOOKUP_VALUES FND3
1063: WHERE pp.path_pos_common_id IN (
1064: SELECT PATH_POS_COMMON_ID
1065: FROM AHL_MC_PATH_POSITIONS
1066: WHERE PATH_POSITION_ID = p_path_position_id

Line 1144: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE,

1140: PCODE.MEANING PROBLEM_MEANING,
1141: INC.SUMMARY
1142: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_MC_PATH_POSITIONS pp,
1143: CS_INCIDENTS_ALL_VL INC,
1144: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE,
1145: AHL_PART_CHANGES_V PC
1146: WHERE disp.path_pos_common_id =pp.path_pos_common_id
1147: AND pp.path_position_id = p_path_position_id
1148: AND disp.part_change_id IS NOT NULL

Line 1200: FND_LOOKUP_VALUES FND1,

1196: INCL.SUMMARY
1197: FROM AHL_PRD_DISPOSITIONS_b disp,
1198: AHL_PRD_DISPOSITIONS_tl displ,
1199: AHL_MC_PATH_POSITIONS pp,
1200: FND_LOOKUP_VALUES FND1,
1201: FND_LOOKUP_VALUES FND2,
1202: FND_LOOKUP_VALUES FND3,
1203: MTL_MATERIAL_STATUSES_TL COND,
1204: AHL_ITEM_GROUPS_B GRP,

Line 1201: FND_LOOKUP_VALUES FND2,

1197: FROM AHL_PRD_DISPOSITIONS_b disp,
1198: AHL_PRD_DISPOSITIONS_tl displ,
1199: AHL_MC_PATH_POSITIONS pp,
1200: FND_LOOKUP_VALUES FND1,
1201: FND_LOOKUP_VALUES FND2,
1202: FND_LOOKUP_VALUES FND3,
1203: MTL_MATERIAL_STATUSES_TL COND,
1204: AHL_ITEM_GROUPS_B GRP,
1205: MTL_SYSTEM_ITEMS_KFV MTL,

Line 1202: FND_LOOKUP_VALUES FND3,

1198: AHL_PRD_DISPOSITIONS_tl displ,
1199: AHL_MC_PATH_POSITIONS pp,
1200: FND_LOOKUP_VALUES FND1,
1201: FND_LOOKUP_VALUES FND2,
1202: FND_LOOKUP_VALUES FND3,
1203: MTL_MATERIAL_STATUSES_TL COND,
1204: AHL_ITEM_GROUPS_B GRP,
1205: MTL_SYSTEM_ITEMS_KFV MTL,
1206: CSI_ITEM_INSTANCES CSI,

Line 1210: FND_LOOKUP_VALUES PCODE,

1206: CSI_ITEM_INSTANCES CSI,
1207: CS_INCIDENTS_ALL_B INC,
1208: CS_INCIDENTS_ALL_TL INCL,
1209: CS_INCIDENT_SEVERITIES_TL SEV,
1210: FND_LOOKUP_VALUES PCODE,
1211: AHL_PART_CHANGES_V PC
1212: WHERE pp.path_pos_common_id IN (
1213: SELECT PATH_POS_COMMON_ID
1214: FROM AHL_MC_PATH_POSITIONS

Line 1295: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE

1291: INC.PROBLEM_CODE,
1292: PCODE.MEANING PROBLEM_MEANING,
1293: INC.SUMMARY
1294: FROM AHL_PRD_DISPOSITIONS_V disp, CS_INCIDENTS_ALL_VL INC,
1295: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE
1296: WHERE disp.workorder_id = p_workorder_id
1297: AND disp.instance_id = p_instance_id
1298: AND (disp.status_code NOT IN ('COMPLETE', 'TERMINATED'))
1299: AND disp.part_change_id IS NULL