PRODPGRPLNK_SRC

(SQL View)
 Index Back

Product-Prod Group Link Stagin

Staging table for messaging.

SELECT DISTINCT STG.EIP_PROGRAM ,STG.EIP_CTL_ID ,ERR.FIELDNAME ,STG.SETID ,STG.PRODUCT_ID ,STG.PROD_GRP_TYPE ,STG.PRODUCT_GROUP FROM PS_EO_EIP_CTL EO , PS_PROD_LOAD_ERR ERR , PS_PROD_PGRPLNK_MD STG WHERE EO.EIP_DTA_STATUS = '1' AND EO.EIP_PROGRAM = ERR.EIP_PROGRAM AND EO.EIP_CTL_ID = ERR.EIP_CTL_ID AND ERR.EIP_PROGRAM = STG.EIP_PROGRAM AND ERR.EIP_CTL_ID = STG.EIP_CTL_ID AND ERR.RECNAME = 'PROD_PGRPLNK_MD' AND STG.SETID = ERR.KEY_CHAR_25_01 AND STG.PRODUCT_ID = ERR.KEY_CHAR_25_02 AND STG.PROD_GRP_TYPE = ERR.KEY_CHAR_25_03 AND STG.PRODUCT_GROUP = ERR.KEY_CHAR_25_04

# 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

Default Value: OM_EIP_PRD_VW.EIP_PROGRAM

Prompt Table: OM_EIP_PRD_VW

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

Prompt Table: OM_EIP_PRD2_VW

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_ITEM

6 PROD_GRP_TYPE Character(4) VARCHAR2(4) NOT NULL Product Group Type
ACCT=Accounting
BO=Backorder/Reservations
CA=Contract
CLMB=Claimback Contract
CTLG=Product Catalogs
FCST=Forecast
FRT=Freight
PRC=Pricing
RPT=Reporting
SCON=Buying Agreement
SSRC=Alternate Sources of Supply
TAX=Tax
TRPT=Transportations
VAT=VAT
WEB=WEB Order Entry
7 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group

Prompt Table: %EDITTABLE