View: CSTBV_MANUFACTURING_GL_BATCH

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CSTBV_MANUFACTURING_GL_BATCH

View Text

SELECT /* REGULAR ATTRIBUTE */ OGB.ORGANIZATION_ID
, OGB.GL_BATCH_ID
, OGB.DESCRIPTION
, MP.ORGANIZATION_CODE
, HAOU.NAME
, /* ID */ OGB.ACCT_PERIOD_ID
, OGB.GL_BATCH_DATE
, /* WHO */ OGB.CREATION_DATE
, OGB.CREATED_BY
, OGB.LAST_UPDATE_DATE
, OGB.LAST_UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, ORG_GL_BATCHES OGB
WHERE OGB.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = OGB.ORGANIZATION_ID
AND '_SEC:OGB.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns