501: )
502: SELECT
503: l_terr_rsc_access_id
504: ,SYSDATE
505: ,fnd_global.user_id
506: ,SYSDATE--CREATION_DATE
507: ,fnd_global.user_id
508: ,fnd_global.login_id
509: ,l_terr_rsc_id
503: l_terr_rsc_access_id
504: ,SYSDATE
505: ,fnd_global.user_id
506: ,SYSDATE--CREATION_DATE
507: ,fnd_global.user_id
508: ,fnd_global.login_id
509: ,l_terr_rsc_id
510: --,l_access_type --commented out
511: , rsc_acc.access_type
504: ,SYSDATE
505: ,fnd_global.user_id
506: ,SYSDATE--CREATION_DATE
507: ,fnd_global.user_id
508: ,fnd_global.login_id
509: ,l_terr_rsc_id
510: --,l_access_type --commented out
511: , rsc_acc.access_type
512: , l_org_id --org Id