VIEW: APPS.MRP_WEB_HORIZONTAL_PLAN_V

Source

View Text - Preformatted

SELECT DISTINCT DATES.PLANNED_ORGANIZATION , DATES.COMPILE_DESIGNATOR , param.organization_code , DATES.ORGANIZATION_ID , INVENTORY_ITEM_ID , ITEM_SEGMENTS , to_number(null) , TO_CHAR(NULL) , TO_CHAR(DATE1) , TO_CHAR(DATE2) , TO_CHAR(DATE3) , TO_CHAR(DATE4) , TO_CHAR(DATE5) , TO_CHAR(DATE6) , TO_CHAR(DATE7) , TO_CHAR(DATE8) , TO_CHAR(DATE9) , TO_CHAR(DATE10) , TO_CHAR(DATE11) , TO_CHAR(DATE12) , TO_CHAR(DATE13) , TO_CHAR(DATE14) , TO_CHAR(DATE15) , TO_CHAR(DATE16) , TO_CHAR(DATE17) , TO_CHAR(DATE18) , TO_CHAR(DATE19) , TO_CHAR(DATE20) , TO_CHAR(DATE21) , TO_CHAR(DATE22) , TO_CHAR(DATE23) , TO_CHAR(DATE24) , TO_CHAR(DATE25) , TO_CHAR(DATE26) , TO_CHAR(DATE27) , TO_CHAR(DATE28) , TO_CHAR(DATE29) , TO_CHAR(DATE30) , TO_CHAR(DATE31) , TO_CHAR(DATE32) , TO_CHAR(DATE33) , TO_CHAR(DATE34) , TO_CHAR(DATE35) , TO_CHAR(DATE36) ,NVL( PRJ.PLANNING_GROUP,'-') ,NVL( PRJ.PROJECT_ID,-1) , NVL(TSK.TASK_ID,-1) , PRJ.PROJECT_NUMBER , TSK.TASK_NUMBER FROM MRP_WORKBENCH_BUCKET_DATES DATES , MRP_MATERIAL_PLANS MP, mtl_parameters param, MRP_PROJECT_V PRJ, MRP_TASK_V TSK WHERE NVL(TSK.PROJECT_ID, 1) = NVL(PRJ.PROJECT_ID, 1) and param.organization_id = dates.planned_organization AND DATES.BUCKET_TYPE = 2 AND DATES.PLANNED_ORGANIZATION = MP.ORGANIZATION_ID AND DATES.COMPILE_DESIGNATOR = MP.COMPILE_DESIGNATOR UNION ALL SELECT PLANS.ORGANIZATION_ID, PLANS.COMPILE_DESIGNATOR, param.ORGANIZATION_CODE, PLANS.PLAN_ORGANIZATION_ID, PLANS.INVENTORY_ITEM_ID, PLANS.ITEM_SEGMENTS, PLANS.HORIZONTAL_PLAN_TYPE, PLANS.HORIZONTAL_PLAN_TYPE_TEXT, TO_CHAR(PLANS.QUANTITY1), TO_CHAR(PLANS.QUANTITY2), TO_CHAR(PLANS.QUANTITY3), TO_CHAR(PLANS.QUANTITY4), TO_CHAR(PLANS.QUANTITY5), TO_CHAR(PLANS.QUANTITY6), TO_CHAR(PLANS.QUANTITY7), TO_CHAR(PLANS.QUANTITY8), TO_CHAR(PLANS.QUANTITY9), TO_CHAR(PLANS.QUANTITY10), TO_CHAR(PLANS.QUANTITY11), TO_CHAR(PLANS.QUANTITY12), TO_CHAR(PLANS.QUANTITY13), TO_CHAR(PLANS.QUANTITY14), TO_CHAR(PLANS.QUANTITY15), TO_CHAR(PLANS.QUANTITY16), TO_CHAR(PLANS.QUANTITY17), TO_CHAR(PLANS.QUANTITY18), TO_CHAR(PLANS.QUANTITY19), TO_CHAR(PLANS.QUANTITY20), TO_CHAR(PLANS.QUANTITY21), TO_CHAR(PLANS.QUANTITY22), TO_CHAR(PLANS.QUANTITY23), TO_CHAR(PLANS.QUANTITY24), TO_CHAR(PLANS.QUANTITY25), TO_CHAR(PLANS.QUANTITY26), TO_CHAR(PLANS.QUANTITY27), TO_CHAR(PLANS.QUANTITY28), TO_CHAR(PLANS.QUANTITY29), TO_CHAR(PLANS.QUANTITY30), TO_CHAR(PLANS.QUANTITY31), TO_CHAR(PLANS.QUANTITY32), TO_CHAR(PLANS.QUANTITY33), TO_CHAR(PLANS.QUANTITY34), TO_CHAR(PLANS.QUANTITY35), TO_CHAR(PLANS.QUANTITY36), NVL( PRJ.PLANNING_GROUP,'-'), NVL( PRJ.PROJECT_ID,-1), NVL( TSK.TASK_ID,-1), PRJ.PROJECT_NUMBER, TSK.TASK_NUMBER FROM MRP_MATERIAL_PLANS PLANS, mtl_parameters param, MRP_PROJECT_V PRJ, MRP_TASK_V TSK WHERE NVL(TSK.PROJECT_ID, 1) = NVL(PRJ.PROJECT_ID, 1) and param.organization_id = plans.organization_id AND BUCKET_TYPE = 2 AND PLAN_ID = (SELECT MAX(MP.PLAN_ID) FROM MRP_MATERIAL_PLANS MP WHERE MP.BUCKET_TYPE = 2) AND HORIZONTAL_PLAN_TYPE IN (10,20,30,70,81,83,85,87,89,90)

