Query for Tree Security

                                Query for  getting list of  records  from access group and tree 

SELECT R.TREE_NAME, G1.TREE_NODE,G.TREE_NODE,R.TREE_NODE  FROM pstreenode  R,  pstreenode  G      ,(SELECT TREE_NAME,TREE_NODE,TREE_NODE_TYPE FROM pstreenode WHERE TREE_NODE_TYPE = 'G' )

G1

WHERE R.TREE_NODE_TYPE = 'R'

AND G.TREE_NODE_TYPE = 'G'

AND R.PARENT_NODE_NAME = G.TREE_NODE

AND G.tree_name = 'QUERY_TREE_AM'

AND R.TREE_NAME = G.TREE_NAME

AND G.PARENT_NODE_NAME = G1.TREE_NODE (+)

AND G.TREE_NAME = G1.TREE_NAME            (+)

ORDER BY 1,2 ;

Query to find the list of users having access to component, action along with Navigation details

 

SELECT DISTINCT roleclass.rolename,
authitem.menuname,
authitem.menulabel, 
authitem.baritemname,
authitem.itemlabel,
DECODE(authitem.DISPLAYONLY, 0, 'N', 1, 'Y') AS "Display_Only",
CASE authitem.AUTHORIZEDACTIONS
    WHEN 1 THEN 'Add'
    WHEN 2 THEN 'Update/Display'
    WHEN 3 THEN 'Add, Update/Display'
    WHEN 4 THEN 'Update/Display All'
    WHEN 5 THEN 'Add, Update/Display All'
    WHEN 6 THEN 'Update/Display, Update/Display All'
    WHEN 7 THEN 'Add, Update/Display, Update/Display All'
    WHEN 8 THEN 'Correction'
    WHEN 9 THEN 'Add, Correction'
    WHEN 10 THEN 'Update/Display, Correction'
    WHEN 11 THEN 'Add, Update/Display, Correction'
    WHEN 12 THEN 'Update/Display All, Correction'
    WHEN 13 THEN 'Add, Update/Display All, Correction'
    WHEN 14 THEN 'Update/Display, Update/Display All, Correction'
    WHEN 15 THEN 'Add, Update/Display, Update/Display All, Correction'
    ELSE 'SPECIAL' END AS "Authorized_Actions",
authitem.PNLGRPNAME,
CASE InStr(nav.PATH_TO_COMPONENT, 'Root>', 1)
  WHEN 0 THEN nav.PATH_TO_COMPONENT
  ELSE SubStr(nav.PATH_TO_COMPONENT, InStr(nav.PATH_TO_COMPONENT, 'Root>', 1) + 5, length(nav.PATH_TO_COMPONENT) - InStr(nav.PATH_TO_COMPONENT, 'Root>', 1) + 5)
  END AS navigation
from
(SELECT
DISTINCT a.CLASSID, a.MENUNAME, b.MENULABEL , a.BARITEMNAME,c.itemlabel ,
a.DISPLAYONLY,                                                                               
a.AUTHORIZEDACTIONS,
c.PNLGRPNAME
FROM PSAUTHITEM a, PSMENUDEFN b, PS_ACLCOMPONENT_V2 c
where a.MENUNAME = b.MENUNAME
AND a.menuname =  c.menuname
AND a.barname = c.barname
AND a.baritemname = c.baritemname) authitem ,
psroleclass roleclass,
(SELECT a.PORTAL_URI_SEG2 as component
, E.PORTAL_LABEL || '>' || D.PORTAL_LABEL || '>' ||C.PORTAL_LABEL ||
'>' || B.PORTAL_LABEL || '>' || A.PORTAL_LABEL as PATH_TO_COMPONENT
, A.PORTAL_URLTEXT
, A.PORTAL_ISPUBLIC as Active
, A.LASTUPDOPRID
, A.LASTUPDDTTM
, A.PORTAL_URI_SEG2
FROM PSPRSMDEFN A, PSPRSMDEFN B, PSPRSMDEFN C, PSPRSMDEFN D, PSPRSMDEFN
E
WHERE 1=1
AND A.PORTAL_PRNTOBJNAME = B.PORTAL_OBJNAME(+)
AND B.PORTAL_PRNTOBJNAME = C.PORTAL_OBJNAME(+)
AND C.PORTAL_PRNTOBJNAME = D.PORTAL_OBJNAME(+)
AND D.PORTAL_PRNTOBJNAME = E.PORTAL_OBJNAME(+)
AND (E.PORTAL_NAME IS NULL OR E.PORTAL_NAME = 'EMPLOYEE')
AND (A.PORTAL_NAME = 'EMPLOYEE' OR A.PORTAL_NAME IS NULL )
AND (B.PORTAL_NAME = 'EMPLOYEE' OR B.PORTAL_NAME IS NULL )
AND (C.PORTAL_NAME = 'EMPLOYEE' OR C.PORTAL_NAME IS NULL )
AND (D.PORTAL_NAME = 'EMPLOYEE' OR D.PORTAL_NAME IS NULL )
) nav
WHERE  roleclass.rolename =
AND authitem.classid = roleclass.classid
AND  authitem.PNLGRPNAME =  nav.PORTAL_URI_SEG2(+)
ORDER BY rolename, menuname, baritemname

 

PeopleSoft Query to find the objects which are not included in the Project

Below are the SQLs to find the Peoplecode and SQL objects which are  created or modified by you but not included in any of your project.

 

 

--------------------------------------------------

-- Selects Peoplecode not inserted in a project

--------------------------------------------------

SELECT

CASE A.OBJECTID1

when 1 then 'Record Peoplecode'

when 3 then 'Menu Peoplecode'

when 9 then 'Page Peoplecode'

when 10 then 'Component level Peoplecode'

when 60 then 'Message Peoplecode'

when 74 then 'Component Interface Peoplecode'

when 87 then 'Subscription Peoplecode'

END AS  OBJect_Type

,

A.OBJECTVALUE1 || '.' || A.OBJECTVALUE2 || '.' || A.OBJECTVALUE3 || '.' || A.OBJECTVALUE4 || '.' || A.OBJECTVALUE5 || '.' || A.OBJECTVALUE6  || '.' || A.OBJECTVALUE7

AS EXTENDED_OBJ_NAME

FROM PSPCMPROG    A 

 , PSPCMTXT B -- join to pspcmtxt to filter out reverted changes (back to blank)

WHERE  LASTUPDOPRID =

AND  A.OBJECTID1 || A.OBJECTVALUE1 || A.OBJECTID2 ||A.OBJECTVALUE2 || A.OBJECTID3 || A.OBJECTVALUE3 || A.OBJECTID4 || A.OBJECTVALUE4

NOT IN

(

SELECT OBJECTID1 || OBJECTVALUE1 || OBJECTID2 || OBJECTVALUE2 || OBJECTID3 || OBJECTVALUE3 || OBJECTID4 || OBJECTVALUE4

FROM PSPROJECTITEM I, PSPROJECTDEFN   d

WHERE I.PROJECTNAME = D.PROJECTNAME

AND D.LASTUPDOPRID =

and i.objecttype in (8,9,39,40,42,43,44,46,47,48)

)

AND a.objectid1                               = b.objectid1

AND a.objectvalue1                        = b.objectvalue1

AND a.objectid2                               = b.objectid2

AND a.objectvalue2                        = b.objectvalue2            

AND a.objectid3                               = b.objectid3

AND a.objectvalue3                        = b.objectvalue3

AND a.objectid4                               = b.objectid4

AND a.objectvalue4                        = b.objectvalue4

AND a.objectid5                               = b.objectid5

AND a.objectvalue5                        = b.objectvalue5

AND a.objectid6                               = b.objectid6

AND a.objectvalue6                        = b.objectvalue6

AND a.objectid7                               = b.objectid7

AND a.objectvalue7                        = b.objectvalue7

AND  A.OBJECTID1 NOT IN   (66,104)

;    

  

 

 

--------------------------------------------------

-- Selects App Engine Peoplecode not inserted in a project

--------------------------------------------------

SELECT

DISTINCT

'Application Engine Peoplecode',

A.OBJECTVALUE1 || '.' || A.OBJECTVALUE2 || '.' || A.OBJECTVALUE3 || '.' || A.OBJECTVALUE4 || '.' || A.OBJECTVALUE5 || '.' || A.OBJECTVALUE6  || '.' || A.OBJECTVALUE7

FROM PSPCMPROG    A 

WHERE  LASTUPDOPRID =

AND   A.OBJECTID1|| A.OBJECTVALUE1|| A.OBJECTID2||A.OBJECTVALUE2||A.OBJECTVALUE3||A.OBJECTVALUE4||A.OBJECTVALUE5  

 NOT IN

