RQSTR_REQ_RC_VW(SQL View) |
Index Back |
|---|---|
Requester Req Receipt ViewRequestor Requisitions Receipt View |
| SELECT rl.business_unit , rl.receiver_id , rl.recv_ln_nbr , rl.qty_sh_recvd_vuom , rl.qty_sh_accpt_vuom , rl.qty_sh_rejct_vuom , rl.receipt_um , rl.business_unit_po , rl.po_id , rl.line_nbr , pd.business_unit_req , pd.req_id , pd.req_line_nbr FROM ps_po_line_distrib pd , PS_RECV_LN_SHIP rl WHERE pd.po_id = rl.po_id AND pd.line_nbr = rl.line_nbr AND pd.sched_nbr = rl.sched_nbr AND pd.business_unit = rl.business_unit_po |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 4 | QTY_LN_RECVD | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Received in Receipt UOM |
| 5 | QTY_LN_ACCPT | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Accepted in Receipt UOM |
| 6 | QTY_LN_REJCT | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Rejected in Receipt UOM |
| 7 | RECEIVE_UOM | Character(3) | VARCHAR2(3) NOT NULL | Receipt Unit of Measure |
| 8 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 9 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 10 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 11 | BUSINESS_UNIT_REQ | Character(5) | VARCHAR2(5) NOT NULL | Requesting Business Unit |
| 12 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 13 | REQ_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Line Number |