DP_PUBRLIPITMVW

(SQL View)
 Index Back

DP_PUBRLIPITMVW

DP_PUBRLIPITMVW

SELECT A.OPRID , B.DP_PUBLISHNAME , B.DP_PUBLISH_DATE , C.DP_POLICYSET , B.DP_ITEMCODE , B.DP_LOCATION , B.DP_POLICYCONTROL , B.DP_INVENTORYUOM , B.DP_PUBLISHUOM , B.DP_CONVFACTOR , B.DP_STDUOMCONVFACT , B.DP_LEADTIME , B.DP_LEADTIMEUOM , B.DP_WEIGHT , B.DP_WEIGHTUOM , B.DP_VOLUME , B.DP_VOLUMEUOM , B.DP_INHERITCONTROLS , B.DP_RUNOUTDATE , B.DP_SAFETYSTOCK , B.DP_REORDERPOINT , B.DP_ORDERQUANTITY , B.DP_MINIMUM , B.DP_MAXIMUM , B.DP_AVGINVENTORY , B.DP_SERVICEFILL , B.DP_TURNRATE , B.DP_OQMETHOD , B.DP_OQARGUMENT , B.DP_OQLIMITMETHOD , B.DP_OQLOWERLIMIT , B.DP_OQUPPERLIMIT , B.DP_SSMETHOD , B.DP_SSARGUMENT , B.DP_SSLIMITMETHOD , B.DP_SSLOWERLIMIT , B.DP_SSUPPERLIMIT , B.DP_ROPMETHOD , B.DP_ROPARGUMENT , B.DP_MINMETHOD , B.DP_MINARGUMENT , B.DP_MAXMETHOD , B.DP_MAXARGUMENT , B.DP_ORDERCOST , B.DP_CARRYINGCOST , B.DP_STANDARDPRICE , B.DP_STANDARDCOST , B.DP_ANNUALCOST , B.DP_ANNUALINVEST , B.DP_ORDERMULT , B.DP_STATICCALCFLG , B.DP_STATICCALCARG , B.DP_MAXLTUSAGEMETH , B.DP_HISTMAXLTUSAGE , B.DP_FCPERIODS , B.DP_FCSTDDEV , B.DP_SIMFCSTDDEV , B.DP_EFFDEMANDPDS , B.DP_EXPLODEDITEM , B.DP_ORDERCOUNT , B.UTILIZ_CD , B.UTILIZ_GROUP , B.CONSIGNED_FLAG , B.COST_ELEMENT , B.COST_GROUP_CD , B.DESCR , B.EXCESS_INVENTORY , B.INV_STOCK_TYPE , B.ITM_STATUS_FUTURE , B.NO_REPLENISH_FLG , B.PLANNER_CD , B.RELATED_ITEM_ID , B.SOURCE_CODE , B.USE_UP_QOH , B.QTY_AVAILABLE , B.HISTORICAL_LEAD , B.SHELF_LIFE , B.INV_ITEM_COLOR , B.INV_ITEM_GROUP , B.INV_ITEM_TYPE , B.INV_PROD_FAM_CD , B.ITEM_FIELD_C1_A , B.ITEM_FIELD_C1_B , B.ITEM_FIELD_C1_C , B.ITEM_FIELD_C1_D , B.ITEM_FIELD_C10_A , B.ITEM_FIELD_C10_B , B.ITEM_FIELD_C10_C , B.ITEM_FIELD_C10_D , B.ITEM_FIELD_C2 , B.ITEM_FIELD_C30_A , B.ITEM_FIELD_C30_B , B.ITEM_FIELD_C30_C , B.ITEM_FIELD_C30_D , B.ITEM_FIELD_C4 , B.ITEM_FIELD_C6 , B.ITEM_FIELD_C8 , B.REPLENISH_CLASS , B.DP_UD01 , B.DP_UD02 , B.DP_UD03 , B.DP_UD04 , B.DP_UD05 , B.DP_UD06 , B.DP_UD07 , B.DP_UD08 , B.DP_UD09 , B.DP_UD10 , B.DP_UD11 , B.DP_UD12 , B.DP_UD13 , B.DP_UD14 , B.DP_UD15 , B.DP_UD16 , B.DP_UD17 , B.DP_UD18 , B.DP_UD19 , B.DP_UD20 , B.DP_UD21 , B.DP_UD22 , B.DP_UD23 , B.DP_UD24 , B.DP_UD25 , B.DP_UD26 , B.DP_UD27 , B.DP_UD28 , B.DP_UD29 , B.DP_UD30 , B.DP_UD31 , B.DP_UD32 , B.DP_UD33 , B.DP_UD34 , B.DP_UD35 , B.DP_UD36 , B.DP_UD37 , B.DP_UD38 , B.DP_UD39 , B.DP_UD40 , B.DP_UD41 , B.DP_UD42 , B.DP_UD43 , B.DP_UD44 , B.DP_UD45 , B.DP_UD46 , B.DP_UD47 , B.DP_UD48 , B.DP_UD49 , B.DP_UD50 FROM PS_DP_ROLIPITM4_VW A , PS_DP_PUB_IPMAST B , PS_DP_PUB_INVPOL C WHERE A.DP_POLICYSET = C.DP_POLICYSET AND A.DP_ITEMCODE = B.DP_ITEMCODE AND A.DP_LOCATION = B.DP_LOCATION AND B.DP_PUBLISHNAME = C.DP_PUBLISHNAME AND B.DP_PUBLISH_DATE = C.DP_PUBLISH_DATE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 DP_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL Publish Name
3 DP_PUBLISH_DATE Date(10) DATE NOT NULL DP_PUBLISH_DATE
4 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET

Prompt Table: DP_POLICYSETS

5 DP_ITEMCODE Character(18) VARCHAR2(18) NOT NULL DP_ITEMCODE
6 DP_LOCATION Character(5) VARCHAR2(5) NOT NULL DP_LOCATION
7 DP_POLICYCONTROL Character(20) VARCHAR2(20) NOT NULL DP_POLICYCONTROL

Prompt Table: DP_POLICYCTRLS

8 DP_INVENTORYUOM Character(3) VARCHAR2(3) NOT NULL DP_INVENTORYUOM

Prompt Table: UNITS_TBL

9 DP_PUBLISHUOM Character(3) VARCHAR2(3) NOT NULL DP_PUBLISHUOM
10 DP_CONVFACTOR Number(17,6) DECIMAL(16,6) NOT NULL DP_CONVFACTOR
11 DP_STDUOMCONVFACT Number(17,6) DECIMAL(16,6) NOT NULL DP_STDUOMCONVFACT
12 DP_LEADTIME Number(4,0) SMALLINT NOT NULL DP_LEADTIME
13 DP_LEADTIMEUOM Character(3) VARCHAR2(3) NOT NULL DP_LEADTIMEUOM

Default Value: DAY

Prompt Table: UNITS_TBL

14 DP_WEIGHT Number(13,2) DECIMAL(12,2) NOT NULL DP_WEIGHT
15 DP_WEIGHTUOM Character(3) VARCHAR2(3) NOT NULL DP_WEIGHTUOM
16 DP_VOLUME Number(13,2) DECIMAL(12,2) NOT NULL DP_VOLUME
17 DP_VOLUMEUOM Character(3) VARCHAR2(3) NOT NULL DP_VOLUMEUOM
18 DP_INHERITCONTROLS Character(1) VARCHAR2(1) NOT NULL DP_INHERITCONTROLS

Y/N Table Edit

Default Value: Y