(

SELECT I.OBJECTID1 ||I.OBJECTVALUE1 || I.OBJECTID2 ||REPLACE(I.OBJECTVALUE2,' ','')

 FROM PSPROJECTITEM I, PSPROJECTDEFN   d

WHERE I.PROJECTNAME = D.PROJECTNAME

AND D.LASTUPDOPRID =

and objecttype =43

)

and A.OBJECTID1 = 66

;    

 

--------------------------------------------------

-- Selects App Package Peoplecode not inserted in a project

--------------------------------------------------

SELECT

'Application Package Peoplecode'

, A.OBJECTVALUE1 || '.' || A.OBJECTVALUE2

 FROM PSPCMPROG    A 

WHERE  LASTUPDOPRID =

AND   A.OBJECTID1|| A.OBJECTVALUE1|| A.OBJECTID2||A.OBJECTVALUE2

NOT IN

(

SELECT I.OBJECTID1 ||I.OBJECTVALUE1 || I.OBJECTID2 || I.OBJECTVALUE2

 FROM PSPROJECTITEM I, PSPROJECTDEFN   d

WHERE I.PROJECTNAME = D.PROJECTNAME

AND D.LASTUPDOPRID =

and objecttype =58

)

and A.OBJECTID1 = 104

;    

 

 

 

--------------------------------------------------

-- Selects SQL Objects not inserted in a project

--------------------------------------------------

SELECT 

CASE WHEN SQLTYPE = 0 THEN 'SQL Object '

WHEN SQLTYPE = 1 THEN 'App Engine Step '

WHEN SQLTYPE = 2 THEN 'Record View'

WHEN SQLTYPE = 6 THEN 'Application Engine XSLT'

END AS OBJECTTYPE      ,

SQLID

FROM PSSQLDEFN

WHERE   LASTUPDOPRID =

AND  SQLID

NOT IN

(

SELECT OBJECTVALUE1

FROM PSPROJECTITEM I, PSPROJECTDEFN   d

WHERE I.PROJECTNAME = D.PROJECTNAME

AND D.LASTUPDOPRID =

AND OBJECTTYPE in (30)

);

PeopleSoft Application 9.0 and 9.1 AWE Records

                    AWE Tables and Migration script

AWE 9.1 Application Tables:

-- Export Transaction Registry
Export EOAW_ADMMON_CFG;
Export EOAW_MONDIS_DTL;
Export EOAW_MONDIS_HDR;
Export EOAW_USRMON_CFG;
Export EOAW_USRMON_LNG;
Export EOAW_TXN;
Export EOAW_TXN_CFG;
Export EOAW_TXN_COMP;
Export EOAW_TXN_LBL;
Export EOAW_TXN_LNG;
Export EOAW_TXN_LVL;


--Export Transaction Notifications 
Export EOAW_NOTIFY;
Export EOAW_NOTIFYDEF;
Export EOAW_NOT_HDR;
Export EOAW_NOT_USER;
Export EOAW_NOT_USRDEF;


-- Export User Lists
Export EOAWUSER_LIST;
Export EOAWUSER_LNG;

-- Export Process Definitions
Export EOAW_IDS where EOAWCOUNTERNAME = 'STAGE_ID';
Export EOAW_PATH;
Export EOAW_PATH_LNG;
Export EOAW_PRCS;
Export EOAW_PRCS_LNG;
Export EOAW_STAGE;
Export EOAW_STEP;
Export EOAW_STEP_LNG;
Export EOAW_STG_LNG;
Export EOAW_TIMEOUT;
Export EOAW_TIMEOUTDEF;

Export EOAW_AUTH;
Export EOAW_AUTH_DTL;
Export EOAWCRTA;
Export EOAWCRTA_LNG;
Export EOAWCRTA_REC;
Export EOAWCRTA_RECLNG;
Export EOAWCRTA_VAL;

-- Export NEM (Notification and Escalations)
Export EOAWNEM;
Export EOAWNEM_EMAIL;
Export EOAWNEM_EVENTS;

-- Export EMC (Email Collaboration)
Export EOAWMCLTLN_LNG;
Export EOAWEMC_LYT_HDR;
Export EOAWEMC_LYT_LIN;
Export EOAWEMC_MSGHDR;
Export EOAWFIELD_LIST;
Export EOAWRMINPT_HDR;
Export EOAWRMINPT_LIN;
Export EOAWXLAT_SYMBOL;

