[Home] [Help]
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',
459: 'N') ,--ENABLED_FLAG
460: fnd_global.user_id ,--CREATED_BY
461: SYSDATE ,--CREATION_DATE
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',
498: 'N') ,--ENABLED_FLAG
499: fnd_global.user_id ,--CREATED_BY
500: SYSDATE ,--CREATION_DATE
1230: LAST_UPDATE_LOGIN,
1231: OBJECT_VERSION_NUMBER)
1232: (SELECT
1233: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1234: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1235: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1236: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1237: pvs.GLOBAL_ATTRIBUTE18, --REPORTING_CODE_CHAR_VALUE
1238: null, --EXCEPTION_CODE
1246: 1
1247: FROM
1248: zx_reporting_types_b types,
1249: ap_supplier_sites pvs,
1250: zx_party_tax_profile ptp
1251:
1252: WHERE
1253:
1254: types.reporting_type_code = 'FISCAL PRINTER' and
1256: ptp.Party_Type_Code = 'THIRD_PARTY_SITE' AND -- Bug 4886324
1257: ptp.party_id = pvs.PARTY_SITE_ID
1258:
1259: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1260: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1261: and entity_id = ptp.Party_Tax_Profile_Id
1262: and reporting_type_id = types.reporting_type_id));
1263:
1264:
1280: LAST_UPDATE_LOGIN,
1281: OBJECT_VERSION_NUMBER)
1282: (SELECT
1283: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1284: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1285: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1286: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1287: pvs.GLOBAL_ATTRIBUTE19, --REPORTING_CODE_NUM_VALUE
1288: null, --EXCEPTION_CODE
1296: 1
1297: FROM
1298: zx_reporting_types_b types,
1299: ap_supplier_sites pvs ,
1300: zx_party_tax_profile ptp
1301:
1302: WHERE
1303: types.reporting_type_code = 'CAI NUMBER' and
1304: pvs.GLOBAL_ATTRIBUTE_CATEGORY='JL.AR.APXVDMVD.SUPPLIER_SITES' and
1304: pvs.GLOBAL_ATTRIBUTE_CATEGORY='JL.AR.APXVDMVD.SUPPLIER_SITES' and
1305: ptp.Party_Type_Code = 'THIRD_PARTY_SITE' AND -- Bug 4886324
1306: ptp.party_id = pvs.PARTY_SITE_ID
1307: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1308: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1309: and entity_id = ptp.Party_Tax_Profile_Id
1310: and reporting_type_id = types.reporting_type_id));
1311: */
1312:
1816: LAST_UPDATE_LOGIN,
1817: OBJECT_VERSION_NUMBER) -- Bug 5031787
1818: (SELECT
1819: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1820: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1821: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1822: codes.REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1823: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID
1824: null, --EXCEPTION_CODE
1837: financials_system_params_all fin_sys_param,
1838: zx_reporting_types_b types,
1839: zx_reporting_codes_b codes,
1840: xle_etb_profiles etb,
1841: zx_party_tax_profile ptp
1842:
1843: WHERE
1844: types.reporting_type_id = codes.reporting_type_id
1845: AND types.reporting_type_code = 'MEMBER STATE'
1848: AND ptp.party_id = etb.party_id
1849: AND ptp.Party_Type_Code = 'LEGAL_ESTABLISHMENT'
1850:
1851: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1852: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1853: and entity_id = ptp.Party_Tax_Profile_Id
1854: and reporting_type_id = types.reporting_type_id));
1855: ELSE
1856: INSERT INTO ZX_REPORT_CODES_ASSOC(
1872: LAST_UPDATE_LOGIN,
1873: OBJECT_VERSION_NUMBER) -- Bug 5031787
1874: (SELECT
1875: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1876: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1877: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1878: codes.REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1879: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID
1880: null, --EXCEPTION_CODE
1893: financials_system_params_all fin_sys_param,
1894: zx_reporting_types_b types,
1895: zx_reporting_codes_b codes,
1896: xle_etb_profiles etb,
1897: zx_party_tax_profile ptp
1898:
1899: WHERE
1900: types.reporting_type_id = codes.reporting_type_id
1901: AND types.reporting_type_code = 'MEMBER STATE'
1905: AND ptp.party_id = etb.party_id
1906: AND ptp.Party_Type_Code = 'LEGAL_ESTABLISHMENT'
1907:
1908: AND not exists(select 1 from ZX_REPORT_CODES_ASSOC
1909: where entity_code = 'ZX_PARTY_TAX_PROFILE'
1910: and entity_id = ptp.Party_Tax_Profile_Id
1911: and reporting_type_id = types.reporting_type_id));
1912: END IF;
1913:
5894: PROCEDURE ZX_CREATE_REP_ASSOCIATION_PTP
5895: (
5896:
5897: p_rep_type_info varchar2,
5898: p_ptp_id zx_party_tax_profile.party_tax_profile_id%type,
5899: p_reporting_type_code zx_reporting_types_b.reporting_type_code%type
5900: )
5901:
5902: IS
5921: LAST_UPDATE_LOGIN,
5922: OBJECT_VERSION_NUMBER)
5923: SELECT
5924: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
5925: 'ZX_PARTY_TAX_PROFILE' , --ENTITY_CODE
5926: p_ptp_id , --ENTITY_ID
5927: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
5928: p_rep_type_info, --REPORTING_CODE_CHAR_VALUE
5929: null, --EXCEPTION_CODE
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
6478: 120 ,--LAST_UPDATED_BY
6486: reporting_type_code IN ('FISCAL PRINTER','CAI NUMBER')
6487: AND record_type_code = 'SEEDED'
6488: AND NOT EXISTS ( select 1 from zx_report_types_usages
6489: where reporting_type_id = rep_type.reporting_type_id and
6490: entity_code = 'ZX_PARTY_TAX_PROFILE' );
6491:
6492: END CREATE_REPORTTYPE_USAGES_SEED;
6493:
6494: /*=========================================================================+
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',
6922: 'N') ,--ENABLED_FLAG
6923: fnd_global.user_id ,
6924: SYSDATE ,
6925: fnd_global.user_id ,