DBA Data[Home] [Help]

APPS.AHL_PP_MATERIALS_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 4548: FND_LOOKUP_VALUES_VL FNDA,

4544: SELECT DISTINCT
4545: JRREV.USER_NAME APPROVER_NAME
4546: FROM
4547: AHL_APPROVERS AA,
4548: FND_LOOKUP_VALUES_VL FNDA,
4549: AHL_JTF_RS_EMP_V JRREV,
4550: AHL_APPROVAL_RULES_B APR
4551: WHERE
4552: FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'

Line 4563: FND_LOOKUP_VALUES_VL FNDA,

4559: SELECT DISTINCT
4560: JRRV.ROLE_NAME APPROVER_NAME
4561: FROM
4562: AHL_APPROVERS AA,
4563: FND_LOOKUP_VALUES_VL FNDA,
4564: JTF_RS_ROLE_RELATIONS_VL JRRV,
4565: AHL_APPROVAL_RULES_B APR
4566: WHERE
4567: FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'

Line 4578: FND_LOOKUP_VALUES_VL FNDA,

4574: SELECT DISTINCT
4575: '' APPROVER_NAME
4576: FROM
4577: AHL_APPROVERS AA,
4578: FND_LOOKUP_VALUES_VL FNDA,
4579: AHL_APPROVAL_RULES_B APR
4580: WHERE
4581: FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'
4582: AND FNDA.LOOKUP_CODE = AA.APPROVER_TYPE_CODE