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

Source

View Text - Preformatted


SELECT a.level4_desc as ALL_DESC, a.level4_value as ALL_SR_LEVEL_PK, a.level4_attribute1 as ALL_ATTRIBUTE1, a.level4_attribute2 as ALL_ATTRIBUTE2, a.level4_attribute3 as ALL_ATTRIBUTE3, a.level4_attribute4 as ALL_ATTRIBUTE4, a.level4_attribute5 as ALL_ATTRIBUTE5, a.level3_desc as ORD_TYPE_DESC, a.level3_value as ORD_TYPE_SR_LEVEL_PK, a.level3_attribute1 as ORD_TYPE_ATTRIBUTE1, a.level3_attribute2 as ORD_TYPE_ATTRIBUTE2, a.level3_attribute3 as ORD_TYPE_ATTRIBUTE3, a.level3_attribute4 as ORD_TYPE_ATTRIBUTE4, a.level3_attribute5 as ORD_TYPE_ATTRIBUTE5, nvl(b.level3_desc, 'NoModel') as MOD_DESC, nvl(b.level3_value, 'No Model') as MOD_SR_LEVEL_PK, b.level3_attribute1 as MOD_ATTRIBUTE1, b.level3_attribute2 as MOD_ATTRIBUTE2, b.level3_attribute3 as MOD_ATTRIBUTE3, b.level3_attribute4 as MOD_ATTRIBUTE4, b.level3_attribute5 as MOD_ATTRIBUTE5, a.level2_desc as ORD_DESC, a.level2_value as ORD_SR_LEVEL_PK, a.level2_attribute1 as ORD_ATTRIBUTE1, a.level2_attribute2 as ORD_ATTRIBUTE2, a.level2_attribute3 as ORD_ATTRIBUTE3, a.level2_attribute4 as ORD_ATTRIBUTE4, a.level2_attribute5 as ORD_ATTRIBUTE5, nvl(b.level2_desc, 'NoModel') as TMOD_DESC, nvl(b.level2_value, 'No Model') as TMOD_SR_LEVEL_PK, b.level2_attribute1 as TMOD_ATTRIBUTE1, b.level2_attribute2 as TMOD_ATTRIBUTE2, b.level2_attribute3 as TMOD_ATTRIBUTE3, b.level2_attribute4 as TMOD_ATTRIBUTE4, b.level2_attribute5 as TMOD_ATTRIBUTE5, a.level1_desc as ORD_LINE_DESC, a.level1_value as ORD_LINE_SR_LEVEL_PK, a.level1_attribute1 as ORD_LINE_ATTRIBUTE1, a.level1_attribute2 as ORD_LINE_ATTRIBUTE2, a.level1_attribute3 as ORD_LINE_ATTRIBUTE3, a.level1_attribute4 as ORD_LINE_ATTRIBUTE4, a.level1_attribute5 as ORD_LINE_ATTRIBUTE5, substr(a.level1_desc,1,159) || substr(decode(a.level1_attribute1, null, null, (select '-'||cus.level1_desc from qpr_dimension_values cus where cus.instance_id=a.instance_id and cus.dim_code='CUS' and cus.hierarchy_code='TRADINGPARTNERCLASS' AND cus.level1_value = a.level1_attribute1 and rownum<2)) ,1, 79) as ORD_LINE_SP_DESC, a.instance_id as INSTANCE_ID from qpr_dimension_values a, qpr_dimension_values b WHERE a.dim_code='ORD' and a.hierarchy_code = 'ORDER' AND a.check_date BETWEEN nvl(qpr_maintain_aw.get_start_date, a.check_date) AND nvl(qpr_maintain_aw.get_end_date, a.check_date) and b.dim_code(+)='ORD' and b.hierarchy_code(+) = 'MODEL' and a.level1_value= b.level1_value(+) and a.instance_id= b.instance_id(+) and a.instance_id=qpr_maintain_aw.get_instance and (qpr_maintain_aw.get_ord_line is null or a.level1_value in (select qpm.attribute_1 from qpr_plan_measures qpm where qpm.price_plan_id=qpr_maintain_aw.get_price_plan_id and qpm.price_plan_meas_grp_id=1 and qpm.run_number=qpr_maintain_aw.get_run_number))

View Text - HTML Formatted

