PL_PO_MSG_VW (SQL View)	Index Back
PO Exception Messages 03/16/98 SCC CN#PL750-JOLVERA-0F6D8: Change prompt table for BU from pl_valid_bu_vw to sp_buin_nonvw

PL_PO_MSG_VW

(SQL View)

PO Exception Messages

03/16/98 SCC CN#PL750-JOLVERA-0F6D8: Change prompt table for BU from pl_valid_bu_vw to sp_buin_nonvw

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.PLANNER_CD , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.RELEASE_DATE , A.RELEASE_TIME , A.PLAN_DUE_DT , A.PLAN_DUE_TIME , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.CONFIG_CODE , A.BUYER_ID , A.BUSINESS_UNIT_IN , A.PROBINST , A.PL_SEQ_NBR , A.PLANNING_TIMESTAMP , B.MESSAGE_TEXT FROM PS_PL_PO_MESSAGE A , PSMSGCATDEFN B WHERE A.MESSAGE_SET_NBR = B.MESSAGE_SET_NBR AND A.MESSAGE_NBR = B.MESSAGE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

3 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code

4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

7 RELEASE_DATE Date(10) DATE Release Date

8 RELEASE_TIME Time(15) TIMESTAMP Release Time

9 PLAN_DUE_DT Date(10) DATE Planned Due Date

10 PLAN_DUE_TIME Time(15) TIMESTAMP Planned Due Time

11 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

12 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

13 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

14 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

15 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

16 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

17 PL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL 01/09/02 EGS (CN#PL900-1): Added

18 PLANNING_TIMESTAMP DateTime(26) TIMESTAMP Planning Date and Time

19 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	PLANNER_CD	Character(12)	VARCHAR2(12) NOT NULL	Planner Code
4	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
5	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
6	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
7	RELEASE_DATE	Date(10)	DATE	Release Date
8	RELEASE_TIME	Time(15)	TIMESTAMP	Release Time
9	PLAN_DUE_DT	Date(10)	DATE	Planned Due Date
10	PLAN_DUE_TIME	Time(15)	TIMESTAMP	Planned Due Time
11	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
12	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
13	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
14	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
15	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
16	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
17	PL_SEQ_NBR	Number(9,0)	DECIMAL(9) NOT NULL	01/09/02 EGS (CN#PL900-1): Added
18	PLANNING_TIMESTAMP	DateTime(26)	TIMESTAMP	Planning Date and Time
19	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.