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_MC_RELATIONSHIPS

Line 91: FROM AHL_MC_RELATIONSHIPS MCR,

87: CIIR.SUBJECT_ID, -- l_dtls_subject_id_tbl
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

Line 180: AHL_MC_RELATIONSHIPS MCR

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
179: AND UCI.UNIT_CONFIG_HEADER_ID(+) = AHL_UTIL_UC_PKG.GET_SUB_UC_HEADER_ID(UC.CSI_ITEM_INSTANCE_ID)) A,
180: AHL_MC_RELATIONSHIPS MCR
181: WHERE MCR.MC_HEADER_ID(+) = A.MASTER_CONFIG_ID
182: AND nvl(MCR.PARENT_RELATIONSHIP_ID,-1) = -1;
183:
184: CURSOR c_get_mtbf_data(c_relationship_id AHL_RA_DEFINITION_HDR.RELATIONSHIP_ID%TYPE,

Line 203: ahl_mc_relationships rel,

199:
200: CURSOR c_get_path_postions(c_relationship_id AHL_RA_DEFINITION_HDR.RELATIONSHIP_ID%TYPE) IS
201: Select pos.path_position_id
202: from ahl_mc_path_position_nodes pos,
203: ahl_mc_relationships rel,
204: ahl_mc_headers_b hdr
205: where rel.mc_header_id = hdr.mc_header_id
206: and rel.relationship_id = to_number(c_relationship_id)
207: and hdr.mc_id = pos.mc_id

Line 268: l_root_pos_ref_code AHL_MC_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;

264: --Modified by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645
265: l_dtls_pos_ref_his_tbl Varchar30TabType;
266:
267: -- These temp variables have one - to - one correspondance to each another.
268: l_root_pos_ref_code AHL_MC_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
269: l_root_quantity CSI_ITEM_INSTANCES.QUANTITY%TYPE;
270: l_root_uom CSI_ITEM_INSTANCES.UNIT_OF_MEASURE%TYPE;
271: l_root_inv_item_id CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE;
272: l_root_inv_master_org_id CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID%TYPE;

Line 699: ahl_mc_relationships MCR

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)
701: AND UC.CSI_ITEM_INSTANCE_ID = CII.INSTANCE_ID
702: AND KFV.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
703: AND KFV.ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_ID