19 DP_RUNOUTDATE Date(10) DATE DP_RUNOUTDATE
20 DP_SAFETYSTOCK Number(15,4) DECIMAL(14,4) NOT NULL DP_SAFETYSTOCK
21 DP_REORDERPOINT Number(15,4) DECIMAL(14,4) NOT NULL DP_REORDERPOINT
22 DP_ORDERQUANTITY Number(15,4) DECIMAL(14,4) NOT NULL DP_ORDERQUANTITY
23 DP_MINIMUM Number(15,4) DECIMAL(14,4) NOT NULL DP_MINIMUM
24 DP_MAXIMUM Number(15,4) DECIMAL(14,4) NOT NULL DP_MAXIMUM
25 DP_AVGINVENTORY Number(15,4) DECIMAL(14,4) NOT NULL DP_AVGINVENTORY
26 DP_SERVICEFILL Number(13,2) DECIMAL(12,2) NOT NULL DP_SERVICEFILL
27 DP_TURNRATE Number(13,2) DECIMAL(12,2) NOT NULL DP_TURNRATE
28 DP_OQMETHOD Character(4) VARCHAR2(4) NOT NULL DP_OQMETHOD
0=None
1=Days Supply
2=Fixed Quantity
3=Economic Order Quantity
4=Lot for Lot

Default Value: 0

29 DP_OQARGUMENT Number(13,2) DECIMAL(12,2) NOT NULL DP_OQARGUMENT
30 DP_OQLIMITMETHOD Character(4) VARCHAR2(4) NOT NULL DP_OQLIMITMETHOD
0=None
1=Days Supply
2=Fixed Quantity

Default Value: 0

31 DP_OQLOWERLIMIT Number(13,2) DECIMAL(12,2) NOT NULL DP_OQLOWERLIMIT
32 DP_OQUPPERLIMIT Number(13,2) DECIMAL(12,2) NOT NULL DP_OQUPPERLIMIT
33 DP_SSMETHOD Character(4) VARCHAR2(4) NOT NULL DP_SSMETHOD
0=None
1=Days Supply
2=Fixed Quantity
3=Percentage Demand Fill
4=% Cycles Without Shortage
5=Maximum Lead Time Usage

Default Value: 0

34 DP_SSARGUMENT Number(13,2) DECIMAL(12,2) NOT NULL DP_SSARGUMENT
35 DP_SSLIMITMETHOD Character(4) VARCHAR2(4) NOT NULL DP_SSLIMITMETHOD
0=None
1=Days Supply
2=Fixed Quantity

Default Value: 0

36 DP_SSLOWERLIMIT Number(13,2) DECIMAL(12,2) NOT NULL DP_SSLOWERLIMIT
37 DP_SSUPPERLIMIT Number(13,2) DECIMAL(12,2) NOT NULL DP_SSUPPERLIMIT
38 DP_ROPMETHOD Character(4) VARCHAR2(4) NOT NULL DP_ROPMETHOD
0=None
1=Days Supply
2=Fixed Quantity
3=Lead Time Demand
4=Lead Time + Safety Stock

Default Value: 0

39 DP_ROPARGUMENT Number(13,2) DECIMAL(12,2) NOT NULL DP_ROPARGUMENT
40 DP_MINMETHOD Character(4) VARCHAR2(4) NOT NULL 4 & 5 Translate values not used as they were not used in old system
0=None
1=Days Supply
2=Fixed Quantity
3=Safety Stock

Default Value: 0

41 DP_MINARGUMENT Number(13,2) DECIMAL(12,2) NOT NULL DP_MINARGUMENT
42 DP_MAXMETHOD Character(4) VARCHAR2(4) NOT NULL DP_MAXMETHOD
0=None
1=Days Supply
2=Fixed Quantity
3=Safety Stock + Order Quantity

Default Value: 0

43 DP_MAXARGUMENT Number(13,2) DECIMAL(12,2) NOT NULL DP_MAXARGUMENT
44 DP_ORDERCOST Number(15,4) DECIMAL(14,4) NOT NULL DP_ORDERCOST
45 DP_CARRYINGCOST Number(15,4) DECIMAL(14,4) NOT NULL DP_CARRYINGCOST
46 DP_STANDARDPRICE Number(15,4) DECIMAL(14,4) NOT NULL DP_STANDARDPRICE
47 DP_STANDARDCOST Number(15,4) DECIMAL(14,4) NOT NULL DP_STANDARDCOST
48 DP_ANNUALCOST Number(15,4) DECIMAL(14,4) NOT NULL DP_ANNUALCOST
49 DP_ANNUALINVEST Number(15,4) DECIMAL(14,4) NOT NULL DP_ANNUALINVEST
50 DP_ORDERMULT Number(15,4) DECIMAL(14,4) NOT NULL DP_ORDERMULT
51 DP_STATICCALCFLG Character(4) VARCHAR2(4) NOT NULL DP_STATICCALCFLG
0=Period Number
1=Periods to Average

