View: ORG_GL_BATCHES_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.ORG_GL_BATCHES_V

View Text

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' )

Columns