View Text - HTML Formatted

SELECT DISTINCT DATES.PLANNED_ORGANIZATION
, DATES.COMPILE_DESIGNATOR
, PARAM.ORGANIZATION_CODE
, DATES.ORGANIZATION_ID
, INVENTORY_ITEM_ID
, ITEM_SEGMENTS
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(DATE1)
, TO_CHAR(DATE2)
, TO_CHAR(DATE3)
, TO_CHAR(DATE4)
, TO_CHAR(DATE5)
, TO_CHAR(DATE6)
, TO_CHAR(DATE7)
, TO_CHAR(DATE8)
, TO_CHAR(DATE9)
, TO_CHAR(DATE10)
, TO_CHAR(DATE11)
, TO_CHAR(DATE12)
, TO_CHAR(DATE13)
, TO_CHAR(DATE14)
, TO_CHAR(DATE15)
, TO_CHAR(DATE16)
, TO_CHAR(DATE17)
, TO_CHAR(DATE18)
, TO_CHAR(DATE19)
, TO_CHAR(DATE20)
, TO_CHAR(DATE21)
, TO_CHAR(DATE22)
, TO_CHAR(DATE23)
, TO_CHAR(DATE24)
, TO_CHAR(DATE25)
, TO_CHAR(DATE26)
, TO_CHAR(DATE27)
, TO_CHAR(DATE28)
, TO_CHAR(DATE29)
, TO_CHAR(DATE30)
, TO_CHAR(DATE31)
, TO_CHAR(DATE32)
, TO_CHAR(DATE33)
, TO_CHAR(DATE34)
, TO_CHAR(DATE35)
, TO_CHAR(DATE36)
, NVL( PRJ.PLANNING_GROUP
, '-')
, NVL( PRJ.PROJECT_ID
, -1)
, NVL(TSK.TASK_ID
, -1)
, PRJ.PROJECT_NUMBER
, TSK.TASK_NUMBER
FROM MRP_WORKBENCH_BUCKET_DATES DATES
, MRP_MATERIAL_PLANS MP
, MTL_PARAMETERS PARAM
, MRP_PROJECT_V PRJ
, MRP_TASK_V TSK
WHERE NVL(TSK.PROJECT_ID
, 1) = NVL(PRJ.PROJECT_ID
, 1)
AND PARAM.ORGANIZATION_ID = DATES.PLANNED_ORGANIZATION
AND DATES.BUCKET_TYPE = 2
AND DATES.PLANNED_ORGANIZATION = MP.ORGANIZATION_ID
AND DATES.COMPILE_DESIGNATOR = MP.COMPILE_DESIGNATOR UNION ALL SELECT PLANS.ORGANIZATION_ID
, PLANS.COMPILE_DESIGNATOR
, PARAM.ORGANIZATION_CODE
, PLANS.PLAN_ORGANIZATION_ID
, PLANS.INVENTORY_ITEM_ID
, PLANS.ITEM_SEGMENTS
, PLANS.HORIZONTAL_PLAN_TYPE
, PLANS.HORIZONTAL_PLAN_TYPE_TEXT
, TO_CHAR(PLANS.QUANTITY1)
, TO_CHAR(PLANS.QUANTITY2)
, TO_CHAR(PLANS.QUANTITY3)
, TO_CHAR(PLANS.QUANTITY4)
, TO_CHAR(PLANS.QUANTITY5)
, TO_CHAR(PLANS.QUANTITY6)
, TO_CHAR(PLANS.QUANTITY7)
, TO_CHAR(PLANS.QUANTITY8)
, TO_CHAR(PLANS.QUANTITY9)
, TO_CHAR(PLANS.QUANTITY10)
, TO_CHAR(PLANS.QUANTITY11)
, TO_CHAR(PLANS.QUANTITY12)
, TO_CHAR(PLANS.QUANTITY13)
, TO_CHAR(PLANS.QUANTITY14)
, TO_CHAR(PLANS.QUANTITY15)
, TO_CHAR(PLANS.QUANTITY16)
, TO_CHAR(PLANS.QUANTITY17)
, TO_CHAR(PLANS.QUANTITY18)
, TO_CHAR(PLANS.QUANTITY19)
, TO_CHAR(PLANS.QUANTITY20)
, TO_CHAR(PLANS.QUANTITY21)
, TO_CHAR(PLANS.QUANTITY22)
, TO_CHAR(PLANS.QUANTITY23)
, TO_CHAR(PLANS.QUANTITY24)
, TO_CHAR(PLANS.QUANTITY25)
, TO_CHAR(PLANS.QUANTITY26)
, TO_CHAR(PLANS.QUANTITY27)
, TO_CHAR(PLANS.QUANTITY28)
, TO_CHAR(PLANS.QUANTITY29)
, TO_CHAR(PLANS.QUANTITY30)
, TO_CHAR(PLANS.QUANTITY31)
, TO_CHAR(PLANS.QUANTITY32)
, TO_CHAR(PLANS.QUANTITY33)
, TO_CHAR(PLANS.QUANTITY34)
, TO_CHAR(PLANS.QUANTITY35)
, TO_CHAR(PLANS.QUANTITY36)
, NVL( PRJ.PLANNING_GROUP
, '-')
, NVL( PRJ.PROJECT_ID
, -1)
, NVL( TSK.TASK_ID
, -1)
, PRJ.PROJECT_NUMBER
, TSK.TASK_NUMBER
FROM MRP_MATERIAL_PLANS PLANS
, MTL_PARAMETERS PARAM
, MRP_PROJECT_V PRJ
, MRP_TASK_V TSK
WHERE NVL(TSK.PROJECT_ID
, 1) = NVL(PRJ.PROJECT_ID
, 1)
AND PARAM.ORGANIZATION_ID = PLANS.ORGANIZATION_ID
AND BUCKET_TYPE = 2
AND PLAN_ID = (SELECT MAX(MP.PLAN_ID)
FROM MRP_MATERIAL_PLANS MP
WHERE MP.BUCKET_TYPE = 2)
AND HORIZONTAL_PLAN_TYPE IN (10
, 20
, 30
, 70
, 81
, 83
, 85
, 87
, 89
, 90)