-- Export RunTime 
rem Because the user's Cross Reference Tables need to be exported as well, this should not be done by AWE;
rem Leaving them in for now in case we change this position. 
rem Export EOAW_STEPINST;
rem Export EOAW_USERINST;
rem Export EOAW_WL;

AWE 9.0 Application Tables:

-- Export Transaction Registry
Export PTAFAW_ADMMON_CFG;
Export PTAFAW_MONDIS_DTL;
Export PTAFAW_MONDIS_HDR;
Export PTAFAW_USRMON_CFG;
Export PTAFAW_USRMON_LNG;
Export PTAFAW_TXN;
Export PTAFAW_TXN_CFG;
Export PTAFAW_TXN_COMP;
Export PTAFAW_TXN_LBL;
Export PTAFAW_TXN_LNG;
Export PTAFAW_TXN_LVL;


--Export Transaction Notifications 
Export PTAFAW_NOTIFY;
Export PTAFAW_NOTIFYDEF;
Export PTAFAW_NOT_HDR;
Export PTAFAW_NOT_USER;
Export PTAFAW_NOT_USRDEF;


-- Export User Lists
Export PTAFUSER_LIST;
Export PTAFUSER_LNG;

-- Export Process Definitions
Export PTAFAW_IDS where PTAFAWCOUNTERNAME = 'STAGE_ID';
Export PTAFAW_PATH;
Export PTAFAW_PATH_LNG;
Export PTAFAW_PRCS;
Export PTAFAW_PRCS_LNG;
Export PTAFAW_STAGE;
Export PTAFAW_STEP;
Export PTAFAW_STEP_LNG;
Export PTAFAW_STG_LNG;
Export PTAFAW_TIMEOUT;
Export PTAFAW_TIMEOUTDEF;

Export PTAFAW_AUTH;
Export PTAFAW_AUTH_DTL;
Export PTAFCRTA;
Export PTAFCRTA_LNG;
Export PTAFCRTA_REC;
Export PTAFCRTA_RECLNG;
Export PTAFCRTA_VAL;

-- Export NEM (Notification and Escalations)
Export PTAFAWNEM;
Export PTAFAWNEM_EMAIL;
Export PTAFAWNEM_EVENTS;

-- Export EMC (Email Collaboration)
Export PTAFMCLTLN_LNG;
Export PTAFEMC_LYT_HDR;
Export PTAFEMC_LYT_LIN;
Export PTAFEMC_MSGHDR;
Export PTAFFIELD_LIST;
Export PTAFRMINPT_HDR;
Export PTAFRMINPT_LIN;
Export PTAFXLAT_SYMBOL;

-- Export RunTime 
rem Because the user's Cross Reference Tables need to be exported as well, this should not be done by AWE;
rem Leaving them in for now in case we change this position. 
rem Export PTAFAW_STEPINST;
rem Export PTAFAW_USERINST;
rem Export PTAFAW_WL;

Approval Tables 8.9:

-- Approval Process Definitions
-- Export script for work orders

set output c:\temp\ApprovalsUserData.dat;
set log c:\temp\ApprovalsUserData.log;

EXPORT SAC_USER_LIST;


EXPORT WL_TEMPLATE_GEN;
EXPORT WL_TEMPL_GEN_TK;
EXPORT WL_TEMPL_GEN_RS;

rem Exporting Transaction Registry Information;
EXPORT SAC_AW_TXN;
EXPORT SAC_AW_TXN_COMP;
EXPORT SAC_AW_TXN_LNG;
EXPORT SAC_AW_TXN_LVL;
EXPORT SAC_AW_TXN_LBL;
EXPORT SAC_AW_NOTIFY;
EXPORT SAC_AW_TXN_CFG;
EXPORT SAC_AW_NOT_USER;

REM Exporting Process Definitions;
EXPORT SAC_AW_PRCS;
EXPORT SAC_AW_PRCS_LNG;
EXPORT SAC_AW_STAGE;
EXPORT SAC_AW_PATH;
EXPORT SAC_AW_PATH_LNG
EXPORT SAC_AW_STEP;
EXPORT SAC_AW_STEP_LNG;

REM Exporting Authorized Approver settings;
EXPORT SAC_AW_AUTH;
EXPORT SAC_AW_AUTH_DTL;

