VIEW: APPS.GL_AUTO_ALLOC_BATCH_HISTORY_V

Source

View Text - Preformatted

SELECT min(h.Rowid) ROW_ID, h.REQUEST_ID, min(h.BATCH_ID) BATCH_ID, min(h.BATCH_TYPE_CODE) BATCH_TYPE_CODE, h.STEP_NUMBER, min(h.OWNER) OWNER, min(h.ALLOCATION_METHOD_CODE) ALLOCATION_METHOD_CODE, min(h.GENERATED_JE_BATCH_ID) GENERATED_JE_BATCH_ID, min(h.PA_ALLOCATION_RUN_ID) PA_ALLOCATION_RUN_ID, min(h.STATUS_CODE) STATUS_CODE, min(h.COMPLETE_FLAG) COMPLETE_FLAG, min(h.ALL_HEADERS_REVERSED) ALL_HEADERS_REVERSED, min(h.LAST_UPDATE_DATE) LAST_UPDATE_DATE, min(h.LAST_UPDATED_BY) LAST_UPDATED_BY, min(h.LAST_UPDATE_LOGIN) LAST_UPDATE_LOGIN, min(h.CREATION_DATE) CREATION_DATE, min(h.CREATED_BY) CREATED_BY, min(decode(h.batch_type_code,'R',r.name,'P',p.rule_name,a.name)) ALLOC_BATCH_NAME, min(l.meaning) ALLOCATION_METHOD, min(l2.meaning) ALLOCATION_BATCH_TYPE, min(substr(gl_auto_alloc_vw_pkg.get_owner_dsp(Owner),1,240)) ROLE From GL_LOOKUPS l2, GL_LOOKUPS l, PA_AUTOALLOC_RULES_V p, GL_RECURRING_BATCHES r, GL_ALLOC_BATCHES a, GL_AUTO_ALLOC_BATCH_HISTORY h WHERE a.allocation_batch_id(+) = h.batch_id AND r.recurring_batch_id(+) = h.batch_id AND p.rule_id(+) = h.batch_id AND l.lookup_type = 'ALLOCATION_METHOD_CODE' AND l.lookup_code = h.allocation_method_code AND l2.lookup_type = 'AUTOALLOCATION' AND l2.lookup_code = h.batch_type_code GROUP BY h.request_id,h.step_number

View Text - HTML Formatted

SELECT MIN(H.ROWID) ROW_ID
, H.REQUEST_ID
, MIN(H.BATCH_ID) BATCH_ID
, MIN(H.BATCH_TYPE_CODE) BATCH_TYPE_CODE
, H.STEP_NUMBER
, MIN(H.OWNER) OWNER
, MIN(H.ALLOCATION_METHOD_CODE) ALLOCATION_METHOD_CODE
, MIN(H.GENERATED_JE_BATCH_ID) GENERATED_JE_BATCH_ID
, MIN(H.PA_ALLOCATION_RUN_ID) PA_ALLOCATION_RUN_ID
, MIN(H.STATUS_CODE) STATUS_CODE
, MIN(H.COMPLETE_FLAG) COMPLETE_FLAG
, MIN(H.ALL_HEADERS_REVERSED) ALL_HEADERS_REVERSED
, MIN(H.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, MIN(H.LAST_UPDATED_BY) LAST_UPDATED_BY
, MIN(H.LAST_UPDATE_LOGIN) LAST_UPDATE_LOGIN
, MIN(H.CREATION_DATE) CREATION_DATE
, MIN(H.CREATED_BY) CREATED_BY
, MIN(DECODE(H.BATCH_TYPE_CODE
, 'R'
, R.NAME
, 'P'
, P.RULE_NAME
, A.NAME)) ALLOC_BATCH_NAME
, MIN(L.MEANING) ALLOCATION_METHOD
, MIN(L2.MEANING) ALLOCATION_BATCH_TYPE
, MIN(SUBSTR(GL_AUTO_ALLOC_VW_PKG.GET_OWNER_DSP(OWNER)
, 1
, 240)) ROLE
FROM GL_LOOKUPS L2
, GL_LOOKUPS L
, PA_AUTOALLOC_RULES_V P
, GL_RECURRING_BATCHES R
, GL_ALLOC_BATCHES A
, GL_AUTO_ALLOC_BATCH_HISTORY H
WHERE A.ALLOCATION_BATCH_ID(+) = H.BATCH_ID
AND R.RECURRING_BATCH_ID(+) = H.BATCH_ID
AND P.RULE_ID(+) = H.BATCH_ID
AND L.LOOKUP_TYPE = 'ALLOCATION_METHOD_CODE'
AND L.LOOKUP_CODE = H.ALLOCATION_METHOD_CODE
AND L2.LOOKUP_TYPE = 'AUTOALLOCATION'
AND L2.LOOKUP_CODE = H.BATCH_TYPE_CODE GROUP BY H.REQUEST_ID
, H.STEP_NUMBER