[Home] [Help]
View: MRP_BIS_ORDERS_V
View Text
SELECT MGR.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, MGR.COMPILE_DESIGNATOR
, NVL(TRUNC(MGR.ASSEMBLY_DEMAND_COMP_DATE)
, TRUNC(USING_ASSEMBLY_DEMAND_DATE))
, 0
, COUNT(*)
FROM MRP_GROSS_REQUIREMENTS MGR
, ORG_ORGANIZATION_DEFINITIONS ORG
, MRP_PLANS PLANS
WHERE ORG.ORGANIZATION_ID = MGR.ORGANIZATION_ID AND PLANS.COMPILE_DESIGNATOR = MGR.COMPILE_DESIGNATOR AND PLANS.PLAN_COMPLETION_DATE IS NOT NULL AND MGR.ORIGINATION_TYPE IN (6
, 7) GROUP BY MGR.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, MGR.COMPILE_DESIGNATOR
, NVL(TRUNC(MGR.ASSEMBLY_DEMAND_COMP_DATE)
, TRUNC(USING_ASSEMBLY_DEMAND_DATE))
Columns
Name |
ORGANIZATION_ID |
ORGANIZATION_CODE |
COMPILE_DESIGNATOR |
DUE_DATE |
LATE_ORDERS |
TOTAL_ORDERS |