REM Exporting Criteria Details;
EXPORT SAC_CRTA;
EXPORT SAC_CRTA_LNG
EXPORT SAC_CRTA_REC;
EXPORT SAC_CRTA_RECLNG;
EXPORT SAC_CRTA_VAL;

Sample Script: 

EXPORT PS_PTAFAW_TXN where PTAFPRCS_ID = 'ABC' ;

EXPORT PS_PTAFAW_TXN_LBL where PTAFPRCS_ID = 'ABC' ;

EXPORT PS_PTAFAW_TXN_LVL where PTAFPRCS_ID = 'ABC' ;

EXPORT PS_PTAFAW_NOTIFY where PTAFPRCS_ID = 'ABC' ;

EXPORT PS_PTAFAW_NOT_USER where PTAFPRCS_ID = 'ABC' ;

EXPORT PS_PTAFAW_TXN_CFG where PTAFPRCS_ID = 'ABC' ;

EXPORT PS_PTAFUSER_LIST;

EXPORT PS_N_WF_TRANS where N_TRAN_CATEGORY = 'ABC';

EXPORT PS_N_WF_TRAN_CAT where N_TRAN_CATEGORY = 'ABC';

EXPORT PS_PTAFAW_PATH  where PTAFPRCS_ID = 'ABC' and EFFDT = (select max(EFFDT) from PS_PTAFAW_PATH B where B.PTAFPRCS_ID = PS_PTAFAW_PATH.PTAFPRCS_ID and B.EFFDT <= SYSDATE );

EXPORT PS_PTAFAW_PRCS  where PTAFPRCS_ID = 'ABC' and EFFDT = (select max(EFFDT) from PS_PTAFAW_PRCS B where B.PTAFPRCS_ID = PS_PTAFAW_PRCS.PTAFPRCS_ID and B.EFFDT <= SYSDATE);

EXPORT PS_PTAFAW_STAGE  where PTAFPRCS_ID = 'ABC' and EFFDT = (select max(EFFDT) from PS_PTAFAW_STAGE B where B.PTAFPRCS_ID = PS_PTAFAW_STAGE.PTAFPRCS_ID and B.EFFDT <= SYSDATE);

EXPORT PS_PTAFAW_STEP  where PTAFPRCS_ID = 'ABC' and EFFDT = (select max(EFFDT) from PS_PTAFAW_STEP B where B.PTAFPRCS_ID = PS_PTAFAW_STEP.PTAFPRCS_ID and B.EFFDT <= SYSDATE);

EXPORT PS_PTAFCRTA  where PTAFCRTA_ID = (select MAX(PTAFCRTA_ID) from PS_PTAFAW_STEP A where PTAFPRCS_ID = 'ABC' and EFFDT = (select max(EFFDT) from PS_PTAFAW_STEP B where B.PTAFPRCS_ID = A.PTAFPRCS_ID and B.EFFDT <= SYSDATE));

EXPORT PS_PTAFCRTA_REC where PTAFCRTA_ID = (select MAX(PTAFCRTA_ID) from PS_PTAFAW_STEP A where PTAFPRCS_ID = 'ABC' and EFFDT = (select max(EFFDT) from PS_PTAFAW_STEP B where B.PTAFPRCS_ID = A.PTAFPRCS_ID and B.EFFDT <= SYSDATE));

EXPORT PS_PTAFCRTA_VAL where PTAFCRTA_ID = (select MAX(PTAFCRTA_ID) from PS_PTAFAW_STEP A where PTAFPRCS_ID = 'ABC' and EFFDT = (select max(EFFDT) from PS_PTAFAW_STEP B where B.PTAFPRCS_ID = A.PTAFPRCS_ID and B.EFFDT <= SYSDATE));

PeopleSoft AWE Migration Scripts

                                          Export script from the Source database

SET OUTPUT c:\temp\AWESetup.dat;
SET LOG c:\temp\AWESetup_export.log;

-- "Register Transaction"
 EXPORT PS_EOAW_TXN WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';
 EXPORT PS_EOAW_TXN_LNG WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';
 EXPORT PS_EOAW_TXN_LBL WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';
 EXPORT PS_EOAW_TXN_LVL WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';
-- "Configure Transactions"
EXPORT PS_EOAW_NOTIFY WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';
EXPORT PS_EOAW_NOT_USER WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';
EXPORT PS_EOAW_TXN_CFG WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';

