APPS.AHL_UTIL_UC_PKG dependencies on FND_LOOKUP_VALUES_VL

Line 689: FROM ahl_mc_relationships mcr, fnd_lookup_values_vl fnd

685: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 04-Dec-2007
686: -- Cursor to fetch the position lookup meaning for a given relationship id.
687: CURSOR get_pos_lkup_meaning(p_mc_relationship_id IN NUMBER) IS
688: SELECT fnd.lookup_code, fnd.meaning position_ref_meaning
689: FROM ahl_mc_relationships mcr, fnd_lookup_values_vl fnd
690: WHERE mcr.relationship_id = p_mc_relationship_id
691: AND mcr.position_ref_code = fnd.lookup_code
692: AND fnd.lookup_type = 'AHL_POSITION_REFERENCE';
693:

Line 1642: FND_LOOKUP_VALUES_VL FL, FND_LOOKUP_VALUES_VL FLA,

1638: FLA.MEANING,
1639: NVL(ROOT_UC.ACTIVE_END_DATE, SYSDATE + 1),
1640: NVL(CSI.ACTIVE_END_DATE, SYSDATE + 1)
1641: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,
1642: FND_LOOKUP_VALUES_VL FL, FND_LOOKUP_VALUES_VL FLA,
1643: CSI_ITEM_INSTANCES CSI
1644: WHERE UC.UC_HEADER_ID = p_uc_header_id AND
1645: ROOT_UC.UNIT_CONFIG_HEADER_ID = UC.ROOT_UC_HEADER_ID AND
1646: ROOT_UC.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND

Line 1655: FROM FND_LOOKUP_VALUES_VL

1651: */
1652:
1653: CURSOR get_expired_value IS
1654: SELECT MEANING CsifutLookupMeaning
1655: FROM FND_LOOKUP_VALUES_VL
1656: WHERE LOOKUP_TYPE = 'AHL_CONFIG_STATUS' AND
1657: LOOKUP_CODE = G_STATUS_EXPIRED;
1658:
1659: l_root_uc_header_id NUMBER;

Line 1839: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES_VL FL

1835: FL.meaning,
1836: NVL(ROOT_UC.ACTIVE_END_DATE, SYSDATE + 1),
1837: NVL(CSI.ACTIVE_END_DATE, SYSDATE + 1)
1838: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,
1839: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES_VL FL
1840: WHERE UC.UC_HEADER_ID = p_uc_header_id AND
1841: ROOT_UC.UNIT_CONFIG_HEADER_ID = UC.ROOT_UC_HEADER_ID AND
1842: ROOT_UC.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND
1843: ROOT_UC.UNIT_CONFIG_STATUS_CODE = FL.LOOKUP_CODE AND