eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IBY_TRANSACTIONCC_PKG dependencies on CE_SECURITY_PROFILES_V

Line 3352: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.

3348: txn.batchid IS NULL AND
3349: /*
3350: * Fix for bug 5632947:
3351: *
3352: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.
3353: */
3354: ((txn.org_id IS NULL) OR
3355: ((txn.org_id IS NOT NULL) AND
3356: (txn.org_id, txn.org_type) IN

Line 3361: ce_security_profiles_v ce

3357: (SELECT
3358: ce.organization_id,
3359: ce.organization_type
3360: FROM
3361: ce_security_profiles_v ce
3362: )))
3363: ORDER BY
3364: txn.process_profile_code, --
3365: txn.bepkey, -- Ensure that the

Line 3642: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.

3638: || 'txn.batchid IS NULL AND '
3639: /*
3640: * Fix for bug 5632947:
3641: *
3642: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.
3643: */
3644: || '((txn.org_id IS NULL) OR '
3645: || '((txn.org_id IS NOT NULL) AND '
3646: || '(txn.org_id, txn.org_type) IN '

Line 3651: || ' ce_security_profiles_v ce '

3647: || ' (SELECT '
3648: || ' ce.organization_id, '
3649: || ' ce.organization_type '
3650: || ' FROM '
3651: || ' ce_security_profiles_v ce '
3652: || ' ))) '
3653: || NVL (l_sql_str, 'AND 1=1 ')
3654: || 'ORDER BY '
3655: || 'txn.process_profile_code, ' --

Line 4525: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.

4521: txn.batchid IS NULL AND
4522: /*
4523: * Fix for bug 5632947:
4524: *
4525: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.
4526: */
4527: ((txn.org_id IS NULL) OR
4528: ((txn.org_id IS NOT NULL) AND
4529: (txn.org_id, txn.org_type) IN

Line 4534: ce_security_profiles_v ce

4530: (SELECT
4531: ce.organization_id,
4532: ce.organization_type
4533: FROM
4534: ce_security_profiles_v ce
4535: )))
4536: ORDER BY
4537: txn.process_profile_code, --
4538: txn.bepkey, -- Ensure that the

Line 4841: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.

4837: || 'txn.batchid IS NULL AND '
4838: /*
4839: * Fix for bug 5632947:
4840: *
4841: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.
4842: */
4843: || '((txn.org_id IS NULL) OR '
4844: || '((txn.org_id IS NOT NULL) AND '
4845: || '(txn.org_id, txn.org_type) IN '

Line 4850: || ' ce_security_profiles_v ce '

4846: || ' (SELECT '
4847: || ' ce.organization_id, '
4848: || ' ce.organization_type '
4849: || ' FROM '
4850: || ' ce_security_profiles_v ce '
4851: || ' ))) '
4852: || NVL (l_sql_str, 'AND 1=1 ')
4853: || 'ORDER BY '
4854: || 'txn.process_profile_code, ' --