Default Value: 1

52 DP_STATICCALCARG Number(2,0) SMALLINT NOT NULL DP_STATICCALCARG
53 DP_MAXLTUSAGEMETH Character(4) VARCHAR2(4) NOT NULL Max LT Usage Method
0=Static
1=Lead Time Daily Usage
2=Lead Time Period Usage
3=Maximum Possible Usage

Default Value: 1

54 DP_HISTMAXLTUSAGE Number(13,2) DECIMAL(12,2) NOT NULL DP_HISTMAXLTUSAGE
55 DP_FCPERIODS Number(4,0) SMALLINT NOT NULL DP_FCPERIODS
56 DP_FCSTDDEV Number(22,2) DECIMAL(21,2) NOT NULL DP_FCSTDDEV
57 DP_SIMFCSTDDEV Number(13,2) DECIMAL(12,2) NOT NULL DP_SIMFCSTDDEV
58 DP_EFFDEMANDPDS Number(3,0) SMALLINT NOT NULL DP_EFFDEMANDPDS
59 DP_EXPLODEDITEM Character(1) VARCHAR2(1) NOT NULL DP_EXPLODEDITEM

Y/N Table Edit

60 DP_ORDERCOUNT Number(13,2) DECIMAL(12,2) NOT NULL DP_ORDERCOUNT
61 UTILIZ_CD Character(4) VARCHAR2(4) NOT NULL Utilization Type

Prompt Table: DP_UTILIZ_CD_VW

62 UTILIZ_GROUP Character(4) VARCHAR2(4) NOT NULL Utilization Group
CYCL=Cycle Count

Prompt Table: DP_UTILIZ_GP_VW

