VIEW: APPS.GMP_EAM_JOBS_RESOURCES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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