IN_SDWC_HLD_VW(SQL View) |
Index Back |
---|---|
EOEN context recordDemand on hold |
SELECT DISTINCT %subrec(IN_DMD_NKEY_SBR, D) , 0 , A.HOLD_CD , A.PROD_COMPONENT_ID , %subrec(IN_SDWC_DMD_SBR, D) , %subrec(IN_SDWC_PRC_SBR, E) , %DatePart(D.SCHED_DTTM) , D.BUSINESS_UNIT %Concat '~' %Concat D.DEMAND_SOURCE %Concat '~' %Concat D.SOURCE_BUS_UNIT %Concat '~' %Concat D.ORDER_NO %Concat '~' %Concat %NumToChar(D.ORDER_INT_LINE_NO) %Concat '~' %Concat %NumToChar(D.SCHED_LINE_NBR) %Concat '~' %Concat %NumToChar(D.DEMAND_LINE_NO) FROM PS_ORD_HOLD A , PS_IN_DEMAND D , PS_IN_SDWC_SCH2_VW E WHERE D.DEMAND_SOURCE = 'OM' AND D.SOURCE_BUS_UNIT = A.BUSINESS_UNIT AND D.ORDER_NO = A.ORDER_NO AND D.IN_PROCESS_DATE IS NOT NULL AND D.IN_FULFILL_STATE BETWEEN '10' AND '50' AND %DatePart(D.SCHED_DTTM) < %CurrentDateIn AND (( A.ORDER_INT_LINE_NO = 0 AND A.SCHED_LINE_NBR = 0) OR ( A.ORDER_INT_LINE_NO = D.ORDER_INT_LINE_NO AND A.SCHED_LINE_NBR = 0) OR ( A.ORDER_INT_LINE_NO = D.ORDER_INT_LINE_NO AND A.SCHED_LINE_NBR = D.SCHED_LINE_NBR)) AND A.EFF_STATUS = 'A' AND A.HOLD_CD <> ( SELECT X.HOLD_CUST_PICKUP FROM PS_BUS_UNIT_TBL_OM X WHERE X.BUSINESS_UNIT = A.BUSINESS_UNIT) AND E.CUST_PICKUP = 'N' AND D.BUSINESS_UNIT = E.BUSINESS_UNIT AND D.DEMAND_SOURCE = E.DEMAND_SOURCE AND D.SOURCE_BUS_UNIT = E.SOURCE_BUS_UNIT AND D.ORDER_NO = E.ORDER_NO AND D.ORDER_INT_LINE_NO = E.ORDER_INT_LINE_NO AND D.SCHED_LINE_NBR = E.SCHED_LINE_NBR AND NOT EXISTS ( SELECT B.DEMAND_SOURCE FROM PS_IN_SDWC_HLD_CTX B , PS_EOEN_DASHBRD C WHERE B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.DEMAND_SOURCE = D.DEMAND_SOURCE AND B.SOURCE_BUS_UNIT = D.SOURCE_BUS_UNIT AND B.ORDER_NO = D.ORDER_NO AND B.ORDER_INT_LINE_NO = D.ORDER_INT_LINE_NO AND B.SCHED_LINE_NBR = D.SCHED_LINE_NBR AND B.DEMAND_LINE_NO = D.DEMAND_LINE_NO AND B.INV_ITEM_ID = D.INV_ITEM_ID AND B.EOEN_PRCS_NAME = C.EOEN_PRCS_NAME AND B.EOEN_CATEGORY = C.EOEN_CATEGORY AND B.SEQ_NBR_EOEN = C.SEQ_NBR_EOEN AND C.EOEN_STATUS = '0') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_OM_NONVW |
2 | DEMAND_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order |
3 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Source Bus Unit
Prompt Table: SP_BU_FS_NONVW |
4 | 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 |
5 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
6 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
7 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
8 | DEMAND_LINE_NO | Number(4,0) | SMALLINT NOT NULL | Demand Line No |
9 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
10 | HOLD_CD | Character(6) | VARCHAR2(6) NOT NULL |
Hold Code
Prompt Table: HOLD_CD |
11 | PROD_COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product Component ID
Prompt Table: PROD_NOTKIT_VW |
12 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: PROD_ITEM |
13 | PARENT_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Parent Product Id |
14 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
15 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
16 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table: CUST_SHPINV_VW |
17 | SHIP_CUST_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Ship To Name |
18 | SCHED_DTTM | DateTime(26) | TIMESTAMP | 08/16/01 JNW (CN#PL900-1.0): Added |
19 | IN_FULFILL_STATE | Character(2) | VARCHAR2(2) NOT NULL |
Inventory Fulfillment State
10=Pending 20=Unfulfilled 30=Releasable 40=Released 50=Confirmed 60=Shipped 70=Depleted 90=Canceled |
20 | QTY_REQUESTED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Requested |
21 | QTY_REQUESTED_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Requested Base |
22 | QTY_BACKORDER | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Backorder Qty |
23 | QTY_BACKORDER_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Backorder Base Qty |
24 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
25 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
26 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
27 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |
28 | PEG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open 20=Completed 30=Canceled 40=Not Pegged |
29 | SUP_PEG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open 20=Completed 30=Canceled 40=Unpegged |
30 | SINGLE_SHIP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Single Ship Flag
N=No Y=Yes |
31 | ROUTE_CD | Character(6) | VARCHAR2(6) NOT NULL | A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles. |
32 | ROUTE_STOP_NBR | Number(5,0) | INTEGER NOT NULL | An identifier used to sequence customer addresses/location for a given route. |
33 | LOAD_ID | Character(10) | VARCHAR2(10) NOT NULL | Load ID |
34 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
35 | TOTAL_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Quantity |
36 | QTY_SHIPPED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Shipped |
37 | EXTENDED_NET_PRICE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Ext Net Amount |
38 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
39 | IN_PROCESS_DATE | Date(10) | DATE | Process Date |
40 | SCHED_SHIP_DATE | Date(10) | DATE | Scheduled Ship Date |
41 | IN_SDWC_HASH_KEY | Character(60) | VARCHAR2(60) NOT NULL | Hash |