VIEW: APPS.AHL_MR_INTERVALS_V

Source

View Text - Preformatted

SELECT i.mr_interval_id, i.object_version_number, i.mr_effectivity_id, i.counter_id, c.name, m.unit_of_measure, i.interval_value, i.EARLIEST_DUE_VALUE, i.start_value, i.stop_value, i.start_date, i.stop_date, i.tolerance_before, i.tolerance_after, i.reset_value, i.attribute_category, i.attribute1, i.attribute2, i.attribute3, i.attribute4, i.attribute5, i.attribute6, i.attribute7, i.attribute8, i.attribute9, i.attribute10, i.attribute11, i.attribute12, i.attribute13, i.attribute14, i.attribute15, mrh.application_usg_code, i.CALC_DUEDATE_RULE_CODE, fnd.meaning CALC_DUEDATE_RULE FROM ahl_mr_intervals i, ahl_mr_effectivities eff, ahl_mr_headers_b mrh, cs_counters c, mtl_units_of_measure_vl m, fnd_lookups fnd WHERE i.counter_id = c.counter_id AND c.uom_code = m.uom_code AND mrh.application_usg_code = fnd_profile.value('AHL_APPLN_USAGE') AND i.mr_effectivity_id = eff.mr_effectivity_id AND eff.mr_header_id = mrh.mr_header_id AND fnd.lookup_type(+) = 'AHL_DUEDATE_RULE' AND fnd.lookup_code(+) = i.CALC_DUEDATE_RULE_CODE

View Text - HTML Formatted

SELECT I.MR_INTERVAL_ID
, I.OBJECT_VERSION_NUMBER
, I.MR_EFFECTIVITY_ID
, I.COUNTER_ID
, C.NAME
, M.UNIT_OF_MEASURE
, I.INTERVAL_VALUE
, I.EARLIEST_DUE_VALUE
, I.START_VALUE
, I.STOP_VALUE
, I.START_DATE
, I.STOP_DATE
, I.TOLERANCE_BEFORE
, I.TOLERANCE_AFTER
, I.RESET_VALUE
, I.ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1
, I.ATTRIBUTE2
, I.ATTRIBUTE3
, I.ATTRIBUTE4
, I.ATTRIBUTE5
, I.ATTRIBUTE6
, I.ATTRIBUTE7
, I.ATTRIBUTE8
, I.ATTRIBUTE9
, I.ATTRIBUTE10
, I.ATTRIBUTE11
, I.ATTRIBUTE12
, I.ATTRIBUTE13
, I.ATTRIBUTE14
, I.ATTRIBUTE15
, MRH.APPLICATION_USG_CODE
, I.CALC_DUEDATE_RULE_CODE
, FND.MEANING CALC_DUEDATE_RULE
FROM AHL_MR_INTERVALS I
, AHL_MR_EFFECTIVITIES EFF
, AHL_MR_HEADERS_B MRH
, CS_COUNTERS C
, MTL_UNITS_OF_MEASURE_VL M
, FND_LOOKUPS FND
WHERE I.COUNTER_ID = C.COUNTER_ID
AND C.UOM_CODE = M.UOM_CODE
AND MRH.APPLICATION_USG_CODE = FND_PROFILE.VALUE('AHL_APPLN_USAGE')
AND I.MR_EFFECTIVITY_ID = EFF.MR_EFFECTIVITY_ID
AND EFF.MR_HEADER_ID = MRH.MR_HEADER_ID
AND FND.LOOKUP_TYPE(+) = 'AHL_DUEDATE_RULE'
AND FND.LOOKUP_CODE(+) = I.CALC_DUEDATE_RULE_CODE