IN_PROUT_TYP_VW(SQL View) |
Index Back |
---|---|
IN Peggable Supply View07/26/04 EGS: Created |
SELECT DISTINCT A.BUSINESS_UNIT , A.PRODUCTION_ID , A.MG_OUTPUT_TYPE , C.XLATSHORTNAME FROM PS_SF_OUTPUT_LIST A , PS_SF_PRDNID_HEADR B , PSXLATITEM C WHERE B.PROD_STATUS < '40' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND A.MG_OUTPUT_TYPE <> 'WB' AND A.CONFIG_CODE = ' ' AND B.MA_PRDN_ID_FLG = 'Y' AND C.FIELDNAME = 'MG_OUTPUT_TYPE' AND C.EFF_STATUS = 'A' AND C.FIELDVALUE = A.MG_OUTPUT_TYPE AND %EffdtCheck(PSXLATITEM XX, C, %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
2 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
3 | MG_OUTPUT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle).
11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary CS=Co-Product RB=Recycle TD=Teardown WB=Waste |
4 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |