DBA Data[Home] [Help]

APPS.AHL_VWP_TASKS_PVT dependencies on AHL_WARRANTY_CLAIMS_B

Line 964: AHL_WARRANTY_CLAIMS_B AWCL,

960: , DECODE(ASWE.ENTITLEMENT_STATUS_CODE, 'NOT_APPLICABLE', 'Y', 'N')
961: , 'Y') WARRANTY_NOT_APPL_FLAG
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(+)