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 1193: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,

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

Line 1194: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,

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

Line 1244: FND_LOOKUP_VALUES FLVT, FND_LOOKUP_VALUES FLVT1,

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
1247: --PA_PROJECTS_ALL PA,
1248: AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB

Line 1245: FND_LOOKUP_VALUES FLVT2, FND_LOOKUP_VALUES FLVT3,

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
1247: --PA_PROJECTS_ALL PA,
1248: AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1249: WHERE AVTS.VISIT_ID = AVTSTL.VISIT_ID

Line 1386: FROM FND_LOOKUP_VALUES_VL

1382:
1383: -- To find meaning for fnd_lookups code
1384: IF (visit_rec.project_flag IS NOT NULL) THEN
1385: SELECT MEANING INTO l_project_flag
1386: FROM FND_LOOKUP_VALUES_VL
1387: WHERE LOOKUP_CODE = visit_rec.project_flag
1388: AND LOOKUP_TYPE = 'AHL_YES_NO_TYPE';
1389: END IF;
1390: ----------------------------------- FOR VISITS --------------------------------------