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_RA_ANALYSER_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 92: AHL_UNIT_CONFIG_HEADERS UCI

88: DECODE(UC.CSI_ITEM_INSTANCE_ID,
89: NULL,CIIR.POSITION_REFERENCE,
90: (SELECT RELATIONSHIP_ID
91: FROM AHL_MC_RELATIONSHIPS MCR,
92: AHL_UNIT_CONFIG_HEADERS UCI
93: WHERE MCR.MC_HEADER_ID = UCI.MASTER_CONFIG_ID
94: AND MCR.PARENT_RELATIONSHIP_ID IS NULL
95: AND UCI.UNIT_CONFIG_HEADER_ID = AHL_UTIL_UC_PKG.GET_SUB_UC_HEADER_ID(UC.CSI_ITEM_INSTANCE_ID))), -- l_dtls_pos_ref_tbl
96: CII.INVENTORY_ITEM_ID, -- l_dtls_inv_item_id_tbl

Line 108: AHL_UNIT_CONFIG_HEADERS UC

104: FROM CSI_II_RELATIONSHIPS CIIR,
105: CSI_ITEM_INSTANCES CII,
106: --MTL_SYSTEM_ITEMS MSI,
107: MTL_SYSTEM_ITEMS_KFV KFV,
108: AHL_UNIT_CONFIG_HEADERS UC
109: WHERE CII.INSTANCE_ID = CIIR.SUBJECT_ID
110: AND CII.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
111: AND CII.INV_MASTER_ORGANIZATION_ID = KFV.ORGANIZATION_ID
112: --AND KFV.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID

Line 173: AHL_UNIT_CONFIG_HEADERS UC,

169: AND TRUNC(NVL(CIIRI.ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)
170: AND TRUNC(SYSDATE) < TRUNC(NVL(CIIRI.ACTIVE_END_DATE,SYSDATE+1))) CIIR,
171: CSI_ITEM_INSTANCES CII,
172: MTL_SYSTEM_ITEMS_KFV KFV,
173: AHL_UNIT_CONFIG_HEADERS UC,
174: AHL_UNIT_CONFIG_HEADERS UCI
175: WHERE CII.INSTANCE_ID = CIIR.SUBJECT_ID
176: AND CII.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
177: AND CII.INV_MASTER_ORGANIZATION_ID = KFV.ORGANIZATION_ID

Line 174: AHL_UNIT_CONFIG_HEADERS UCI

170: AND TRUNC(SYSDATE) < TRUNC(NVL(CIIRI.ACTIVE_END_DATE,SYSDATE+1))) CIIR,
171: CSI_ITEM_INSTANCES CII,
172: MTL_SYSTEM_ITEMS_KFV KFV,
173: AHL_UNIT_CONFIG_HEADERS UC,
174: AHL_UNIT_CONFIG_HEADERS UCI
175: WHERE CII.INSTANCE_ID = CIIR.SUBJECT_ID
176: AND CII.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
177: AND CII.INV_MASTER_ORGANIZATION_ID = KFV.ORGANIZATION_ID
178: AND UC.CSI_ITEM_INSTANCE_ID(+) = CIIR.SUBJECT_ID

Line 696: FROM AHL_UNIT_CONFIG_HEADERS UC,

692: l_root_item_revision,
693: l_root_srl_no,
694: l_root_item_name,
695: l_root_item_desc
696: FROM AHL_UNIT_CONFIG_HEADERS UC,
697: CSI_ITEM_INSTANCES CII,
698: MTL_SYSTEM_ITEMS_KFV KFV,
699: ahl_mc_relationships MCR
700: WHERE UC.UNIT_CONFIG_HEADER_ID = l_fs_uc_header_id_tbl(i)