SELECT A.LEVEL4_DESC AS ALL_DESC
, A.LEVEL4_VALUE AS ALL_SR_LEVEL_PK
, A.LEVEL4_ATTRIBUTE1 AS ALL_ATTRIBUTE1
, A.LEVEL4_ATTRIBUTE2 AS ALL_ATTRIBUTE2
, A.LEVEL4_ATTRIBUTE3 AS ALL_ATTRIBUTE3
, A.LEVEL4_ATTRIBUTE4 AS ALL_ATTRIBUTE4
, A.LEVEL4_ATTRIBUTE5 AS ALL_ATTRIBUTE5
, A.LEVEL3_DESC AS ORD_TYPE_DESC
, A.LEVEL3_VALUE AS ORD_TYPE_SR_LEVEL_PK
, A.LEVEL3_ATTRIBUTE1 AS ORD_TYPE_ATTRIBUTE1
, A.LEVEL3_ATTRIBUTE2 AS ORD_TYPE_ATTRIBUTE2
, A.LEVEL3_ATTRIBUTE3 AS ORD_TYPE_ATTRIBUTE3
, A.LEVEL3_ATTRIBUTE4 AS ORD_TYPE_ATTRIBUTE4
, A.LEVEL3_ATTRIBUTE5 AS ORD_TYPE_ATTRIBUTE5
, NVL(B.LEVEL3_DESC
, 'NOMODEL') AS MOD_DESC
, NVL(B.LEVEL3_VALUE
, 'NO MODEL') AS MOD_SR_LEVEL_PK
, B.LEVEL3_ATTRIBUTE1 AS MOD_ATTRIBUTE1
, B.LEVEL3_ATTRIBUTE2 AS MOD_ATTRIBUTE2
, B.LEVEL3_ATTRIBUTE3 AS MOD_ATTRIBUTE3
, B.LEVEL3_ATTRIBUTE4 AS MOD_ATTRIBUTE4
, B.LEVEL3_ATTRIBUTE5 AS MOD_ATTRIBUTE5
, A.LEVEL2_DESC AS ORD_DESC
, A.LEVEL2_VALUE AS ORD_SR_LEVEL_PK
, A.LEVEL2_ATTRIBUTE1 AS ORD_ATTRIBUTE1
, A.LEVEL2_ATTRIBUTE2 AS ORD_ATTRIBUTE2
, A.LEVEL2_ATTRIBUTE3 AS ORD_ATTRIBUTE3
, A.LEVEL2_ATTRIBUTE4 AS ORD_ATTRIBUTE4
, A.LEVEL2_ATTRIBUTE5 AS ORD_ATTRIBUTE5
, NVL(B.LEVEL2_DESC
, 'NOMODEL') AS TMOD_DESC
, NVL(B.LEVEL2_VALUE
, 'NO MODEL') AS TMOD_SR_LEVEL_PK
, B.LEVEL2_ATTRIBUTE1 AS TMOD_ATTRIBUTE1
, B.LEVEL2_ATTRIBUTE2 AS TMOD_ATTRIBUTE2
, B.LEVEL2_ATTRIBUTE3 AS TMOD_ATTRIBUTE3
, B.LEVEL2_ATTRIBUTE4 AS TMOD_ATTRIBUTE4
, B.LEVEL2_ATTRIBUTE5 AS TMOD_ATTRIBUTE5
, A.LEVEL1_DESC AS ORD_LINE_DESC
, A.LEVEL1_VALUE AS ORD_LINE_SR_LEVEL_PK
, A.LEVEL1_ATTRIBUTE1 AS ORD_LINE_ATTRIBUTE1
, A.LEVEL1_ATTRIBUTE2 AS ORD_LINE_ATTRIBUTE2
, A.LEVEL1_ATTRIBUTE3 AS ORD_LINE_ATTRIBUTE3
, A.LEVEL1_ATTRIBUTE4 AS ORD_LINE_ATTRIBUTE4
, A.LEVEL1_ATTRIBUTE5 AS ORD_LINE_ATTRIBUTE5
, SUBSTR(A.LEVEL1_DESC
, 1
, 159) || SUBSTR(DECODE(A.LEVEL1_ATTRIBUTE1
, NULL
, NULL
, (SELECT '-'||CUS.LEVEL1_DESC
FROM QPR_DIMENSION_VALUES CUS
WHERE CUS.INSTANCE_ID=A.INSTANCE_ID
AND CUS.DIM_CODE='CUS'
AND CUS.HIERARCHY_CODE='TRADINGPARTNERCLASS'
AND CUS.LEVEL1_VALUE = A.LEVEL1_ATTRIBUTE1
AND ROWNUM<2))
, 1
, 79) AS ORD_LINE_SP_DESC
, A.INSTANCE_ID AS INSTANCE_ID
FROM QPR_DIMENSION_VALUES A
, QPR_DIMENSION_VALUES B
WHERE A.DIM_CODE='ORD'
AND A.HIERARCHY_CODE = 'ORDER'
AND A.CHECK_DATE BETWEEN NVL(QPR_MAINTAIN_AW.GET_START_DATE
, A.CHECK_DATE)
AND NVL(QPR_MAINTAIN_AW.GET_END_DATE
, A.CHECK_DATE)
AND B.DIM_CODE(+)='ORD'
AND B.HIERARCHY_CODE(+) = 'MODEL'
AND A.LEVEL1_VALUE= B.LEVEL1_VALUE(+)
AND A.INSTANCE_ID= B.INSTANCE_ID(+)
AND A.INSTANCE_ID=QPR_MAINTAIN_AW.GET_INSTANCE
AND (QPR_MAINTAIN_AW.GET_ORD_LINE IS NULL OR A.LEVEL1_VALUE IN (SELECT QPM.ATTRIBUTE_1
FROM QPR_PLAN_MEASURES QPM
WHERE QPM.PRICE_PLAN_ID=QPR_MAINTAIN_AW.GET_PRICE_PLAN_ID
AND QPM.PRICE_PLAN_MEAS_GRP_ID=1
AND QPM.RUN_NUMBER=QPR_MAINTAIN_AW.GET_RUN_NUMBER))