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_VWP_VISITS_PVT dependencies on CSI_ITEM_INSTANCES

Line 1191: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,

1187: FLVT3.MEANING PRIORITY_MEAN, AVTS.PROJECT_TEMPLATE_ID,
1188: PA.NAME PROJECT_TEMPLATE_NAME ,
1189: AVTS.UNIT_SCHEDULE_ID, AVTS.ASSO_PRIMARY_VISIT_ID
1190: FROM AHL_VISITS_VL AVTS, AHL_SIMULATION_PLANS_VL ASPV,
1191: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,
1192: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1193: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,
1194: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,
1195: PA_PROJECTS_ALL PA, AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB

Line 1242: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS_TL HROU,

1238: AVTS.TOP_PROJECT_TASK_ID, --PRAKKUM ::FP PIE :: 13-OCT-2010
1239: AVTS.INV_LOCATOR_ID -- Added by sowsubra
1240: FROM AHL_VISITS_B AVTS,AHL_VISITS_TL AVTSTL,
1241: AHL_SIMULATION_PLANS_B ASPV,AHL_SIMULATION_PLANS_TL ASPVTL,
1242: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS_TL HROU,
1243: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1244: FND_LOOKUP_VALUES FLVT, FND_LOOKUP_VALUES FLVT1,
1245: FND_LOOKUP_VALUES FLVT2, FND_LOOKUP_VALUES FLVT3,
1246: -- SKPATHAK :: Bug #8983097 :: 20-OCT-2009

Line 1715: csi_item_instances csis

1711: mtl.inventory_item_id ,
1712: mtl.inventory_org_id
1713: FROM ahl_mtl_items_ou_v mtl,
1714: ahl_unit_config_headers uc,
1715: csi_item_instances csis
1716: WHERE uc.name = p_unit_name
1717: AND uc.csi_item_instance_id=csis.instance_id
1718: AND AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID) in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1719: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)

Line 1733: csi_item_instances csis

1729: --mtl.inventory_org_id
1730: csis.inv_master_organization_id
1731: FROM mtl_system_items_kfv mtl,
1732: ahl_unit_config_headers uc,
1733: csi_item_instances csis
1734: WHERE uc.name = p_unit_name
1735: AND uc.csi_item_instance_id=csis.instance_id
1736: AND upper(AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID))in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1737: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)

Line 1756: csi_item_instances csis

1752: mtl.inventory_item_id ,
1753: csis.inv_master_organization_id
1754: FROM mtl_system_items mtl,
1755: ahl_unit_config_headers uc,
1756: csi_item_instances csis
1757: WHERE uc.name = p_unit_name
1758: AND uc.csi_item_instance_id=csis.instance_id
1759: -- Fix by jaramana on June 27, 2006 for Bug 5360066
1760: -- AND upper(AHL_UTIL_UC_PKG.GET_UC_STATUS(uc.UNIT_CONFIG_HEADER_ID))in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')