DBA Data[Home] [Help]

APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on ZX_REPORT_TYPES_USAGES_S

Line 439: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

435: LAST_UPDATE_LOGIN ,
436: REPORTING_TYPE_ID ,
437: OBJECT_VERSION_NUMBER
438: )
439: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
440: LOOKUP_CODE ,--ENTITY_CODE
441: decode(LOOKUP_CODE,
442: 'ZX_PARTY_TAX_PROFILE',
443: 'Y',

Line 478: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

474: LAST_UPDATE_LOGIN ,
475: REPORTING_TYPE_ID ,
476: OBJECT_VERSION_NUMBER
477: )
478: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
479: LOOKUP_CODE ,--ENTITY_CODE
480: decode(LOOKUP_CODE,
481: 'ZX_PARTY_TAX_PROFILE',
482: 'Y',

Line 517: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

513: LAST_UPDATE_LOGIN ,
514: OBJECT_VERSION_NUMBER
515: )
516: SELECT
517: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
518: types.reporting_type_id ,--REPORTING_TYPE_ID
519: lookups.lookup_code ,--ENTITY_CODE
520: DECODE(lookups.lookup_code,
521: 'ZX_RATES','Y', --Bug 5528045

Line 5138: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

5134: LAST_UPDATE_LOGIN ,
5135: REPORTING_TYPE_ID ,
5136: OBJECT_VERSION_NUMBER
5137: )
5138: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5139: lookups.lookup_code , --ENTITY_CODE --Bug 5528045
5140: DECODE(lookups.lookup_code,
5141: 'ZX_RATES','Y',
5142: 'N') ,--ENABLED_FLAG --Bug 5528045

Line 5254: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

5250: LAST_UPDATE_LOGIN ,
5251: OBJECT_VERSION_NUMBER
5252: )
5253: SELECT
5254: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5255: types.reporting_type_id ,--REPORTING_TYPE_ID
5256: lookups.lookup_code ,--ENTITY_CODE
5257: DECODE(lookups.lookup_code,
5258: 'ZX_RATES','Y', --Bug 5528045

Line 5807: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

5803: LAST_UPDATE_LOGIN ,
5804: REPORTING_TYPE_ID ,
5805: OBJECT_VERSION_NUMBER
5806: )
5807: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5808: 'ZX_RATES_B' ,--ENTITY_CODE
5809: 'Y' ,--ENABLED_FLAG
5810: fnd_global.user_id ,--CREATED_BY
5811: SYSDATE ,--CREATION_DATE

Line 6406: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6402: LAST_UPDATE_LOGIN ,
6403: REPORTING_TYPE_ID ,
6404: OBJECT_VERSION_NUMBER
6405: )
6406: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6407: 'ZX_RATES' ,--ENTITY_CODE --Bug 5528484
6408: 'Y' ,--ENABLED_FLAG
6409: 120 ,--CREATED_BY
6410: SYSDATE ,--CREATION_DATE

Line 6444: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6440: LAST_UPDATE_LOGIN ,
6441: REPORTING_TYPE_ID ,
6442: OBJECT_VERSION_NUMBER
6443: )
6444: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6445: 'ZX_PARTY_TAX_PROFILE' ,--ENTITY_CODE
6446: 'Y' ,--ENABLED_FLAG
6447: 120 ,--CREATED_BY
6448: SYSDATE ,--CREATION_DATE

Line 6843: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6839: LAST_UPDATE_LOGIN ,
6840: OBJECT_VERSION_NUMBER
6841: )
6842: SELECT
6843: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6844: types.reporting_type_id ,--REPORTING_TYPE_ID
6845: lookups.lookup_code ,--ENTITY_CODE
6846: DECODE(lookups.lookup_code,
6847: 'ZX_RATES','Y',

Line 6888: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6884: LAST_UPDATE_LOGIN ,
6885: OBJECT_VERSION_NUMBER
6886: )
6887: SELECT
6888: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6889: types.reporting_type_id ,--REPORTING_TYPE_ID
6890: lookups.lookup_code ,--ENTITY_CODE
6891: DECODE(lookups.lookup_code,
6892: 'ZX_PARTY_TAX_PROFILE','Y',

Line 7092: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

7088: LAST_UPDATE_LOGIN ,
7089: OBJECT_VERSION_NUMBER
7090: )
7091: SELECT
7092: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
7093: types.reporting_type_id ,--REPORTING_TYPE_ID
7094: 'ZX_RATES' ,--ENTITY_CODE
7095: 'Y' ,--ENABLED_FLAG
7096: fnd_global.user_id ,--CREATED_BY

Line 7583: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

7579: LAST_UPDATE_LOGIN ,
7580: OBJECT_VERSION_NUMBER
7581: )
7582: SELECT
7583: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
7584: types.reporting_type_id ,--REPORTING_TYPE_ID
7585: 'ZX_RATES' ,--ENTITY_CODE
7586: 'Y' ,--ENABLED_FLAG
7587: fnd_global.user_id ,--CREATED_BY