View: MRP_I2_PLANNED_ORDERS_V

View Text

SELECT SUBSTR( MRP_I2_ERP.GET_PARAMETER('MRP_I2_L_SCHED_RECEIPT_PREFIX'
, PM.ORGANIZATION_ID
, 5) || FPO.TRANSACTION_ID
, 1
, 240)
, PM.PART_NUMBER
, PM.INVENTORY_ITEM_ID
, PM.ORGANIZATION_ID
, SUBSTR( MRP_I2_ERP.GENERATE_ROUTING( PM.PART_NUMBER
, FPO.ALTERNATE_BOM_DESIGNATOR
, FPO.ALTERNATE_ROUTING_DESIGNATOR
, NULL
, PM.ORGANIZATION_ID)
, 1
, 240) ROUTING
, GREATEST(FPO.NEW_WIP_START_DATE
, TO_DATE('01-01-1970'
, 'DD-MM-YYYY'))
, GREATEST(FPO.FIRM_DATE
, TO_DATE('01-01-1970'
, 'DD-MM-YYYY'))
, 'N'
, FPO.FIRM_QUANTITY
, 0
, 0
, MRP_I2.CALCULATE_PRIORITY('RESERVED_SO'
, FPO.FIRM_DATE
, PM.ORGANIZATION_ID)
FROM MRP_RHX_FIRM_PLANNED_ORDERS_V FPO
, MRP_I2_PART_MASTER_V PM
WHERE MRP_I2_ERP.GET_PARAMETER('SCHEDULING_ONLY'
, PM.ORGANIZATION_ID) = 'Y'
AND PM.INVENTORY_ITEM_ID = FPO.INVENTORY_ITEM_ID
AND PM.ORGANIZATION_ID = FPO.ORGANIZATION_ID
AND MRP_I2_ERP.GET_PARAMETER('PLAN_NAME'
, PM.ORGANIZATION_ID) = FPO.COMPILE_DESIGNATOR
AND FPO.FIRM_QUANTITY > 0

Columns