63 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag
64 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
65 COST_GROUP_CD Character(6) VARCHAR2(6) NOT NULL Standard Cost Group
66 DESCR Character(30) VARCHAR2(30) NOT NULL Description
67 EXCESS_INVENTORY Character(1) VARCHAR2(1) NOT NULL Excess Inventory
N=None
R=Repair
S=Score
68 INV_STOCK_TYPE Character(4) VARCHAR2(4) NOT NULL Stock Type
69 ITM_STATUS_FUTURE Character(1) VARCHAR2(1) NOT NULL Item Status Future
1=Active
2=Hold
3=Discontinue
4=Inactive
70 NO_REPLENISH_FLG Character(1) VARCHAR2(1) NOT NULL Not Included In Replenishment
71 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code
72 RELATED_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Related Item
73 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning
74 USE_UP_QOH Character(1) VARCHAR2(1) NOT NULL Use Up Quantity On Hand
75 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
76 HISTORICAL_LEAD Signed Number(16,2) DECIMAL(14,2) NOT NULL Historic Lead
77 SHELF_LIFE Number(4,0) SMALLINT NOT NULL Shelf Life (Days)
78 INV_ITEM_COLOR Character(10) VARCHAR2(10) NOT NULL Item Color
79 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
80 INV_ITEM_TYPE Character(5) VARCHAR2(5) NOT NULL Item Type
81 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family
82 ITEM_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
83 ITEM_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
84 ITEM_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
85 ITEM_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
86 ITEM_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
87 ITEM_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
88 ITEM_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
89 ITEM_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
90 ITEM_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User-defined item field - Character 2
91 ITEM_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
92 ITEM_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
93 ITEM_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
94 ITEM_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
95 ITEM_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4
96 ITEM_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User-defined item field - Character 6
97 ITEM_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8
98 REPLENISH_CLASS Character(4) VARCHAR2(4) NOT NULL Replenish Class
99 DP_UD01 Character(30) VARCHAR2(30) NOT NULL DP_UD01
100 DP_UD02 Character(30) VARCHAR2(30) NOT NULL DP_UD02
101 DP_UD03 Character(30) VARCHAR2(30) NOT NULL DP_UD03
102 DP_UD04 Character(30) VARCHAR2(30) NOT NULL DP_UD04
103 DP_UD05 Character(30) VARCHAR2(30) NOT NULL DP_UD05
104 DP_UD06 Character(30) VARCHAR2(30) NOT NULL DP_UD06
105 DP_UD07 Character(30) VARCHAR2(30) NOT NULL DP_UD07
106 DP_UD08 Character(30) VARCHAR2(30) NOT NULL DP_UD08
107 DP_UD09 Character(30) VARCHAR2(30) NOT NULL DP_UD09
108 DP_UD10 Character(30) VARCHAR2(30) NOT NULL DP_UD10
109 DP_UD11 Character(20) VARCHAR2(20) NOT NULL DP_UD11
110 DP_UD12 Character(20) VARCHAR2(20) NOT NULL DP_UD12
111 DP_UD13 Character(20) VARCHAR2(20) NOT NULL DP_UD13
112 DP_UD14 Character(20) VARCHAR2(20) NOT NULL DP_UD14
113 DP_UD15 Character(20) VARCHAR2(20) NOT NULL DP_UD15
114 DP_UD16 Character(20) VARCHAR2(20) NOT NULL DP_UD16
115 DP_UD17 Character(20) VARCHAR2(20) NOT NULL DP_UD17
116 DP_UD18 Character(20) VARCHAR2(20) NOT NULL DP_UD18
117 DP_UD19 Character(20) VARCHAR2(20) NOT NULL DP_UD19
118 DP_UD20 Character(20) VARCHAR2(20) NOT NULL DP_UD20
119 DP_UD21 Character(10) VARCHAR2(10) NOT NULL DP_UD21
120 DP_UD22 Character(10) VARCHAR2(10) NOT NULL DP_UD22
121 DP_UD23 Character(10) VARCHAR2(10) NOT NULL DP_UD23
122 DP_UD24 Character(10) VARCHAR2(10) NOT NULL DP_UD24
123 DP_UD25 Character(10) VARCHAR2(10) NOT NULL DP_UD25
124 DP_UD26 Character(10) VARCHAR2(10) NOT NULL DP_UD26
125 DP_UD27 Character(10) VARCHAR2(10) NOT NULL DP_UD27
126 DP_UD28 Character(10) VARCHAR2(10) NOT NULL DP_UD28
127 DP_UD29 Character(10) VARCHAR2(10) NOT NULL DP_UD29
128 DP_UD30 Character(10) VARCHAR2(10) NOT NULL DP_UD30
129 DP_UD31 Character(10) VARCHAR2(10) NOT NULL DP_UD31
130 DP_UD32 Character(10) VARCHAR2(10) NOT NULL DP_UD32
131 DP_UD33 Character(10) VARCHAR2(10) NOT NULL DP_UD33
132 DP_UD34 Character(10) VARCHAR2(10) NOT NULL DP_UD34
133 DP_UD35 Character(10) VARCHAR2(10) NOT NULL DP_UD35
134 DP_UD36 Character(10) VARCHAR2(10) NOT NULL DP_UD36
135 DP_UD37 Character(10) VARCHAR2(10) NOT NULL DP_UD37
136 DP_UD38 Character(10) VARCHAR2(10) NOT NULL DP_UD38
137 DP_UD39 Character(10) VARCHAR2(10) NOT NULL DP_UD39
138 DP_UD40 Character(10) VARCHAR2(10) NOT NULL DP_UD40
139 DP_UD41 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD41
140 DP_UD42 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD42
141 DP_UD43 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD43
142 DP_UD44 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD44
143 DP_UD45 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD45
144 DP_UD46 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD46
145 DP_UD47 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD47
146 DP_UD48 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD48
147 DP_UD49 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD49
148 DP_UD50 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD50