Value Chain Planning - EBS (MOSC)

MOSC Banner

ASCP Table MSC_FULL_PEGGING values of field SUPPLY_TYPE

edited Dec 3, 2016 1:22AM in Value Chain Planning - EBS (MOSC) 2 commentsAnswered ✓

What lookup is being used to interpret the value in the field MSC_FULL_PEGGING.SUPPLY_TYPE?

I see values of 1,2,3,5,7,8,10,11,13, 18 in my data.

I found some sql that used a decode statement that used:

      1, 'Purchase Order',      

      2, 'Purchase Requisition',

      3, 'Work Order',

      11, 'Intransit Shipment',

      12, 'Intransit receipt',

Which I thought was lookup MRP_ORDER_TYPE because I see which seemed to make sense:

5, 'Planned Order',

7, 'Non Standard Job',               (Please define this)

8, 'PO In Receiving',

11, 'Intransit Shipment',

13, 'Suggested Repetitive Schedule',

18, 'On Hand

If this field is interpreted using an MRP_ORDER_TYPE lookup then what is 10?  If not which lookup table can I use to get the 'English' version of the Supply_Type? What is a 'Non Standard Job'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center