FROM_TREEDefault Value: RSF_TR_REASSIGN.TREE_NAME
FROM_TERRITORYFROM_SALES_REPPrompt Table: RSF_ACC_FROM_VW
BO_IDROLE_TYPE_IDA=Active
I=Inactive
RSF_TR_REA_ACV2(SQL View) |
Index Back |
|---|---|
Account Reassignment ViewTerritory reassignment for accounts. |
| SELECT E.TREE_NAME , E.TERRITORY_ID , B.PERSON_ID , A.BO_ID_2 , A.ROLE_TYPE_ID_2 , B.BO_ID , C.BO_NAME_DISPLAY , D.CUST_STATUS FROM PS_BO_REL A , PS_RD_PERSON B , PS_BO_NAME C , PS_BC D , PS_RD_ACCT_TR_INFO E WHERE A.REL_TYPE_ID = 31 AND A.BO_ID_1 = B.BO_ID AND C.BO_ID = A.BO_ID_2 AND C.PRIMARY_IND = 'Y' AND A.BO_ID_2 = D.BO_ID AND D.BO_ID = E.BO_ID AND E.ROLE_TYPE_ID = A.ROLE_TYPE_ID_2 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FROM_TREE |
Character(18) | VARCHAR2(18) NOT NULL |
Current Tree Name
Default Value: RSF_TR_REASSIGN.TREE_NAME |
| 2 | FROM_TERRITORY |
Character(20) | VARCHAR2(20) NOT NULL | Current Territory |
| 3 | FROM_SALES_REP |
Character(15) | VARCHAR2(15) NOT NULL |
Current Sales Representative
Prompt Table: RSF_ACC_FROM_VW |
| 4 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 5 | ROLE_TYPE_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 6 | FROM_BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Current Sales Rep BOID |
| 7 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 8 | CUST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Customer Status Indicator. BC.CUST_STATUS
A=Active I=Inactive |