EX_APR_PROF_VW(SQL View) |
Index Back |
---|---|
Approver Profile ViewApprover profile prompt view |
SELECT A.BUSINESS_UNIT_GL , A.APPROVER_PROFILE FROM PS_EX_APPRVR A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BU_GL_NONVW |
2 | APPROVER_PROFILE | Character(15) | VARCHAR2(15) NOT NULL |
Approver profile name
Prompt Table:
EX_PROF_ASGN_VW
|