[Home] [Help]
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',
444: 'N') ,--ENABLED_FLAG
445: fnd_global.user_id ,--CREATED_BY
446: SYSDATE ,--CREATION_DATE
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',
483: 'N') ,--ENABLED_FLAG
484: fnd_global.user_id ,--CREATED_BY
485: SYSDATE ,--CREATION_DATE
1215: LAST_UPDATE_LOGIN,
1216: OBJECT_VERSION_NUMBER)
1217: (SELECT
1218: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1219: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1220: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1221: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1222: pvs.GLOBAL_ATTRIBUTE18, --REPORTING_CODE_CHAR_VALUE
1223: null, --EXCEPTION_CODE
1231: 1
1232: FROM
1233: zx_reporting_types_b types,
1234: ap_supplier_sites pvs,
1235: zx_party_tax_profile ptp
1236:
1237: WHERE
1238:
1239: types.reporting_type_code = 'FISCAL PRINTER' and
1241: ptp.Party_Type_Code = 'THIRD_PARTY_SITE' AND -- Bug 4886324
1242: ptp.party_id = pvs.PARTY_SITE_ID
1243:
1244: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1245: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1246: and entity_id = ptp.Party_Tax_Profile_Id
1247: and reporting_type_id = types.reporting_type_id));
1248:
1249:
1265: LAST_UPDATE_LOGIN,
1266: OBJECT_VERSION_NUMBER)
1267: (SELECT
1268: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1269: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1270: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1271: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1272: pvs.GLOBAL_ATTRIBUTE19, --REPORTING_CODE_NUM_VALUE
1273: null, --EXCEPTION_CODE
1281: 1
1282: FROM
1283: zx_reporting_types_b types,
1284: ap_supplier_sites pvs ,
1285: zx_party_tax_profile ptp
1286:
1287: WHERE
1288: types.reporting_type_code = 'CAI NUMBER' and
1289: pvs.GLOBAL_ATTRIBUTE_CATEGORY='JL.AR.APXVDMVD.SUPPLIER_SITES' and
1289: pvs.GLOBAL_ATTRIBUTE_CATEGORY='JL.AR.APXVDMVD.SUPPLIER_SITES' and
1290: ptp.Party_Type_Code = 'THIRD_PARTY_SITE' AND -- Bug 4886324
1291: ptp.party_id = pvs.PARTY_SITE_ID
1292: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1293: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1294: and entity_id = ptp.Party_Tax_Profile_Id
1295: and reporting_type_id = types.reporting_type_id));
1296: */
1297:
1798: LAST_UPDATE_LOGIN,
1799: OBJECT_VERSION_NUMBER) -- Bug 5031787
1800: (SELECT
1801: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1802: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1803: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1804: codes.REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1805: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID
1806: null, --EXCEPTION_CODE
1816: financials_system_params_all fin_sys_param,
1817: zx_reporting_types_b types,
1818: zx_reporting_codes_b codes,
1819: xle_etb_profiles etb,
1820: zx_party_tax_profile ptp
1821:
1822: WHERE
1823: types.reporting_type_id = codes.reporting_type_id
1824: AND types.reporting_type_code = 'MEMBER STATE'
1827: AND ptp.party_id = etb.party_id
1828: AND ptp.Party_Type_Code = 'LEGAL_ESTABLISHMENT'
1829:
1830: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1831: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1832: and entity_id = ptp.Party_Tax_Profile_Id
1833: and reporting_type_id = types.reporting_type_id));
1834: ELSE
1835: INSERT INTO ZX_REPORT_CODES_ASSOC(
1848: LAST_UPDATE_LOGIN,
1849: OBJECT_VERSION_NUMBER) -- Bug 5031787
1850: (SELECT
1851: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1852: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1853: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1854: codes.REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1855: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID
1856: null, --EXCEPTION_CODE
1866: financials_system_params_all fin_sys_param,
1867: zx_reporting_types_b types,
1868: zx_reporting_codes_b codes,
1869: xle_etb_profiles etb,
1870: zx_party_tax_profile ptp
1871:
1872: WHERE
1873: types.reporting_type_id = codes.reporting_type_id
1874: AND types.reporting_type_code = 'MEMBER STATE'
1878: AND ptp.party_id = etb.party_id
1879: AND ptp.Party_Type_Code = 'LEGAL_ESTABLISHMENT'
1880:
1881: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1882: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1883: and entity_id = ptp.Party_Tax_Profile_Id
1884: and reporting_type_id = types.reporting_type_id));
1885: END IF;
1886:
5865: PROCEDURE ZX_CREATE_REP_ASSOCIATION_PTP
5866: (
5867:
5868: p_rep_type_info varchar2,
5869: p_ptp_id zx_party_tax_profile.party_tax_profile_id%type,
5870: p_reporting_type_code zx_reporting_types_b.reporting_type_code%type
5871: )
5872:
5873: IS
5892: LAST_UPDATE_LOGIN,
5893: OBJECT_VERSION_NUMBER)
5894: SELECT
5895: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
5896: 'ZX_PARTY_TAX_PROFILE' , --ENTITY_CODE
5897: p_ptp_id , --ENTITY_ID
5898: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
5899: p_rep_type_info, --REPORTING_CODE_CHAR_VALUE
5900: null, --EXCEPTION_CODE
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
6449: 120 ,--LAST_UPDATED_BY
6457: reporting_type_code IN ('FISCAL PRINTER','CAI NUMBER')
6458: AND record_type_code = 'SEEDED'
6459: AND NOT EXISTS ( select 1 from zx_report_types_usages
6460: where reporting_type_id = rep_type.reporting_type_id and
6461: entity_code = 'ZX_PARTY_TAX_PROFILE' );
6462:
6463: END CREATE_REPORTTYPE_USAGES_SEED;
6464:
6465: /*=========================================================================+
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',
6893: 'N') ,--ENABLED_FLAG
6894: fnd_global.user_id ,
6895: SYSDATE ,
6896: fnd_global.user_id ,