[Home] [Help]
View: MRP_I2_PLANNED_ORDERS_V
Product: | MRP - Master Scheduling/MRP |
Description: | A Rhythm view supporting information regarding firm planned orders |
Implementation/DBA Data: |
Not implemented in this database
|
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
Name |
JOB_NUMBER |
PART_NUMBER |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
ROUTING |
START_DATE |
COMPLETION_DATE |
RELEASED |
QUANTITY |
COMPLETED_QUANTITY |
SCRAPPED_QUANTITY |
PRIORITY |