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 FND_LOOKUP_VALUES

Line 1010: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,

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
1013: WHERE AVTS.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID(+)
1014: AND AVTS.ITEM_INSTANCE_ID = CSIS.INSTANCE_ID(+)

Line 1011: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,

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
1013: WHERE AVTS.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID(+)
1014: AND AVTS.ITEM_INSTANCE_ID = CSIS.INSTANCE_ID(+)
1015: AND AVTS.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+)

Line 1058: FND_LOOKUP_VALUES FLVT, FND_LOOKUP_VALUES FLVT1,

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,
1061: AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1062: WHERE AVTS.VISIT_ID = AVTSTL.VISIT_ID

Line 1059: FND_LOOKUP_VALUES FLVT2, FND_LOOKUP_VALUES FLVT3,

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,
1061: AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1062: WHERE AVTS.VISIT_ID = AVTSTL.VISIT_ID
1063: AND AVTSTL.LANGUAGE = USERENV('LANG')

Line 1175: FROM FND_LOOKUP_VALUES_VL

1171:
1172: -- To find meaning for fnd_lookups code
1173: IF (visit_rec.project_flag IS NOT NULL) THEN
1174: SELECT MEANING INTO l_project_flag
1175: FROM FND_LOOKUP_VALUES_VL
1176: WHERE LOOKUP_CODE = visit_rec.project_flag
1177: AND LOOKUP_TYPE = 'AHL_YES_NO_TYPE';
1178: END IF;
1179: ----------------------------------- FOR VISITS --------------------------------------