BUSINESS_UNITPrompt Table: BUS_UNIT_TBL_OM
SOLD_TO_CUST_IDLANGUAGE_CDORD_CUST_HS_LVW(SQL View) |
Index Back |
|---|---|
Order Line view for copies111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL |
| SELECT A.BUSINESS_UNIT , A.SOLD_TO_CUST_ID , C.LANGUAGE_CD , C.DESCR FROM PS_ORD_HEADER A , PS_ORD_LINE B , PS_PROD_ITEM_LNG C , PS_ORD_HEADER_LOCK L WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ORDER_NO = B.ORDER_NO AND A.ORDER_STATUS IN ('C','O','P') AND B.ORD_LINE_STATUS IN ('C','O','P') AND C.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = A.BUSINESS_UNIT AND S.RECNAME = 'PROD_ITEM_LNG') AND B.PRODUCT_ID = C.PRODUCT_ID AND A.ORDER_TYPE_CD = 'SO' AND %Join(COMMON_KEYS, ORD_HEADER A, ORD_HEADER_LOCK L) AND L.BACKGROUND_REQD = 'N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_OM |
| 2 | SOLD_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |