OMEC_ALLPROG_VW

(SQL View)
Index Back

OM EC Avail Transactions VW

Prompt for EIP program on order change completion panel

SELECT DISTINCT S.EIP_PROGRAM , S.DESCR FROM PS_EO_EIP_CTL_SET S , PS_ORD_HEADER_EC OH WHERE OH.EIP_PROGRAM = S.EIP_PROGRAM

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description