-- "Setup Process Definitions"
EXPORT PS_EOAW_PRCS WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL'  AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_PRCS_LNG WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_TIMEOUTDEF WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_NOTIFYDEF WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_NOT_USRDEF WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_STAGE WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_STG_LNG WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_PATH WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_PATH_LNG WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_TIMEOUT WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_STEP WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_STEP_LNG WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';

-- "Criteria Definitions"
EXPORT PS_EOAWCRTA WHERE EOAWCRTA_ID LIKE '%BI%2012-08-26%';
EXPORT PS_EOAWCRTA_LNG WHERE EOAWCRTA_ID LIKE '%BI%2012-08-26%';
EXPORT PS_EOAWCRTA_REC WHERE EOAWCRTA_ID LIKE '%BI%2012-08-26%';
EXPORT PS_EOAWCRTA_RECLNG WHERE EOAWCRTA_ID LIKE '%BI%2012-08-26%';
EXPORT PS_EOAWCRTA_VAL WHERE EOAWCRTA_ID LIKE '%BI%2012-08-26%';

-- "Maintain User Lists"
EXPORT PS_EOAWUSER_LIST WHERE EOAWUSER_LIST_ID IN ('N_BI_FIN_OFF','N_BI_FIN_CREDIT_APPRV_OFF','N_BI_FIN_APPRV_OFF','N_BI_DEPT_APPRV_OFF','N_BI_DEPT_CREDIT_APPRV_OFF');
EXPORT PS_EOAWUSER_LNG WHERE EOAWUSER_LIST_ID IN ('N_BI_FIN_OFF','N_BI_FIN_CREDIT_APPRV_OFF','N_BI_FIN_APPRV_OFF','N_BI_DEPT_APPRV_OFF','N_BI_DEPT_CREDIT_APPRV_OFF');
EXPORT PS_EOAW_UL_ATTRIB WHERE EOAWUSER_LIST_ID IN ('N_BI_FIN_OFF','N_BI_FIN_CREDIT_APPRV_OFF','N_BI_FIN_APPRV_OFF','N_BI_DEPT_APPRV_OFF','N_BI_DEPT_CREDIT_APPRV_OFF');

-- "Generic Templates"
EXPORT PS_WL_TEMPLATE_GEN WHERE WL_TEMPLATE_ID LIKE 'Invoice%';
EXPORT PS_WL_TEMPL_GEN_TK WHERE WL_TEMPLATE_ID LIKE 'Invoice%';

EXPORT PS_WL_TEMPL_GEN_RS WHERE WL_TEMPLATE_ID LIKE 'Invoice%';


                                     Import Script into  Target Database

SET INPUT C:\temp\AWESetup_Billing.dat;
SET LOG AWESetup_billing.log;

REM  Register Transaction;
IMPORT EOAW_TXN;
IMPORT EOAW_TXN_LNG;
IMPORT EOAW_TXN_LBL;
IMPORT EOAW_TXN_LVL;

REM Configure Transactions;
IMPORT EOAW_NOTIFY;
IMPORT EOAW_NOT_USER;
IMPORT EOAW_TXN_CFG;

rem Setup Process Definitions;
IMPORT EOAW_PRCS;
IMPORT EOAW_PRCS_LNG;
IMPORT EOAW_TIMEOUTDEF;
IMPORT EOAW_NOTIFYDEF;
IMPORT EOAW_NOT_USRDEF;
IMPORT EOAW_STAGE;
IMPORT EOAW_STG_LNG;
IMPORT EOAW_PATH;
IMPORT EOAW_PATH_LNG;
IMPORT EOAW_TIMEOUT;
IMPORT EOAW_STEP;
IMPORT EOAW_STEP_LNG;

rem Criteria Definitions;
IMPORT EOAWCRTA;
IMPORT EOAWCRTA_LNG;
IMPORT EOAWCRTA_REC;
IMPORT EOAWCRTA_RECLNG;
IMPORT EOAWCRTA_VAL;

rem Maintain User Lists;
IMPORT EOAWUSER_LIST;
IMPORT EOAWUSER_LNG;
IMPORT EOAW_UL_ATTRIB;

REM GENERIC TEMPALTES;
IMPORT PS_WL_TEMPLATE_GEN;
IMPORT PS_WL_TEMPL_GEN_TK;
IMPORT PS_WL_TEMPL_GEN_RS;