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.OPI_EDW_TIME_CAL_QTR_LTC_V

Source

View Text - Preformatted


SELECT distinct time.CQTR_CAL_QTR_PK_KEY ID, time.CQTR_NAME VALUE, time.CQTR_START_DATE START_DATE, time.CQTR_END_DATE END_DATE, inv_org.PLANT_PK_KEY ORGANIZATION_ID, 'EDW_MTL_ILDM_PLANT' ORGANIZATION_TYPE from EDW_MTL_ILDM_OU_LTC inv_ou, EDW_ORGA_OPER_UNIT_LTC ou, EDW_ORGA_LEG_ENTITY_LTC leg, EDW_GL_BOOK_M sob, EDW_TIME_M time, EDW_TIME_CAL_QTR_LTC prd, EDW_MTL_ILDM_PLANT_LTC inv_org WHERE inv_ou.OPERATING_UNIT_PK_KEY = inv_org.OPERATING_UNIT_FK_KEY and ou.OPERATING_UNIT_PK = inv_ou.OPERATING_UNIT_PK and leg.LEGAL_ENTITY_PK_KEY = ou.LEGAL_ENTITY_FK_KEY and sob.SOBL_GL_BOOK = leg.SET_OF_BOOKS and sob.SOBL_PERIOD_SET_NAME = time.CNAM_CAL_NAME and prd.CAL_QTR_PK_KEY = time.CQTR_CAL_QTR_PK_KEY and substr(prd.CAL_QTR_PK, instr( prd.CAL_QTR_PK,'-',-1,1)+1, 30) = substr( inv_org.PLANT_PK, instr( inv_org.PLANT_PK, '-',1,1)+1, decode( instr(inv_org.PLANT_PK, '-',1,2), 0, length(inv_org.PLANT_PK) - instr( inv_org.PLANT_PK, '-',1,1), (instr(inv_org.PLANT_PK,'-',1,2)- instr(inv_org.PLANT_PK,'-',1,1)-1) ) ) UNION ALL select distinct time.CQTR_CAL_QTR_PK_KEY ID, time.CQTR_NAME VALUE, time.CQTR_START_DATE START_DATE, time.CQTR_END_DATE END_DATE, org.ORGA_ORGANIZATION_PK_KEY ORGANIZATION_ID, 'EDW_ORGA_ORG' ORGANIZATION_TYPE from edw_organization_m org, EDW_GL_BOOK_M sob, EDW_TIME_M time, EDW_TIME_CAL_QTR_LTC prd where org.LGET_SET_OF_BOOKS = sob.SOBL_GL_BOOK and sob.SOBL_PERIOD_SET_NAME = time.CNAM_CAL_NAME and prd.CAL_QTR_PK_KEY = time.CQTR_CAL_QTR_PK_KEY and substr(prd.CAL_QTR_PK, instr( prd.CAL_QTR_PK,'-',-1,1)+1, 30) = substr( org.ORGA_ORGANIZATION_PK, instr( org.ORGA_ORGANIZATION_PK, '-',1,1)+1, decode( instr(org.ORGA_ORGANIZATION_PK, '-',1,2), 0, length(org.ORGA_ORGANIZATION_PK) - instr( org.ORGA_ORGANIZATION_PK, '-',1,1), (instr(org.ORGA_ORGANIZATION_PK,'-',1,2)- instr(org.ORGA_ORGANIZATION_PK,'-',1,1)-1) ) ) UNION ALL select distinct time.CQTR_CAL_QTR_PK_KEY ID, time.CQTR_NAME VALUE, time.CQTR_START_DATE START_DATE, time.CQTR_END_DATE END_DATE, ou.OPERATING_UNIT_PK_KEY ORGANIZATION_ID, 'EDW_ORGA_OPER_UNIT' ORGANIZATION_TYPE from EDW_ORGA_OPER_UNIT_LTC ou, EDW_ORGA_LEG_ENTITY_LTC leg, EDW_GL_BOOK_M sob, EDW_TIME_M time, EDW_TIME_CAL_QTR_LTC prd where leg.LEGAL_ENTITY_PK_KEY = ou.LEGAL_ENTITY_FK_KEY and sob.SOBL_GL_BOOK = leg.SET_OF_BOOKS and sob.SOBL_PERIOD_SET_NAME = time.CNAM_CAL_NAME and prd.CAL_QTR_PK_KEY = time.CQTR_CAL_QTR_PK_KEY and substr(prd.CAL_QTR_PK, instr( prd.CAL_QTR_PK,'-',-1,1)+1, 30) = substr( ou.OPERATING_UNIT_PK, instr( ou.OPERATING_UNIT_PK, '-',1,1)+1, decode( instr(ou.OPERATING_UNIT_PK, '-',1,2), 0, length(ou.OPERATING_UNIT_PK) - instr( ou.OPERATING_UNIT_PK, '-',1,1), (instr(ou.OPERATING_UNIT_PK,'-',1,2)- instr(ou.OPERATING_UNIT_PK,'-',1,1)-1) ) ) UNION ALL select distinct time.CQTR_CAL_QTR_PK_KEY ID, time.CQTR_NAME VALUE, time.CQTR_START_DATE START_DATE, time.CQTR_END_DATE END_DATE, inv_ou.OPERATING_UNIT_PK_KEY ORGANIZATION_ID, 'EDW_MTL_ILDM_OU' ORGANIZATION_TYPE from EDW_MTL_ILDM_OU_LTC inv_ou, EDW_ORGA_OPER_UNIT_LTC ou, EDW_ORGA_LEG_ENTITY_LTC leg, EDW_GL_BOOK_M sob, EDW_TIME_M time, EDW_TIME_CAL_QTR_LTC prd where ou.OPERATING_UNIT_PK = inv_ou.OPERATING_UNIT_PK and leg.LEGAL_ENTITY_PK_KEY = ou.LEGAL_ENTITY_FK_KEY and sob.SOBL_GL_BOOK = leg.SET_OF_BOOKS and sob.SOBL_PERIOD_SET_NAME = time.CNAM_CAL_NAME and prd.CAL_QTR_PK_KEY = time.CQTR_CAL_QTR_PK_KEY and substr(prd.CAL_QTR_PK, instr( prd.CAL_QTR_PK,'-',-1,1)+1, 30) = substr( inv_ou.OPERATING_UNIT_PK, instr( inv_ou.OPERATING_UNIT_PK, '-',1,1)+1, decode( instr(inv_ou.OPERATING_UNIT_PK, '-',1,2), 0, length(inv_ou.OPERATING_UNIT_PK) - instr( inv_ou.OPERATING_UNIT_PK, '-',1,1), (instr(inv_ou.OPERATING_UNIT_PK,'-',1,2)- instr(inv_ou.OPERATING_UNIT_PK,'-',1,1)-1) ) )

