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 1008: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,

1004: FLVT3.MEANING PRIORITY_MEAN, AVTS.PROJECT_TEMPLATE_ID,
1005: PA.NAME PROJECT_TEMPLATE_NAME ,
1006: AVTS.UNIT_SCHEDULE_ID, AVTS.ASSO_PRIMARY_VISIT_ID
1007: FROM AHL_VISITS_VL AVTS, AHL_SIMULATION_PLANS_VL ASPV,
1008: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,
1009: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1010: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,
1011: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,
1012: PA_PROJECTS_ALL PA, AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB

Line 1056: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS_TL HROU,

1052: ,PA.NAME PROJECT_TEMPLATE_NAME,
1053: AVTS.INV_LOCATOR_ID -- Added by sowsubra
1054: FROM AHL_VISITS_B AVTS,AHL_VISITS_TL AVTSTL,
1055: AHL_SIMULATION_PLANS_B ASPV,AHL_SIMULATION_PLANS_TL ASPVTL,
1056: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS_TL HROU,
1057: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1058: FND_LOOKUP_VALUES FLVT, FND_LOOKUP_VALUES FLVT1,
1059: FND_LOOKUP_VALUES FLVT2, FND_LOOKUP_VALUES FLVT3,
1060: PA_PROJECTS_ALL PA,

Line 1443: csi_item_instances csis

1439: mtl.inventory_item_id ,
1440: mtl.inventory_org_id
1441: FROM ahl_mtl_items_ou_v mtl,
1442: ahl_unit_config_headers uc,
1443: csi_item_instances csis
1444: WHERE uc.name = p_unit_name
1445: AND uc.csi_item_instance_id=csis.instance_id
1446: AND AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID) in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1447: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)

Line 1461: csi_item_instances csis

1457: --mtl.inventory_org_id
1458: csis.inv_master_organization_id
1459: FROM mtl_system_items_kfv mtl,
1460: ahl_unit_config_headers uc,
1461: csi_item_instances csis
1462: WHERE uc.name = p_unit_name
1463: AND uc.csi_item_instance_id=csis.instance_id
1464: AND upper(AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID))in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1465: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)

Line 1484: csi_item_instances csis

1480: mtl.inventory_item_id ,
1481: csis.inv_master_organization_id
1482: FROM mtl_system_items mtl,
1483: ahl_unit_config_headers uc,
1484: csi_item_instances csis
1485: WHERE uc.name = p_unit_name
1486: AND uc.csi_item_instance_id=csis.instance_id
1487: -- Fix by jaramana on June 27, 2006 for Bug 5360066
1488: -- AND upper(AHL_UTIL_UC_PKG.GET_UC_STATUS(uc.UNIT_CONFIG_HEADER_ID))in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')