DBA Data[Home] [Help]

APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on ZX_REPORT_TYPES_USAGES_S

Line 454: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

450: LAST_UPDATE_LOGIN ,
451: REPORTING_TYPE_ID ,
452: OBJECT_VERSION_NUMBER
453: )
454: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
455: LOOKUP_CODE ,--ENTITY_CODE
456: decode(LOOKUP_CODE,
457: 'ZX_PARTY_TAX_PROFILE',
458: 'Y',

Line 493: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

489: LAST_UPDATE_LOGIN ,
490: REPORTING_TYPE_ID ,
491: OBJECT_VERSION_NUMBER
492: )
493: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
494: LOOKUP_CODE ,--ENTITY_CODE
495: decode(LOOKUP_CODE,
496: 'ZX_PARTY_TAX_PROFILE',
497: 'Y',

Line 532: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

528: LAST_UPDATE_LOGIN ,
529: OBJECT_VERSION_NUMBER
530: )
531: SELECT
532: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
533: types.reporting_type_id ,--REPORTING_TYPE_ID
534: lookups.lookup_code ,--ENTITY_CODE
535: DECODE(lookups.lookup_code,
536: 'ZX_RATES','Y', --Bug 5528045

Line 5167: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

5163: LAST_UPDATE_LOGIN ,
5164: REPORTING_TYPE_ID ,
5165: OBJECT_VERSION_NUMBER
5166: )
5167: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5168: lookups.lookup_code , --ENTITY_CODE --Bug 5528045
5169: DECODE(lookups.lookup_code,
5170: 'ZX_RATES','Y',
5171: 'N') ,--ENABLED_FLAG --Bug 5528045

Line 5283: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

5279: LAST_UPDATE_LOGIN ,
5280: OBJECT_VERSION_NUMBER
5281: )
5282: SELECT
5283: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5284: types.reporting_type_id ,--REPORTING_TYPE_ID
5285: lookups.lookup_code ,--ENTITY_CODE
5286: DECODE(lookups.lookup_code,
5287: 'ZX_RATES','Y', --Bug 5528045

Line 5836: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

5832: LAST_UPDATE_LOGIN ,
5833: REPORTING_TYPE_ID ,
5834: OBJECT_VERSION_NUMBER
5835: )
5836: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5837: 'ZX_RATES_B' ,--ENTITY_CODE
5838: 'Y' ,--ENABLED_FLAG
5839: fnd_global.user_id ,--CREATED_BY
5840: SYSDATE ,--CREATION_DATE

Line 6435: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6431: LAST_UPDATE_LOGIN ,
6432: REPORTING_TYPE_ID ,
6433: OBJECT_VERSION_NUMBER
6434: )
6435: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6436: 'ZX_RATES' ,--ENTITY_CODE --Bug 5528484
6437: 'Y' ,--ENABLED_FLAG
6438: 120 ,--CREATED_BY
6439: SYSDATE ,--CREATION_DATE

Line 6473: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6469: LAST_UPDATE_LOGIN ,
6470: REPORTING_TYPE_ID ,
6471: OBJECT_VERSION_NUMBER
6472: )
6473: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6474: 'ZX_PARTY_TAX_PROFILE' ,--ENTITY_CODE
6475: 'Y' ,--ENABLED_FLAG
6476: 120 ,--CREATED_BY
6477: SYSDATE ,--CREATION_DATE

Line 6872: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6868: LAST_UPDATE_LOGIN ,
6869: OBJECT_VERSION_NUMBER
6870: )
6871: SELECT
6872: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6873: types.reporting_type_id ,--REPORTING_TYPE_ID
6874: lookups.lookup_code ,--ENTITY_CODE
6875: DECODE(lookups.lookup_code,
6876: 'ZX_RATES','Y',

Line 6917: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6913: LAST_UPDATE_LOGIN ,
6914: OBJECT_VERSION_NUMBER
6915: )
6916: SELECT
6917: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6918: types.reporting_type_id ,--REPORTING_TYPE_ID
6919: lookups.lookup_code ,--ENTITY_CODE
6920: DECODE(lookups.lookup_code,
6921: 'ZX_PARTY_TAX_PROFILE','Y',

Line 7121: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

7117: LAST_UPDATE_LOGIN ,
7118: OBJECT_VERSION_NUMBER
7119: )
7120: SELECT
7121: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
7122: types.reporting_type_id ,--REPORTING_TYPE_ID
7123: 'ZX_RATES' ,--ENTITY_CODE
7124: 'Y' ,--ENABLED_FLAG
7125: fnd_global.user_id ,--CREATED_BY

Line 7613: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

7609: LAST_UPDATE_LOGIN ,
7610: OBJECT_VERSION_NUMBER
7611: )
7612: SELECT
7613: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
7614: types.reporting_type_id ,--REPORTING_TYPE_ID
7615: 'ZX_RATES' ,--ENTITY_CODE
7616: 'Y' ,--ENABLED_FLAG
7617: fnd_global.user_id ,--CREATED_BY

Line 8063: SELECT zx_report_types_usages_s.nextval , --REPORTING_TYPE_USAGE_ID

8059: LAST_UPDATE_LOGIN ,
8060: REPORTING_TYPE_ID ,
8061: OBJECT_VERSION_NUMBER
8062: )
8063: SELECT zx_report_types_usages_s.nextval , --REPORTING_TYPE_USAGE_ID
8064: lookups.lookup_code , --ENTITY_CODE
8065: DECODE(lookups.lookup_code,
8066: 'ZX_RATES','Y',
8067: 'ZX_STATUS','Y',