APPS.AHL_RA_ANALYSER_PVT dependencies on AHL_RA_DEFINITION_DTLS

Line 191: AHL_RA_DEFINITION_DTLS DTLS

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
195: AND HDR.INVENTORY_ORG_ID = c_inv_org_id