OM_PROD_EIP2_VW (SQL View)	Index Back
Product Load View This is used for the run control page for the Load Product from Stage. Only the EIP_DTA_STATUS with '0' New or '4' Reprocess can be selected. Date Initials Issue Description 032601 dms SP2 (DI-EDWONG-14) Changed SQL

OM_PROD_EIP2_VW

(SQL View)

Product Load View

This is used for the run control page for the Load Product from Stage. Only the EIP_DTA_STATUS with '0' New or '4' Reprocess can be selected. Date Initials Issue Description 032601 dms SP2 (DI-EDWONG-14) Changed SQL

SELECT EIP_PROGRAM , EIP_CTL_ID FROM PS_EO_EIP_CTL WHERE EIP_DTA_STATUS NOT IN ('2','6')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync
701=BOM Sync
801=Item Revision
901=Item Bus Unit Sync
902=Item Sync

2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EIP_PROGRAM	Character(10)	VARCHAR2(10) NOT NULL	Enterprise Components EIP (enterprise integration point) program field 601=Consumer Sync 701=BOM Sync 801=Item Revision 901=Item Bus Unit Sync 902=Item Sync
2	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field