IN_ITMREV_EVW (SQL View)	Index Back
Item/Revision Record EIP View This view is Used by the Batch Publish section of the AE Program IN_ITMLOAD to publish the Item Changes/Adds to other Nodes.

IN_ITMREV_EVW

(SQL View)

Item/Revision Record EIP View

This view is Used by the Batch Publish section of the AE Program IN_ITMLOAD to publish the Item Changes/Adds to other Nodes.

SELECT B.SETID , A.INV_ITEM_ID , A.BUSINESS_UNIT , A.DATE_IN_EFFECT , %subrec(EN_REVISION_ESR, A) , D.AUDIT_ACTN , D.IN_PROCESS_FLG , E.PROCESS_INSTANCE FROM PS_EN_REVISION A , PS_SET_CNTRL_REC B , PS_EN_REVISION_EC D , PS_EO_EIP_CTL E , PS_MASTER_ITEM_TBL I WHERE B.RECNAME = 'MASTER_ITEM_TBL' AND B.SETCNTRLVALUE = A.BUSINESS_UNIT AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.INV_ITEM_ID = D.INV_ITEM_ID AND A.DATE_IN_EFFECT = D.DATE_IN_EFFECT AND D.EIP_CTL_ID = E.EIP_CTL_ID AND E.EIP_DTA_STATUS = '2' AND I.SETID = B.SETID AND I.INV_ITEM_ID = A.INV_ITEM_ID AND I.ITM_STATUS_CURRENT IN ('1','2','3','4')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: MG_ITEM_OWN_VW

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

4 DATE_IN_EFFECT Date(10) DATE NOT NULL 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label

5 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
Prompt Table: EN_REV_SCH_VW

6 DATE_OBSOLETE Date(10) DATE Obsolete Date

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

8 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text

9 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

10 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: MG_ITEM_OWN_VW
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW
4	DATE_IN_EFFECT	Date(10)	DATE NOT NULL	01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label
5	REVISION	Character(4)	VARCHAR2(4) NOT NULL	01/27/2000 RML Added "As of" label Prompt Table: EN_REV_SCH_VW
6	DATE_OBSOLETE	Date(10)	DATE	Obsolete Date
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
9	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
10	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
11	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance