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 CSI_ITEM_INSTANCES

Line 2060: FROM AHL_WORKORDERS_V WO, WIP_DISCRETE_JOBS WIP, AHL_ROUTES_V RO, AHL_UNIT_EFFECTIVITIES_B UE, HZ_PARTIES HZ, CSI_ITEM_INSTANCES CSI

2056: WO.workorder_id = UE.ORIGINATING_WO_ID
2057: and WO.unit_effectivity_id = UE.unit_effectivity_id) OriginatingWorkorder,
2058: WO.item_instance_id,
2059: decode(WO.plan_id,null,'F','T') isQualityEnabled
2060: FROM AHL_WORKORDERS_V WO, WIP_DISCRETE_JOBS WIP, AHL_ROUTES_V RO, AHL_UNIT_EFFECTIVITIES_B UE, HZ_PARTIES HZ, CSI_ITEM_INSTANCES CSI
2061: WHERE WO.wip_entity_id = WIP.wip_entity_id
2062: AND WO.route_id = RO.route_id (+)
2063: AND UE.unit_effectivity_id(+) = WO.unit_effectivity_id
2064: AND CSI.instance_id = WO.ITEM_INSTANCE_ID(+)

Line 2124: CSI_ITEM_INSTANCES CSI ,

2120: WIP_DISCRETE_JOBS WIP ,
2121: AHL_ROUTES_B RO ,
2122: AHL_UNIT_EFFECTIVITIES_B UE ,
2123: --HZ_PARTIES HZ ,
2124: CSI_ITEM_INSTANCES CSI ,
2125: --CS_INCIDENTS_ALL_B CSIN ,
2126: --AHL_VISIT_TASKS_VL VTS ,
2127: AHL_WORKORDERS W ,
2128: (SELECT LOOKUP_CODE ,

Line 2592: CSI_ITEM_INSTANCES CSI ,

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,
2596: HZ_PARTIES PARTY ,

Line 2903: csi_item_instances OFFC ,

2899: ONC.lot_number InstalledLot ,
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

Line 2905: csi_item_instances ONC ,

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
2909: AND PC.removed_instance_id = OFFC.instance_id (+)

Line 2970: CSI_ITEM_INSTANCES CSIS,

2966: || INV_ProjectLocator_PUB.get_task_number(MSI.segment20)) "Locator",
2967: (Select INCIDENT_NUMBER from CS_INCIDENTS_ALL_B where INCIDENT_ID = AVB.SERVICE_REQUEST_ID) "NonRoutineTitle"
2968: FROM AHL_VISITS_B AVB,
2969: MTL_SYSTEM_ITEMS_B_KFV MTSB,
2970: CSI_ITEM_INSTANCES CSIS,
2971: FND_LOOKUP_VALUES_VL FLVT,
2972: HR_ALL_ORGANIZATION_UNITS HROU,
2973: BOM_DEPARTMENTS BDPT,
2974: mtl_item_locations_kfv MTLI,

Line 7892: CSI_ITEM_INSTANCES CSI ,

7888: WIP_DISCRETE_JOBS WIP ,
7889: AHL_ROUTES_B RO ,
7890: AHL_UNIT_EFFECTIVITIES_B UE ,
7891: --HZ_PARTIES HZ ,
7892: CSI_ITEM_INSTANCES CSI ,
7893: --CS_INCIDENTS_ALL_B CSIN ,
7894: --AHL_VISIT_TASKS_VL VTS ,
7895: AHL_WORKORDERS W ,
7896: (SELECT LOOKUP_CODE ,

Line 8371: csi_item_instances OFFC ,

8367: ONC.lot_number InstalledLot ,
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

Line 8373: csi_item_instances ONC ,

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
8377: AND PC.removed_instance_id = OFFC.instance_id (+)