AUC_AWD_REQ_VW

(SQL View)
 Index Back

SELECT c.business_unit , c.auc_id , c.auc_round , c.auc_version , c.line_nbr , a.business_unit , a.req_id , a.line_nbr , a.source_status , b.distrib_ln_status , SUM(b.qty_open) FROM ps_req_line a , PS_REQ_LN_DISTRIB b , ps_auc_copy_xref c WHERE a.business_unit = b.business_unit AND a.req_id = b.req_id AND a.line_nbr = b.line_nbr AND b.business_unit = c.auc_source_busetid AND b.req_id = c.auc_source_id AND b.line_nbr = c.auc_source_line AND b.sched_nbr = c.auc_source_sched AND b.distrib_line_num = c.auc_source_distrib GROUP BY a.business_unit , a.req_id , a.line_nbr , a.source_status , c.business_unit , c.auc_id , c.auc_round , c.auc_version , c.line_nbr, b.distrib_ln_status

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

6 AUC_SOURCE_BUSETID Character(5) VARCHAR2(5) NOT NULL Business Unit Setid
7 AUC_SOURCE_ID Character(25) VARCHAR2(25) NOT NULL Source ID
8 AUC_SOURCE_LINE Number(5,0) INTEGER NOT NULL Source Line Number
9 SOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL AutoSource Status
A=Available
C=Sourcing Complete
E=Non-Price Error
I=Sourcing In Process
N=Non-Price Error
P=Pricing Error

Default Value: N

10 DISTRIB_LN_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Line Status
C=Closed
M=Mass Liquidated
O=Open
P=Unavailable for Sourcing
X=Canceled
11 QTY_OPEN Number(16,4) DECIMAL(15,4) NOT NULL Open Quantity