eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UTIL_UC_PKG dependencies on FND_LOOKUP_VALUES

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 1661: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;

1657: LOOKUP_CODE = G_STATUS_EXPIRED;
1658:
1659: l_root_uc_header_id NUMBER;
1660: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1661: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1662: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1663: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1664: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1665: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;

Line 1662: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;

1658:
1659: l_root_uc_header_id NUMBER;
1660: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1661: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1662: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1663: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1664: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1665: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1666: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;

Line 1666: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;

1662: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1663: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1664: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1665: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1666: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1667: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1668: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1669: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1670: l_return_value VARCHAR2(100) := null;

Line 1667: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;

1663: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1664: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1665: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1666: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1667: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1668: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1669: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1670: l_return_value VARCHAR2(100) := null;
1671: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UTIL_UC_PKG.Get_UC_Status';

Line 1727: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1723: l_uc_status,
1724: l_uc_active_status,
1725: l_uc_end_date,
1726: l_uc_inst_end_date
1727: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1728: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1729: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1730: AND UC.csi_item_instance_id = CSI.instance_id
1731: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1728: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC

1724: l_uc_active_status,
1725: l_uc_end_date,
1726: l_uc_inst_end_date
1727: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1728: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1729: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1730: AND UC.csi_item_instance_id = CSI.instance_id
1731: AND UC.unit_config_status_code = UCSC.lookup_code
1732: AND 'AHL_CONFIG_STATUS' = UCSC.lookup_type

Line 1756: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1752: l_root_status,
1753: l_root_active_status,
1754: l_root_end_date,
1755: l_root_inst_end_date
1756: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1757: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1758: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1759: AND UC.csi_item_instance_id = CSI.instance_id
1760: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1757: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC

1753: l_root_active_status,
1754: l_root_end_date,
1755: l_root_inst_end_date
1756: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1757: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1758: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1759: AND UC.csi_item_instance_id = CSI.instance_id
1760: AND UC.unit_config_status_code = UCSC.lookup_code
1761: AND 'AHL_CONFIG_STATUS' = UCSC.lookup_type

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

Line 1849: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;

1845: */
1846:
1847: l_root_uc_header_id NUMBER;
1848: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1849: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1850: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1851: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1852: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1853: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;

Line 1853: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;

1849: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1850: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1851: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1852: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1853: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1854: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1855: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1856: l_return_value VARCHAR2(100) := null;
1857: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UTIL_UC_PKG.Get_UC_Status_code';

Line 1910: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1906: INTO l_uc_status_code,
1907: l_uc_status,
1908: l_uc_end_date,
1909: l_uc_inst_end_date
1910: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1911: CSI_ITEM_INSTANCES CSI
1912: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1913: AND UC.csi_item_instance_id = CSI.instance_id
1914: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1934: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1930: INTO l_root_status_code,
1931: l_root_status,
1932: l_root_end_date,
1933: l_root_inst_end_date
1934: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1935: CSI_ITEM_INSTANCES CSI
1936: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1937: AND UC.csi_item_instance_id = CSI.instance_id
1938: AND UC.unit_config_status_code = UCSC.lookup_code

Line 2088: l_uc_status_code fnd_lookup_values.lookup_code%TYPE := NULL;

2084: x_uc_header_ovn OUT NOCOPY NUMBER)
2085: IS
2086: l_uc_header_id NUMBER := NULL;
2087: l_instance_id NUMBER := NULL;
2088: l_uc_status_code fnd_lookup_values.lookup_code%TYPE := NULL;
2089: l_active_uc_status_code fnd_lookup_values.lookup_code%TYPE := NULL;
2090: l_uc_header_ovn NUMBER;
2091: CURSOR get_top_unit(c_uc_header_id NUMBER) IS
2092: SELECT unit_config_header_id,

Line 2089: l_active_uc_status_code fnd_lookup_values.lookup_code%TYPE := NULL;

2085: IS
2086: l_uc_header_id NUMBER := NULL;
2087: l_instance_id NUMBER := NULL;
2088: l_uc_status_code fnd_lookup_values.lookup_code%TYPE := NULL;
2089: l_active_uc_status_code fnd_lookup_values.lookup_code%TYPE := NULL;
2090: l_uc_header_ovn NUMBER;
2091: CURSOR get_top_unit(c_uc_header_id NUMBER) IS
2092: SELECT unit_config_header_id,
2093: csi_item_instance_id,