eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.EGO_PUB_BATCH_STATUS_VL

Source

View Text - Preformatted


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

View Text - HTML Formatted

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