BUSINESS_UNIT_RFSO_IDCA_TXN_CRM_1_VW(SQL View) |
Index Back |
|---|---|
view upon CA_TXN_CRMview upon CA_TXN_CRM - for service order id |
| SELECT CRM.BUSINESS_UNIT_RF ,CRM.SO_ID FROM PS_CA_TXN_CRM CRM , PS_CA_TXN_TBL TXN , PS_CA_CONTR_HDR HDR WHERE CRM.CA_TXN_ID = TXN.CA_TXN_ID AND HDR.CONTRACT_NUM = TXN.CONTRACT_NUM AND HDR.CA_RQST_SRC <> 'OND' AND CRM.SO_ID <> ' ' GROUP BY CRM.BUSINESS_UNIT_RF,CRM.SO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_RF |
Character(5) | VARCHAR2(5) NOT NULL | Field Services Business Unit |
| 2 | SO_ID |
Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |