APPS.AHL_VWP_TASKS_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 826: FND_LOOKUP_VALUES_VL LKUP1,

822: CSI_ITEM_INSTANCES CSIS,
823: CS_INCIDENTS_ALL_B SR,
824: AHL_VWP_STAGES_VL ASTG,
825: BOM_DEPARTMENTS BDPT,
826: FND_LOOKUP_VALUES_VL LKUP1,
827: FND_LOOKUP_VALUES_VL LKUP2,
828: FND_LOOKUP_VALUES_VL LKUP3,
829: MTL_SYSTEM_ITEMS_B_KFV MTSB,
830: AHL_WORKORDERS AWO,

Line 827: FND_LOOKUP_VALUES_VL LKUP2,

823: CS_INCIDENTS_ALL_B SR,
824: AHL_VWP_STAGES_VL ASTG,
825: BOM_DEPARTMENTS BDPT,
826: FND_LOOKUP_VALUES_VL LKUP1,
827: FND_LOOKUP_VALUES_VL LKUP2,
828: FND_LOOKUP_VALUES_VL LKUP3,
829: MTL_SYSTEM_ITEMS_B_KFV MTSB,
830: AHL_WORKORDERS AWO,
831: PA_LOOKUPS PA

Line 828: FND_LOOKUP_VALUES_VL LKUP3,

824: AHL_VWP_STAGES_VL ASTG,
825: BOM_DEPARTMENTS BDPT,
826: FND_LOOKUP_VALUES_VL LKUP1,
827: FND_LOOKUP_VALUES_VL LKUP2,
828: FND_LOOKUP_VALUES_VL LKUP3,
829: MTL_SYSTEM_ITEMS_B_KFV MTSB,
830: AHL_WORKORDERS AWO,
831: PA_LOOKUPS PA
832: WHERE ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+)

Line 966: FND_LOOKUP_VALUES_VL LKUP1,

962: FROM AHL_VISIT_TASKS_VL ATSK,
963: AHL_WARRANTY_ENTITLEMENTS ASWE,
964: AHL_WARRANTY_CLAIMS_B AWCL,
965: AHL_WARRANTY_CONTRACTS_B AWCB,
966: FND_LOOKUP_VALUES_VL LKUP1,
967: FND_LOOKUP_VALUES_VL LKUP2
968: WHERE ATSK.VISIT_TASK_ID = ASWE.VISIT_TASK_ID(+)
969: AND ASWE.WARRANTY_CONTRACT_ID = AWCB.WARRANTY_CONTRACT_ID(+)
970: AND ASWE.WARRANTY_CLAIM_ID = AWCL.WARRANTY_CLAIM_ID(+)

Line 967: FND_LOOKUP_VALUES_VL LKUP2

963: AHL_WARRANTY_ENTITLEMENTS ASWE,
964: AHL_WARRANTY_CLAIMS_B AWCL,
965: AHL_WARRANTY_CONTRACTS_B AWCB,
966: FND_LOOKUP_VALUES_VL LKUP1,
967: FND_LOOKUP_VALUES_VL LKUP2
968: WHERE ATSK.VISIT_TASK_ID = ASWE.VISIT_TASK_ID(+)
969: AND ASWE.WARRANTY_CONTRACT_ID = AWCB.WARRANTY_CONTRACT_ID(+)
970: AND ASWE.WARRANTY_CLAIM_ID = AWCL.WARRANTY_CLAIM_ID(+)
971: AND LKUP1.LOOKUP_TYPE(+) = 'AHL_WARRANTY_ENTLMNT_STATUS'