VIEW: APPS.ORG_GL_BATCHES_V

Source

View Text - Preformatted

SELECT Z.CREATION_DATE , Z.GL_BATCH_DATE , DECODE(SIGN(Z.GL_BATCH_ID), 0, NULL, 1, Z.GL_BATCH_ID, -1, NULL, NULL) , Y.PERIOD_NAME , X.MEANING , Z.DESCRIPTION , Z.ORGANIZATION_ID , Z.GL_BATCH_ID , Z.LAST_UPDATE_DATE , Z.LAST_UPDATED_BY , Z.CREATED_BY , Z.LAST_UPDATE_LOGIN , Z.ROWID FROM ORG_GL_BATCHES Z, ORG_ACCT_PERIODS Y, MFG_LOOKUPS X WHERE Z.ORGANIZATION_ID = Y.ORGANIZATION_ID AND Z.ACCT_PERIOD_ID = Y.ACCT_PERIOD_ID AND X.LOOKUP_TYPE = 'MTL_GL_BATCH_STATUS' AND X.ENABLED_FLAG = 'Y' AND X.LOOKUP_CODE = DECODE(SIGN(Z.GL_BATCH_ID), 0, '1', 1, '2', -1, '3', '3' )

View Text - HTML Formatted

SELECT Z.CREATION_DATE
, Z.GL_BATCH_DATE
, DECODE(SIGN(Z.GL_BATCH_ID)
, 0
, NULL
, 1
, Z.GL_BATCH_ID
, -1
, NULL
, NULL)
, Y.PERIOD_NAME
, X.MEANING
, Z.DESCRIPTION
, Z.ORGANIZATION_ID
, Z.GL_BATCH_ID
, Z.LAST_UPDATE_DATE
, Z.LAST_UPDATED_BY
, Z.CREATED_BY
, Z.LAST_UPDATE_LOGIN
, Z.ROWID
FROM ORG_GL_BATCHES Z
, ORG_ACCT_PERIODS Y
, MFG_LOOKUPS X
WHERE Z.ORGANIZATION_ID = Y.ORGANIZATION_ID
AND Z.ACCT_PERIOD_ID = Y.ACCT_PERIOD_ID
AND X.LOOKUP_TYPE = 'MTL_GL_BATCH_STATUS'
AND X.ENABLED_FLAG = 'Y'
AND X.LOOKUP_CODE = DECODE(SIGN(Z.GL_BATCH_ID)
, 0
, '1'
, 1
, '2'
, -1
, '3'
, '3' )