BUSINESS_UNITORDER_NOORDER_INT_LINE_NOSCHED_LINE_NBRDISTRIB_LINE_NUMIN_REQ_DLINE_VW(SQL View) |
Index Back |
|---|---|
IN Pegging Requisition Search06/29/04 EGS: Created |
| SELECT d.business_unit , d.req_id , d.line_nbr , d.sched_nbr , d.distrib_line_num , s.due_dt , d.qty_open_std FROM ps_req_ln_distrib d , ps_req_line_ship s , ps_req_line l , PS_REQ_HDR h WHERE h.hold_status = 'N' AND l.business_unit = h.business_unit AND l.req_id = h.req_id AND l.curr_status IN ('A', 'O') AND s.business_unit = l.business_unit AND s.req_id = l.req_id AND s.line_nbr = l.line_nbr AND d.qty_open_std > 0 AND d.business_unit = s.business_unit AND d.req_id = s.req_id AND d.line_nbr = s.line_nbr AND d.sched_nbr = s.sched_nbr AND d.business_unit_in <> ' ' AND d.distrib_ln_status = 'O' AND d.profile_id = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 3 | ORDER_INT_LINE_NO |
Number(5,0) | INTEGER NOT NULL | Order Line |
| 4 | SCHED_LINE_NBR |
Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 5 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 6 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 7 | QTY_REQUESTED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Requested |