View Text - HTML Formatted

SELECT DISTINCT TIME.CQTR_CAL_QTR_PK_KEY ID
, TIME.CQTR_NAME VALUE
, TIME.CQTR_START_DATE START_DATE
, TIME.CQTR_END_DATE END_DATE
, INV_ORG.PLANT_PK_KEY ORGANIZATION_ID
, 'EDW_MTL_ILDM_PLANT' ORGANIZATION_TYPE
FROM EDW_MTL_ILDM_OU_LTC INV_OU
, EDW_ORGA_OPER_UNIT_LTC OU
, EDW_ORGA_LEG_ENTITY_LTC LEG
, EDW_GL_BOOK_M SOB
, EDW_TIME_M TIME
, EDW_TIME_CAL_QTR_LTC PRD
, EDW_MTL_ILDM_PLANT_LTC INV_ORG
WHERE INV_OU.OPERATING_UNIT_PK_KEY = INV_ORG.OPERATING_UNIT_FK_KEY
AND OU.OPERATING_UNIT_PK = INV_OU.OPERATING_UNIT_PK
AND LEG.LEGAL_ENTITY_PK_KEY = OU.LEGAL_ENTITY_FK_KEY
AND SOB.SOBL_GL_BOOK = LEG.SET_OF_BOOKS
AND SOB.SOBL_PERIOD_SET_NAME = TIME.CNAM_CAL_NAME
AND PRD.CAL_QTR_PK_KEY = TIME.CQTR_CAL_QTR_PK_KEY
AND SUBSTR(PRD.CAL_QTR_PK
, INSTR( PRD.CAL_QTR_PK
, '-'
, -1
, 1)+1
, 30) = SUBSTR( INV_ORG.PLANT_PK
, INSTR( INV_ORG.PLANT_PK
, '-'
, 1
, 1)+1
, DECODE( INSTR(INV_ORG.PLANT_PK
, '-'
, 1
, 2)
, 0
, LENGTH(INV_ORG.PLANT_PK) - INSTR( INV_ORG.PLANT_PK
, '-'
, 1
, 1)
, (INSTR(INV_ORG.PLANT_PK
, '-'
, 1
, 2)- INSTR(INV_ORG.PLANT_PK
, '-'
, 1
, 1)-1) ) ) UNION ALL SELECT DISTINCT TIME.CQTR_CAL_QTR_PK_KEY ID
, TIME.CQTR_NAME VALUE
, TIME.CQTR_START_DATE START_DATE
, TIME.CQTR_END_DATE END_DATE
, ORG.ORGA_ORGANIZATION_PK_KEY ORGANIZATION_ID
, 'EDW_ORGA_ORG' ORGANIZATION_TYPE
FROM EDW_ORGANIZATION_M ORG
, EDW_GL_BOOK_M SOB
, EDW_TIME_M TIME
, EDW_TIME_CAL_QTR_LTC PRD
WHERE ORG.LGET_SET_OF_BOOKS = SOB.SOBL_GL_BOOK
AND SOB.SOBL_PERIOD_SET_NAME = TIME.CNAM_CAL_NAME
AND PRD.CAL_QTR_PK_KEY = TIME.CQTR_CAL_QTR_PK_KEY
AND SUBSTR(PRD.CAL_QTR_PK
, INSTR( PRD.CAL_QTR_PK
, '-'
, -1
, 1)+1
, 30) = SUBSTR( ORG.ORGA_ORGANIZATION_PK
, INSTR( ORG.ORGA_ORGANIZATION_PK
, '-'
, 1
, 1)+1
, DECODE( INSTR(ORG.ORGA_ORGANIZATION_PK
, '-'
, 1
, 2)
, 0
, LENGTH(ORG.ORGA_ORGANIZATION_PK) - INSTR( ORG.ORGA_ORGANIZATION_PK
, '-'
, 1
, 1)
, (INSTR(ORG.ORGA_ORGANIZATION_PK
, '-'
, 1
, 2)- INSTR(ORG.ORGA_ORGANIZATION_PK
, '-'
, 1
, 1)-1) ) ) UNION ALL SELECT DISTINCT TIME.CQTR_CAL_QTR_PK_KEY ID
, TIME.CQTR_NAME VALUE
, TIME.CQTR_START_DATE START_DATE
, TIME.CQTR_END_DATE END_DATE
, OU.OPERATING_UNIT_PK_KEY ORGANIZATION_ID
, 'EDW_ORGA_OPER_UNIT' ORGANIZATION_TYPE
FROM EDW_ORGA_OPER_UNIT_LTC OU
, EDW_ORGA_LEG_ENTITY_LTC LEG
, EDW_GL_BOOK_M SOB
, EDW_TIME_M TIME
, EDW_TIME_CAL_QTR_LTC PRD
WHERE LEG.LEGAL_ENTITY_PK_KEY = OU.LEGAL_ENTITY_FK_KEY
AND SOB.SOBL_GL_BOOK = LEG.SET_OF_BOOKS
AND SOB.SOBL_PERIOD_SET_NAME = TIME.CNAM_CAL_NAME
AND PRD.CAL_QTR_PK_KEY = TIME.CQTR_CAL_QTR_PK_KEY
AND SUBSTR(PRD.CAL_QTR_PK
, INSTR( PRD.CAL_QTR_PK
, '-'
, -1
, 1)+1
, 30) = SUBSTR( OU.OPERATING_UNIT_PK
, INSTR( OU.OPERATING_UNIT_PK
, '-'
, 1
, 1)+1
, DECODE( INSTR(OU.OPERATING_UNIT_PK
, '-'
, 1
, 2)
, 0
, LENGTH(OU.OPERATING_UNIT_PK) - INSTR( OU.OPERATING_UNIT_PK
, '-'
, 1
, 1)
, (INSTR(OU.OPERATING_UNIT_PK
, '-'
, 1
, 2)- INSTR(OU.OPERATING_UNIT_PK
, '-'
, 1
, 1)-1) ) ) UNION ALL SELECT DISTINCT TIME.CQTR_CAL_QTR_PK_KEY ID
, TIME.CQTR_NAME VALUE
, TIME.CQTR_START_DATE START_DATE
, TIME.CQTR_END_DATE END_DATE
, INV_OU.OPERATING_UNIT_PK_KEY ORGANIZATION_ID
, 'EDW_MTL_ILDM_OU' ORGANIZATION_TYPE
FROM EDW_MTL_ILDM_OU_LTC INV_OU
, EDW_ORGA_OPER_UNIT_LTC OU
, EDW_ORGA_LEG_ENTITY_LTC LEG
, EDW_GL_BOOK_M SOB
, EDW_TIME_M TIME
, EDW_TIME_CAL_QTR_LTC PRD
WHERE OU.OPERATING_UNIT_PK = INV_OU.OPERATING_UNIT_PK
AND LEG.LEGAL_ENTITY_PK_KEY = OU.LEGAL_ENTITY_FK_KEY
AND SOB.SOBL_GL_BOOK = LEG.SET_OF_BOOKS
AND SOB.SOBL_PERIOD_SET_NAME = TIME.CNAM_CAL_NAME
AND PRD.CAL_QTR_PK_KEY = TIME.CQTR_CAL_QTR_PK_KEY
AND SUBSTR(PRD.CAL_QTR_PK
, INSTR( PRD.CAL_QTR_PK
, '-'
, -1
, 1)+1
, 30) = SUBSTR( INV_OU.OPERATING_UNIT_PK
, INSTR( INV_OU.OPERATING_UNIT_PK
, '-'
, 1
, 1)+1
, DECODE( INSTR(INV_OU.OPERATING_UNIT_PK
, '-'
, 1
, 2)
, 0
, LENGTH(INV_OU.OPERATING_UNIT_PK) - INSTR( INV_OU.OPERATING_UNIT_PK
, '-'
, 1
, 1)
, (INSTR(INV_OU.OPERATING_UNIT_PK
, '-'
, 1
, 2)- INSTR(INV_OU.OPERATING_UNIT_PK
, '-'
, 1
, 1)-1) ) )