View: GMP_EAM_JOBS_RESOURCES_V

Product:	GMP - Process Manufacturing Process Planning
Description:	View for eAM jobs on OPM resources
Implementation/DBA Data:	APPS.GMP_EAM_JOBS_RESOURCES_V

View Text

SELECT DISTINCT GBH.ROWID
, CRD.RESOURCE_ID
, CRD.ORGANIZATION_ID
, GBH.BATCH_ID
, GBH.BATCH_NO
, GBH.BATCH_NO
, GBH.PLAN_START_DATE
, GBH.PLAN_CMPLT_DATE
, GBH.BATCH_STATUS
, GEM.MEANING
, GBH.BATCH_TYPE
, DECODE(GBH.BATCH_TYPE
, 10
, 'FPO '
, 'BATCH')
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
FROM GME_BATCH_STEP_RESOURCES GBSR
, GME_BATCH_STEP_ACTIVITIES GBSA
, GME_BATCH_STEPS GBS
, GME_BATCH_HEADER GBH
, CR_RSRC_DTL CRD
, GEM_LOOKUPS GEM
WHERE CRD.RESOURCES = GBSR.RESOURCES
AND CRD.ORGANIZATION_ID = GBH.ORGANIZATION_ID
AND GBSR.BATCHSTEP_ACTIVITY_ID = GBSA.BATCHSTEP_ACTIVITY_ID
AND GBSR.BATCHSTEP_ID = GBSA.BATCHSTEP_ID
AND GBSR.BATCH_ID = GBSA.BATCH_ID
AND GBSA.BATCHSTEP_ID = GBS.BATCHSTEP_ID
AND GBSA.BATCH_ID = GBS.BATCH_ID
AND GBS.BATCH_ID = GBH.BATCH_ID
AND GEM.LOOKUP_TYPE ='GME_BATCH_STATUS'
AND GEM.LOOKUP_CODE = GBH.BATCH_STATUS

Columns