BUSINESS_UNITPrompt Table: SP_BU_PC_NONVW
SO_IDLANGUAGE_CDPrompt Table: FO_CUST_AL_SCH3
FO_ORD_SR_LNGVW(SQL View) |
Index Back |
|---|---|
Order search view |
| SELECT A.BUSINESS_UNIT ,A.SO_ID , C.LANGUAGE_CD ,C.NAME1 FROM PS_RS_SO_HDR A , PS_RS_SO_STATUS B , PS_CUSTOMER_LANG C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND B.LASTUPDDTTM = ( SELECT MAX(LASTUPDDTTM) FROM PS_RS_SO_STATUS B1 WHERE B.BUSINESS_UNIT = B1.BUSINESS_UNIT AND B.SO_ID = B1.SO_ID) AND C.SETID = ( SELECT SC.SETID FROM PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = A.BUSINESS_UNIT AND SC.REC_GROUP_ID = 'FS_23' AND SC.RECNAME = 'CUSTOMER') AND A.CUST_ID = C.CUST_ID AND A.SYSTEM_SOURCE = 'STF' |
| # | 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_PC_NONVW |
| 2 | SO_ID |
Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL |
Name 1
Prompt Table: FO_CUST_AL_SCH3 |