Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | Horizontal Plan Information for Web Inquiries |
Implementation/DBA Data: | APPS.MRP_WEB_HORIZONTAL_PLAN_V |
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)