Doc Reference : 2246358.1 List Of Order Types For Demands And Supplies In ASCP Workbench

1. For MSC_DEMANDS - ORIGINATION_TYPE column:

SELECT meaning, lookup_code
FROM mfg_lookups
WHERE lookup_type = 'MSC_DEMAND_ORIGINATION'
ORDER BY lookup_code;

image

2. For MSC_SUPPLIES - ORDER_TYPE column:

SELECT meaning, lookup_code
FROM mfg_lookups
WHERE lookup_type = 'MRP_ORDER_TYPE'
ORDER BY lookup_code;

image

文章標籤
ORIGINATION_TYPE ORDER_TYPE ASC Oracle

Somebaby 發表在 痞客邦 留言(0) 人氣()