View: MRP_I2_PENDING_BACKFLUSH_V

View Text

SELECT PMV.PART_NUMBER
, PMV.INVENTORY_ITEM_ID
, PMV.ORGANIZATION_ID
, SUBSTR( MRP_I2_ERP.GET_PARAMETER('MRP_I2_L_DEMAND_PREFIX'
, PMV.ORGANIZATION_ID
, 2) || MRP_I2_ERP.GET_PARAMETER( 'MRP_I2_P_DELIMITER'
, PMV.ORGANIZATION_ID) || WE.WIP_ENTITY_NAME || MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_DELIMITER'
, PMV.ORGANIZATION_ID) || PMV.PART_NUMBER
, 1
, 240)
, MRP_I2_ERP.GET_START_DATE(PMV.ORGANIZATION_ID)
, GREATEST(MRP_I2_ERP.CALCULATE_NET_ISSUED(WDJ.WIP_ENTITY_ID
, SUM(WDJ. QUANTITY_COMPLETED)
, SUM(REQS.QUANTITY_ISSUED)
, SUM(REQS.QUANTITY_PER_ASSEMBLY)
, PMV.ORGANIZATION_ID) * -1
, 0)
, MRP_I2.CALCULATE_PRIORITY('BACKFLUSH'
, MRP_I2_ERP.GET_START_DATE(PMV.ORGANIZATION_ID)
, PMV.ORGANIZATION_ID)
, DECODE(MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_ENABLE_ABP'
, REQS.ORGANIZATION_ID)
, 'Y'
, DECODE(TO_NUMBER(MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_BOM_AC_ATTR_NUM'
, REQS.ORGANIZATION_ID))
, 1
, REQS.ATTRIBUTE1
, 2
, REQS.ATTRIBUTE2
, 3
, REQS.ATTRIBUTE3
, 4
, REQS.ATTRIBUTE4
, 5
, REQS.ATTRIBUTE5
, 6
, REQS.ATTRIBUTE6
, 7
, REQS.ATTRIBUTE7
, 8
, REQS.ATTRIBUTE8
, 9
, REQS.ATTRIBUTE9
, 10
, REQS.ATTRIBUTE10
, 11
, REQS.ATTRIBUTE11
, 12
, REQS.ATTRIBUTE12
, 13
, REQS.ATTRIBUTE13
, 14
, REQS.ATTRIBUTE14
, 15
, REQS.ATTRIBUTE15)
, 'N'
, NULL)
FROM WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, WIP_REQUIREMENT_OPERATIONS REQS
, MRP_I2_PART_MASTER_V PMV
WHERE DECODE(WDJ.STATUS_TYPE
, 3
, 'Y'
, 'N') = 'Y'
AND WDJ.WIP_ENTITY_ID = REQS.WIP_ENTITY_ID
AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND REQS.QUANTITY_ISSUED <= REQS.REQUIRED_QUANTITY
AND REQS.REQUIRED_QUANTITY > 0
AND REQS.WIP_SUPPLY_TYPE NOT IN (5
, 6)
AND REQS.MRP_NET_FLAG = 1
AND REQS.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND PMV.INVENTORY_ITEM_ID = REQS.INVENTORY_ITEM_ID
AND PMV.ORGANIZATION_ID = REQS.ORGANIZATION_ID
AND MRP_I2_ERP.GET_PARAMETER('SCHEDULING_ONLY'
, PMV.ORGANIZATION_ID) <> 'Y' GROUP BY PMV.PART_NUMBER
, PMV.INVENTORY_ITEM_ID
, PMV.ORGANIZATION_ID
, WE.WIP_ENTITY_NAME
, WDJ.WIP_ENTITY_ID
, DECODE(MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_ENABLE_ABP'
, REQS.ORGANIZATION_ID)
, 'Y'
, DECODE(TO_NUMBER(MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_BOM_AC_ATTR_NUM'
, REQS.ORGANIZATION_ID))
, 1
, REQS.ATTRIBUTE1
, 2
, REQS.ATTRIBUTE2
, 3
, REQS.ATTRIBUTE3
, 4
, REQS.ATTRIBUTE4
, 5
, REQS.ATTRIBUTE5
, 6
, REQS.ATTRIBUTE6
, 7
, REQS.ATTRIBUTE7
, 8
, REQS.ATTRIBUTE8
, 9
, REQS.ATTRIBUTE9
, 10
, REQS.ATTRIBUTE10
, 11
, REQS.ATTRIBUTE11
, 12
, REQS.ATTRIBUTE12
, 13
, REQS.ATTRIBUTE13
, 14
, REQS.ATTRIBUTE14
, 15
, REQS.ATTRIBUTE15)
, 'N'
, NULL)

Columns