View: EGO_PUB_BATCH_STATUS_VL

Product:	EGO - Advanced Product Catalog
Description:
Implementation/DBA Data:	APPS.EGO_PUB_BATCH_STATUS_VL

View Text

SELECT BHR.BATCH_ID
, BHR.BATCH_NAME
, BHR.BATCH_TYPE
, BHR.RESPONSIBILITY_ID
, BHR.BATCH_CREATION_DATE
, BHR.PUBLISHED_BY
, BEL.BATCH_ENTITY_OBJECT_ID
, BEL.PK1_VALUE
, BEL.PK2_VALUE
, BEL.PK3_VALUE
, BEL.PK4_VALUE
, BEL.PK5_VALUE
, BEL.USER_ENTERED
, BEL.ENTITY_TYPE_ID
, BS.STATUS_CODE
, BS.MESSAGE
, SYS.ORIG_SYSTEM AS SYSTEM_CODE
, SYS.ORIG_SYSTEM_NAME AS SYSTEM_NAME
, FND.MEANING AS STATUS
, FND.DESCRIPTION AS STATUS_DESCRIPTION
, BHR.CREATED_BY FROM EGO_PUB_BAT_ENT_OBJS_B BEL
, EGO_PUB_BAT_HDR_B BHR
, EGO_PUB_BAT_STATUS_B BS
, HZ_ORIG_SYSTEMS_VL SYS
, FND_LOOKUPS FND WHERE BHR.BATCH_ID = BEL.BATCH_ID
AND BEL.BATCH_ID = BS.BATCH_ID AND BEL.BATCH_ENTITY_OBJECT_ID = BS.BATCH_ENTITY_OBJECT_ID AND BS.SYSTEM_CODE = SYS.ORIG_SYSTEM AND FND.LOOKUP_TYPE = 'EGO_PUBLICATION_STATUS' AND FND.LOOKUP_CODE = BS.STATUS_CODE