OMCLS_PRDK_R_VW(SQL View) |
Index Back |
|---|---|
OM Order Close Kits Req. VwThis view is used during the Order Close background process to determine whick kits are shipped complete by looking at the required components list and checking the backorder cancel flags. |
| SELECT ol.business_unit , ol.order_no , ol.order_int_line_no , os.sched_line_nbr , os.ord_sch_status , pk.product_id , pk.prod_component_id , %Round(%DecMult(os.qty_scheduled, pk.qty_per) ,4) , os.sched_ship_dttm , pk.date_in_effect , pk.date_obsolete FROM ps_ord_line ol , ps_ord_schedule os , ps_set_cntrl_rec s , ps_prod_item pi , ps_prodkit_comps pk WHERE ol.business_unit = os.business_unit AND ol.order_no = os.order_no AND ol.order_int_line_no = os.order_int_line_no AND ol.product_id = pi.product_id AND pi.setid = pk.setid AND pi.product_id = pk.product_id AND pi.product_kit_flag = 'Y' AND pi.setid = s.setid AND s.setcntrlvalue = ol.business_unit AND s.recname = 'PROD_ITEM' AND pk.qty_code='ASY' AND ((OS.DEMAND_SENT = 'Y' AND EXISTS ( SELECT 'X' FROM PS_IN_DEMAND SH WHERE SH.SOURCE_BUS_UNIT = OS.BUSINESS_UNIT AND SH.ORDER_NO = OS.ORDER_NO AND SH.ORDER_INT_LINE_NO = OS.ORDER_INT_LINE_NO AND SH.SCHED_LINE_NBR = OS.SCHED_LINE_NBR AND SH.DEMAND_SOURCE = 'OM' AND SH.PARENT_PROD_ID = PK.PRODUCT_ID AND SH.BUSINESS_UNIT = OS.SHIP_FROM_BU AND SH.PRODUCT_ID = PK.PROD_COMPONENT_ID)) OR OS.DEMAND_SENT = 'N') |
| # | 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 | ORD_SCH_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Schedule Status
C=Closed O=Open P=Pending X=Canceled |
| 6 | PARENT_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Parent Product Id |
| 7 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 8 | QTY_SCHEDULED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Scheduled |
| 9 | SCHED_SHIP_DTTM | DateTime(26) | TIMESTAMP | Schedule Ship Datetime |
| 10 | DATE_IN_EFFECT | Date(10) | DATE | 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label |
| 11 | DATE_OBSOLETE | Date(10) | DATE | Obsolete Date |