APPS.AHL_UTIL_UC_PKG dependencies on FND_LOOKUP_VALUES_VL

Line 694: FROM ahl_mc_relationships mcr, fnd_lookup_values_vl fnd

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

Line 1647: FND_LOOKUP_VALUES_VL FL, FND_LOOKUP_VALUES_VL FLA,

1643: FLA.MEANING,
1644: NVL(ROOT_UC.ACTIVE_END_DATE, SYSDATE + 1),
1645: NVL(CSI.ACTIVE_END_DATE, SYSDATE + 1)
1646: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,
1647: FND_LOOKUP_VALUES_VL FL, FND_LOOKUP_VALUES_VL FLA,
1648: CSI_ITEM_INSTANCES CSI
1649: WHERE UC.UC_HEADER_ID = p_uc_header_id AND
1650: ROOT_UC.UNIT_CONFIG_HEADER_ID = UC.ROOT_UC_HEADER_ID AND
1651: ROOT_UC.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND

Line 1660: FROM FND_LOOKUP_VALUES_VL

1656: */
1657:
1658: CURSOR get_expired_value IS
1659: SELECT MEANING CsifutLookupMeaning
1660: FROM FND_LOOKUP_VALUES_VL
1661: WHERE LOOKUP_TYPE = 'AHL_CONFIG_STATUS' AND
1662: LOOKUP_CODE = G_STATUS_EXPIRED;
1663:
1664: l_root_uc_header_id NUMBER;

Line 1844: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES_VL FL

1840: FL.meaning,
1841: NVL(ROOT_UC.ACTIVE_END_DATE, SYSDATE + 1),
1842: NVL(CSI.ACTIVE_END_DATE, SYSDATE + 1)
1843: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,
1844: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES_VL FL
1845: WHERE UC.UC_HEADER_ID = p_uc_header_id AND
1846: ROOT_UC.UNIT_CONFIG_HEADER_ID = UC.ROOT_UC_HEADER_ID AND
1847: ROOT_UC.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND
1848: ROOT_UC.UNIT_CONFIG_STATUS_CODE = FL.LOOKUP_CODE AND