View: MRP_I2_SALES_ORDER_V

View Text

SELECT PM.PART_NUMBER
, PM.INVENTORY_ITEM_ID
, PM.ORGANIZATION_ID
, SUBSTR(MRP_I2_ERP.GENERATE_SALES_ORDER( MSOV.SALES_ORDER_NUMBER
, MSOV.LINE_NUMBER
, MSOV.USER_DELIVERY
, PM.ORGANIZATION_ID
, MSOV.RESERVATION_TYPE
, PM.INVENTORY_ITEM_ID)
, 1
, 100)
, GREATEST(DECODE(MSOV.REQUIREMENT_DATE
, TRUNC(MSOV.REQUIREMENT_DATE)
, MSOV.REQUIREMENT_DATE + 86399/86400
, MSOV.REQUIREMENT_DATE)
, TO_DATE('01-01-1970'
, 'DD-MM-YYYY'))
, MSOV.PRIMARY_UOM_QUANTITY - MSOV.COMPLETED_QUANTITY
, MSOV.CUSTOMER_NAME
, MRP_I2.CALCULATE_PRIORITY(DECODE(MSOV.RESERVATION_TYPE
, 1
, 'SALES_ORDER'
, 'RESERVED_SO')
, MSOV.REQUIREMENT_DATE
, PM.ORGANIZATION_ID)
, MSOV.RESERVATION_TYPE
, LU.MEANING
, SUBSTR(MRP_I2_ERP.GET_PARAMETER('SO_SHIP_EARLY'
, PM.ORGANIZATION_ID)
, 1
, 240)
, SUBSTR(MRP_I2_ERP.GET_PARAMETER('SO_SHIP_PARTIAL'
, PM.ORGANIZATION_ID)
, 1
, 240)
, DECODE(MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_ENABLE_ABP'
, MSOV.ORGANIZATION_ID)
, 'Y'
, DECODE(TO_NUMBER(MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_OE_AC_ATTR_NUM'
, MSOV.ORGANIZATION_ID))
, 1
, MSOV.SO_LINE_ATTRIBUTE1
, 2
, MSOV.SO_LINE_ATTRIBUTE2
, 3
, MSOV.SO_LINE_ATTRIBUTE3
, 4
, MSOV.SO_LINE_ATTRIBUTE4
, 5
, MSOV.SO_LINE_ATTRIBUTE5
, 6
, MSOV.SO_LINE_ATTRIBUTE6
, 7
, MSOV.SO_LINE_ATTRIBUTE7
, 8
, MSOV.SO_LINE_ATTRIBUTE8
, 9
, MSOV.SO_LINE_ATTRIBUTE9
, 10
, MSOV.SO_LINE_ATTRIBUTE10
, 11
, MSOV.SO_LINE_ATTRIBUTE11
, 12
, MSOV.SO_LINE_ATTRIBUTE12
, 13
, MSOV.SO_LINE_ATTRIBUTE13
, 14
, MSOV.SO_LINE_ATTRIBUTE14
, 15
, MSOV.SO_LINE_ATTRIBUTE15)
, 'N'
, NULL)
FROM MFG_LOOKUPS LU
, MRP_RHX_SALES_ORDERS_V MSOV
, MRP_I2_PART_MASTER_V PM WHERE LU.LOOKUP_TYPE='MTL_RESERVATION'
AND LU.LOOKUP_CODE=MSOV.RESERVATION_TYPE
AND MSOV.INVENTORY_ITEM_ID = PM.INVENTORY_ITEM_ID AND MSOV.ORGANIZATION_ID = PM.ORGANIZATION_ID AND MSOV.PRIMARY_UOM_QUANTITY - MSOV.COMPLETED_QUANTITY > 0 AND MRP_I2_ERP.GET_PARAMETER('SCHEDULING_ONLY'
, PM.ORGANIZATION_ID)<> 'Y'

Columns