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_PRINT_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1192: l_query_string := l_query_string || ' , MTL_SYSTEM_ITEMS_KFV ITEM ';

1188: l_query_string := l_query_string || ' FROM QA_RESULTS_V RESULTS ';
1189:
1190: -- Append required FROM clauses for the API.
1191: IF l_item_found = FND_API.G_TRUE THEN
1192: l_query_string := l_query_string || ' , MTL_SYSTEM_ITEMS_KFV ITEM ';
1193: END IF;
1194:
1195: IF l_locator_found = FND_API.G_TRUE THEN
1196: l_query_string := l_query_string || ' , MTL_ITEM_LOCATIONS_KFV LOCATOR ';

Line 2164: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI

2160: (SELECT f.meaning from fnd_lookup_values_vl f
2161: WHERE f.lookup_type = 'ITEM_TYPE' and f.lookup_code = msi.item_type) item_type
2162: FROM --AHL_JOB_OPER_MATERIALS_V JM,
2163: WIP_REQUIREMENT_OPERATIONS WRO, AHL_SCHEDULE_MATERIALS ASM,
2164: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI
2165: WHERE WO.wip_entity_id = WRO.wip_entity_id
2166: AND WO.visit_task_id = ASM.visit_task_id
2167: AND ASM.operation_sequence = WRO.operation_seq_num
2168: AND ASM.inventory_item_id = WRO.inventory_item_id

Line 2591: MTL_SYSTEM_ITEMS_KFV MTL ,

2587: and wo.visit_task_id = visit_task.visit_task_id
2588: ) RELEASE_DATE
2589: FROM
2590: AHL_UNIT_EFFECTIVITIES_B UE,
2591: MTL_SYSTEM_ITEMS_KFV MTL ,
2592: CSI_ITEM_INSTANCES CSI ,
2593: CS_INCIDENTS_ALL_B CS,
2594: AHL_WORKORDERS WO,
2595: AHL_VISIT_TASKS_B VISIT_TASK,

Line 2904: mtl_system_items_kfv OFFI,

2900: ONC.inventory_revision InstalledRevision,
2901: DIS.position_reference position
2902: FROM ahl_part_changes_v PC ,
2903: csi_item_instances OFFC ,
2904: mtl_system_items_kfv OFFI,
2905: csi_item_instances ONC ,
2906: mtl_system_items_kfv ONI ,
2907: ahl_prd_dispositions_v DIS
2908: WHERE PC.part_change_id = DIS.part_change_id

Line 2906: mtl_system_items_kfv ONI ,

2902: FROM ahl_part_changes_v PC ,
2903: csi_item_instances OFFC ,
2904: mtl_system_items_kfv OFFI,
2905: csi_item_instances ONC ,
2906: mtl_system_items_kfv ONI ,
2907: ahl_prd_dispositions_v DIS
2908: WHERE PC.part_change_id = DIS.part_change_id
2909: AND PC.removed_instance_id = OFFC.instance_id (+)
2910: AND PC.installed_instance_id = ONC.instance_id (+)

Line 7601: l_query_string := l_query_string || ' , MTL_SYSTEM_ITEMS_KFV ITEM ';

7597: l_query_string := l_query_string || ' FROM QA_RESULTS_V RESULTS ';
7598:
7599: -- Append required FROM clauses for the API.
7600: IF l_item_found = FND_API.G_TRUE THEN
7601: l_query_string := l_query_string || ' , MTL_SYSTEM_ITEMS_KFV ITEM ';
7602: END IF;
7603:
7604: IF l_locator_found = FND_API.G_TRUE THEN
7605: l_query_string := l_query_string || ' , MTL_ITEM_LOCATIONS_KFV LOCATOR ';

Line 7948: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI,AHL_WORKORDER_OPERATIONS AWOP

7944: (SELECT f.meaning from fnd_lookup_values_vl f
7945: WHERE f.lookup_type = 'ITEM_TYPE' and f.lookup_code = msi.item_type) item_type
7946: FROM --AHL_JOB_OPER_MATERIALS_V JM,
7947: WIP_REQUIREMENT_OPERATIONS WRO, AHL_SCHEDULE_MATERIALS ASM,
7948: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI,AHL_WORKORDER_OPERATIONS AWOP
7949: WHERE WO.wip_entity_id = WRO.wip_entity_id
7950: AND WO.visit_task_id = ASM.visit_task_id
7951: AND ASM.operation_sequence = WRO.operation_seq_num
7952: AND ASM.inventory_item_id = WRO.inventory_item_id

Line 8372: mtl_system_items_kfv OFFI,

8368: ONC.inventory_revision InstalledRevision,
8369: DIS.position_reference position
8370: FROM ahl_part_changes_v PC ,
8371: csi_item_instances OFFC ,
8372: mtl_system_items_kfv OFFI,
8373: csi_item_instances ONC ,
8374: mtl_system_items_kfv ONI ,
8375: ahl_prd_dispositions_v DIS
8376: WHERE PC.part_change_id = DIS.part_change_id

Line 8374: mtl_system_items_kfv ONI ,

8370: FROM ahl_part_changes_v PC ,
8371: csi_item_instances OFFC ,
8372: mtl_system_items_kfv OFFI,
8373: csi_item_instances ONC ,
8374: mtl_system_items_kfv ONI ,
8375: ahl_prd_dispositions_v DIS
8376: WHERE PC.part_change_id = DIS.part_change_id
8377: AND PC.removed_instance_id = OFFC.instance_id (+)
8378: AND PC.installed_instance_id = ONC.instance_id (+)