BUSINESS_UNIT_PORTV_IDEXPR_INV_RTV_VW(SQL View) |
Index Back |
|---|---|
RTV ID Prompt View |
| SELECT DISTINCT A.BUSINESS_UNIT , A.RTV_ID FROM %Table(RTV_HDR) A , %Table(RTV_LN) B , %Table(RTV_LN_DISTRIB) C WHERE %Join(COMMON_KEYS, RTV_HDR A, RTV_LN B) AND %Join(COMMON_KEYS, RTV_LN B, RTV_LN_DISTRIB C) AND A.RTV_STATUS = 'O' AND B.DISPOSITION_TYPE = '0' AND B.INV_FLG = 'Y' AND ( B.RTV_LN_STATUS = 'O' OR B.RTV_LN_STATUS = 'S' ) AND ( C.RTV_DIST_STATUS = 'O' OR C.RTV_DIST_STATUS = 'S' ) AND C.QTY_AM_RETRN_SUOM > C.QTY_AM_SHIP_SUOM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 2 | RTV_ID |
Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |