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_RA_DEFINITION_HDR

Line 13: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_DEFINITION_HDR

9: -- Start of Comments --
10: --
11: -- Procedure name : PROCESS_RA_DATA
12: -- Type : Private
13: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_DEFINITION_HDR
14: -- Pre-reqs :
15: --
16: -- Standard IN Parameters :
17: -- p_api_version IN NUMBER Required

Line 184: CURSOR c_get_mtbf_data(c_relationship_id AHL_RA_DEFINITION_HDR.RELATIONSHIP_ID%TYPE,

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,
185: c_inv_item_id AHL_RA_DEFINITION_HDR.INVENTORY_ITEM_ID%TYPE,
186: c_inv_org_id AHL_RA_DEFINITION_HDR.INVENTORY_ORG_ID%TYPE,
187: c_inv_item_revision AHL_RA_DEFINITION_HDR.ITEM_REVISION%TYPE) IS
188: SELECT DTLS.COUNTER_ID,

Line 185: c_inv_item_id AHL_RA_DEFINITION_HDR.INVENTORY_ITEM_ID%TYPE,

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,
185: c_inv_item_id AHL_RA_DEFINITION_HDR.INVENTORY_ITEM_ID%TYPE,
186: c_inv_org_id AHL_RA_DEFINITION_HDR.INVENTORY_ORG_ID%TYPE,
187: c_inv_item_revision AHL_RA_DEFINITION_HDR.ITEM_REVISION%TYPE) IS
188: SELECT DTLS.COUNTER_ID,
189: DTLS.MTBF_VALUE

Line 186: c_inv_org_id AHL_RA_DEFINITION_HDR.INVENTORY_ORG_ID%TYPE,

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,
185: c_inv_item_id AHL_RA_DEFINITION_HDR.INVENTORY_ITEM_ID%TYPE,
186: c_inv_org_id AHL_RA_DEFINITION_HDR.INVENTORY_ORG_ID%TYPE,
187: c_inv_item_revision AHL_RA_DEFINITION_HDR.ITEM_REVISION%TYPE) IS
188: SELECT DTLS.COUNTER_ID,
189: DTLS.MTBF_VALUE
190: FROM AHL_RA_DEFINITION_HDR HDR,

Line 187: c_inv_item_revision AHL_RA_DEFINITION_HDR.ITEM_REVISION%TYPE) IS

183:
184: CURSOR c_get_mtbf_data(c_relationship_id AHL_RA_DEFINITION_HDR.RELATIONSHIP_ID%TYPE,
185: c_inv_item_id AHL_RA_DEFINITION_HDR.INVENTORY_ITEM_ID%TYPE,
186: c_inv_org_id AHL_RA_DEFINITION_HDR.INVENTORY_ORG_ID%TYPE,
187: c_inv_item_revision AHL_RA_DEFINITION_HDR.ITEM_REVISION%TYPE) IS
188: SELECT DTLS.COUNTER_ID,
189: DTLS.MTBF_VALUE
190: FROM AHL_RA_DEFINITION_HDR HDR,
191: AHL_RA_DEFINITION_DTLS DTLS

Line 190: FROM AHL_RA_DEFINITION_HDR HDR,

186: c_inv_org_id AHL_RA_DEFINITION_HDR.INVENTORY_ORG_ID%TYPE,
187: c_inv_item_revision AHL_RA_DEFINITION_HDR.ITEM_REVISION%TYPE) IS
188: SELECT DTLS.COUNTER_ID,
189: DTLS.MTBF_VALUE
190: FROM AHL_RA_DEFINITION_HDR HDR,
191: AHL_RA_DEFINITION_DTLS DTLS
192: WHERE HDR.RA_DEFINITION_HDR_ID = DTLS.RA_DEFINITION_HDR_ID
193: AND HDR.RELATIONSHIP_ID = TO_NUMBER(c_relationship_id)
194: AND HDR.INVENTORY_ITEM_ID = c_inv_item_id

Line 200: CURSOR c_get_path_postions(c_relationship_id AHL_RA_DEFINITION_HDR.RELATIONSHIP_ID%TYPE) IS

196: AND (HDR.ITEM_REVISION IS NULL OR HDR.ITEM_REVISION = c_inv_item_revision)
197: -- AND nvl(HDR.ITEM_REVISION,-1) = nvl(c_inv_item_revision,-1)
198: AND DTLS.MTBF_VALUE IS NOT NULL;
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