BUSINESS_UNIT_RMARMA_IDRMA_LINE_NBRINV_RECVRMK2_VW(SQL View) |
Index Back |
|---|---|
RMA partial recvd for kit |
| SELECT r.business_unit , r.rma_id , r.rma_line_nbr , p.descr , 'PRODUCT KIT' , r.product_id , p.product_kit_flag , 1 , r.qty_returned , r.return_fr_cust_id , r.return_to_ibu , r.unit_of_measure , r.return_from_bu ,r.distrib_type FROM ps_prod_item p , ps_rma_line r , ps_set_cntrl_rec sc WHERE r.rma_line_status = 'O' AND sc.recname = 'PROD_ITEM' AND sc.setcntrlvalue = r.business_unit AND p.setid = sc.setid AND p.product_id = r.product_id AND p.product_kit_flag = 'Y' AND EXISTS( SELECT 'X' FROM PS_INV_RECV_LN RCV WHERE RCV.SOURCE_BUS_UNIT = R.BUSINESS_UNIT AND RCV.RMA_ID = R.RMA_ID AND RCV.RMA_LINE_NBR = R.RMA_LINE_NBR) GROUP BY r.business_unit, r.rma_id, r.rma_line_nbr, p.descr, p.inv_item_id, r.product_id, p.product_kit_flag, r.return_fr_cust_id, r.return_to_ibu, r.unit_of_measure, r.qty_returned, return_from_bu,r.distrib_type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_RMA |
Character(5) | VARCHAR2(5) NOT NULL | RMA Business Unit |
| 2 | RMA_ID |
Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
| 3 | RMA_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | RMA Line Number |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 7 | PRODUCT_KIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Product Kit |
| 8 | QTY_RECEIPT | Number(16,4) | DECIMAL(15,4) NOT NULL | Receipt Quantity |
| 9 | QTY_RETURNED | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Returned |
| 10 | RETURN_FR_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Return From Cust ID |
| 11 | RETURN_TO_IBU | Character(5) | VARCHAR2(5) NOT NULL | Return To IBU |
| 12 | UOM_QTY_RETURN | Character(3) | VARCHAR2(3) NOT NULL | UOM of Qty Returned |
| 13 | RETURN_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL | Return From Location |
| 14 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Distrib. Type |