VIEW: APPS.PMI_REP_LATE_BATCHES_V

Source

View Text - Preformatted

SELECT org.co_code Company_ID, org.orgn_code Organization_id, glcldr.YEAR_ID YEAR_ID, glcldr.QUARTER_ID QUARTER_ID, glcldr.PERIOD_ID PERIOD_ID, 1 TOT_NO_BTCHS, decode(sign(btch.actual_cmplt_date- (nvl(to_number(fnd_profile.value('PMI_LATE_BTCHS_THRESHOLD')),0)/24) - btch.plan_cmplt_date ),1,1,0 ) LATE_BTCHS from GME_BATCH_HEADER btch, sy_orgn_mst org, gl_plcy_mst fiscalplcy, PMI_GL_TIME_V glcldr WHERE btch.plant_code = org.orgn_code AND org.co_code = fiscalplcy.co_code AND glcldr.set_of_books_name = fiscalplcy.SET_OF_BOOKS_NAME AND btch.batch_status in (3,4) AND btch.batch_type = 0 AND trunc(btch.plan_cmplt_date) between glcldr.PERIOD_start_date and glcldr.PERIOD_end_date AND 'TRUE' = PMI_SECURITY_PKG.show_record(org.orgn_code)

View Text - HTML Formatted

SELECT ORG.CO_CODE COMPANY_ID
, ORG.ORGN_CODE ORGANIZATION_ID
, GLCLDR.YEAR_ID YEAR_ID
, GLCLDR.QUARTER_ID QUARTER_ID
, GLCLDR.PERIOD_ID PERIOD_ID
, 1 TOT_NO_BTCHS
, DECODE(SIGN(BTCH.ACTUAL_CMPLT_DATE- (NVL(TO_NUMBER(FND_PROFILE.VALUE('PMI_LATE_BTCHS_THRESHOLD'))
, 0)/24) - BTCH.PLAN_CMPLT_DATE )
, 1
, 1
, 0 ) LATE_BTCHS
FROM GME_BATCH_HEADER BTCH
, SY_ORGN_MST ORG
, GL_PLCY_MST FISCALPLCY
, PMI_GL_TIME_V GLCLDR
WHERE BTCH.PLANT_CODE = ORG.ORGN_CODE
AND ORG.CO_CODE = FISCALPLCY.CO_CODE
AND GLCLDR.SET_OF_BOOKS_NAME = FISCALPLCY.SET_OF_BOOKS_NAME
AND BTCH.BATCH_STATUS IN (3
, 4)
AND BTCH.BATCH_TYPE = 0
AND TRUNC(BTCH.PLAN_CMPLT_DATE) BETWEEN GLCLDR.PERIOD_START_DATE
AND GLCLDR.PERIOD_END_DATE
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(ORG.ORGN_CODE)