Product: | GL - General Ledger |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GL_AUTO_ALLOC_BATCH_HISTORY_V |
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