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

1662: LOOKUP_CODE = G_STATUS_EXPIRED;
1663:
1664: l_root_uc_header_id NUMBER;
1665: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1666: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1667: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1668: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1669: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1670: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;

Line 1667: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;

1663:
1664: l_root_uc_header_id NUMBER;
1665: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1666: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1667: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1668: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1669: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1670: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1671: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;

Line 1671: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;

1667: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1668: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1669: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1670: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1671: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1672: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1673: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1674: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1675: l_return_value VARCHAR2(100) := null;

Line 1672: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;

1668: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1669: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1670: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1671: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1672: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1673: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1674: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1675: l_return_value VARCHAR2(100) := null;
1676: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UTIL_UC_PKG.Get_UC_Status';

Line 1732: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1728: l_uc_status,
1729: l_uc_active_status,
1730: l_uc_end_date,
1731: l_uc_inst_end_date
1732: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1733: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1734: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1735: AND UC.csi_item_instance_id = CSI.instance_id
1736: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1733: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC

1729: l_uc_active_status,
1730: l_uc_end_date,
1731: l_uc_inst_end_date
1732: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1733: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1734: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1735: AND UC.csi_item_instance_id = CSI.instance_id
1736: AND UC.unit_config_status_code = UCSC.lookup_code
1737: AND 'AHL_CONFIG_STATUS' = UCSC.lookup_type

Line 1761: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1757: l_root_status,
1758: l_root_active_status,
1759: l_root_end_date,
1760: l_root_inst_end_date
1761: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1762: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1763: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1764: AND UC.csi_item_instance_id = CSI.instance_id
1765: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1762: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC

1758: l_root_active_status,
1759: l_root_end_date,
1760: l_root_inst_end_date
1761: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1762: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1763: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1764: AND UC.csi_item_instance_id = CSI.instance_id
1765: AND UC.unit_config_status_code = UCSC.lookup_code
1766: AND 'AHL_CONFIG_STATUS' = UCSC.lookup_type

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

Line 1854: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;

1850: */
1851:
1852: l_root_uc_header_id NUMBER;
1853: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1854: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1855: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1856: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1857: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1858: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;

Line 1858: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;

1854: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1855: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1856: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1857: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1858: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1859: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1860: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1861: l_return_value VARCHAR2(100) := null;
1862: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UTIL_UC_PKG.Get_UC_Status_code';

Line 1915: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1911: INTO l_uc_status_code,
1912: l_uc_status,
1913: l_uc_end_date,
1914: l_uc_inst_end_date
1915: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1916: CSI_ITEM_INSTANCES CSI
1917: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1918: AND UC.csi_item_instance_id = CSI.instance_id
1919: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1939: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1935: INTO l_root_status_code,
1936: l_root_status,
1937: l_root_end_date,
1938: l_root_inst_end_date
1939: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1940: CSI_ITEM_INSTANCES CSI
1941: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1942: AND UC.csi_item_instance_id = CSI.instance_id
1943: AND UC.unit_config_status_code = UCSC.lookup_code

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

2089: x_uc_header_ovn OUT NOCOPY NUMBER)
2090: IS
2091: l_uc_header_id NUMBER := NULL;
2092: l_instance_id NUMBER := NULL;
2093: l_uc_status_code fnd_lookup_values.lookup_code%TYPE := NULL;
2094: l_active_uc_status_code fnd_lookup_values.lookup_code%TYPE := NULL;
2095: l_uc_header_ovn NUMBER;
2096: CURSOR get_top_unit(c_uc_header_id NUMBER) IS
2097: SELECT unit_config_header_id,

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

2090: IS
2091: l_uc_header_id NUMBER := NULL;
2092: l_instance_id NUMBER := NULL;
2093: l_uc_status_code fnd_lookup_values.lookup_code%TYPE := NULL;
2094: l_active_uc_status_code fnd_lookup_values.lookup_code%TYPE := NULL;
2095: l_uc_header_ovn NUMBER;
2096: CURSOR get_top_unit(c_uc_header_id NUMBER) IS
2097: SELECT unit_config_header_id,
2098: csi_item_instance_id,