161: REPORTING_CODE_NUM_VALUE,
162: OBJECT_VERSION_NUMBER
163: )
164: SELECT
165: ZX_REPORT_CODES_ASSOC_S.nextval ,
166: 'ZX_TAXES' ,--ENTITY_CODE
167: TAX_ID ,--ENTITY_ID
168: l_reporting_type_id ,--REPORTING_TYPE_ID
169: NULL ,--REPORTING_CODE_ID
1229: LAST_UPDATE_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
1279: LAST_UPDATE_DATE,
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
1332: REPORTING_CODE_NUM_VALUE,
1333: OBJECT_VERSION_NUMBER
1334: )
1335: (SELECT
1336: ZX_REPORT_CODES_ASSOC_S.nextval ,
1337: 'ZX_RATES' ,--ENTITY_CODE
1338: rates.TAX_RATE_ID ,--ENTITY_ID
1339: report_codes.REPORTING_TYPE_ID ,
1340: report_codes.REPORTING_CODE_ID ,
1396: REPORTING_CODE_NUM_VALUE,
1397: OBJECT_VERSION_NUMBER
1398: )
1399: SELECT
1400: ZX_REPORT_CODES_ASSOC_S.nextval ,
1401: 'ZX_RATES' ,--ENTITY_CODE
1402: TAX_RATE_ID ,--ENTITY_ID
1403: REPORTING_TYPE_ID ,
1404: REPORTING_CODE_ID ,
1815: LAST_UPDATE_DATE,
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
1871: LAST_UPDATE_DATE,
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
1934: REPORTING_CODE_NUM_VALUE,
1935: OBJECT_VERSION_NUMBER
1936: )
1937: SELECT
1938: ZX_REPORT_CODES_ASSOC_S.nextval ,
1939: 'ZX_RATES' ,--ENTITY_CODE
1940: rates.TAX_RATE_ID ,--ENTITY_ID
1941: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
1942: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
2013: REPORTING_CODE_NUM_VALUE,
2014: OBJECT_VERSION_NUMBER
2015: )
2016: SELECT
2017: ZX_REPORT_CODES_ASSOC_S.nextval ,
2018: 'ZX_RATES' ,--ENTITY_CODE
2019: TAX_RATE_ID ,--ENTITY_ID
2020: REPORTING_TYPE_ID ,
2021: REPORTING_CODE_ID ,
2700: REPORTING_CODE_NUM_VALUE,
2701: OBJECT_VERSION_NUMBER
2702: )
2703: SELECT
2704: ZX_REPORT_CODES_ASSOC_S.nextval ,
2705: 'ZX_RATES' ,--ENTITY_CODE
2706: TAX_RATE_ID ,--ENTITY_ID
2707: REPORTING_TYPE_ID ,
2708: NULL ,--REPORTING_CODE_ID
2880: LAST_UPDATE_LOGIN ,
2881: OBJECT_VERSION_NUMBER
2882: )
2883: SELECT
2884: ZX_REPORT_CODES_ASSOC_S.nextval ,
2885: 'ZX_RATES' ,--ENTITY_CODE
2886: TAX_RATE_ID ,--ENTITY_ID
2887: REPORTING_TYPE_ID ,--REPORTING_TYPE_ID
2888: REPORTING_CODE_CHAR_VALUE ,--REPORTING_CODE_CHAR_VALUE
4026: REPORTING_CODE_NUM_VALUE,
4027: OBJECT_VERSION_NUMBER
4028: )
4029: SELECT
4030: ZX_REPORT_CODES_ASSOC_S.nextval ,
4031: 'ZX_RATES' ,--ENTITY_CODE
4032: TAX_RATE_ID ,--ENTITY_ID
4033: REPORTING_TYPE_ID ,
4034: REPORTING_CODE_ID ,
5761: REPORTING_CODE_NUM_VALUE,
5762: OBJECT_VERSION_NUMBER
5763: )
5764: SELECT
5765: ZX_REPORT_CODES_ASSOC_S.nextval ,
5766: 'ZX_RATES' ,--ENTITY_CODE
5767: TAX_RATE_ID ,--ENTITY_ID
5768: REPORTING_TYPE_ID ,
5769: REPORTING_CODE_ID ,
5920: LAST_UPDATE_DATE,
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
7343: REPORTING_CODE_NUM_VALUE,
7344: OBJECT_VERSION_NUMBER
7345: )
7346: SELECT
7347: ZX_REPORT_CODES_ASSOC_S.nextval ,
7348: 'ZX_RATES' ,--ENTITY_CODE
7349: rates.TAX_RATE_ID ,--ENTITY_ID
7350: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7351: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7415: REPORTING_CODE_NUM_VALUE,
7416: OBJECT_VERSION_NUMBER
7417: )
7418: SELECT
7419: ZX_REPORT_CODES_ASSOC_S.nextval ,
7420: 'ZX_RATES' ,--ENTITY_CODE
7421: rates.TAX_RATE_ID ,--ENTITY_ID
7422: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7423: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7768: REPORTING_CODE_NUM_VALUE,
7769: OBJECT_VERSION_NUMBER
7770: )
7771: SELECT
7772: ZX_REPORT_CODES_ASSOC_S.nextval ,
7773: 'ZX_RATES' ,--ENTITY_CODE
7774: rates.TAX_RATE_ID ,--ENTITY_ID
7775: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7776: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
8265: REPORTING_CODE_DATE_VALUE,
8266: REPORTING_CODE_NUM_VALUE,
8267: OBJECT_VERSION_NUMBER)
8268: SELECT
8269: ZX_REPORT_CODES_ASSOC_S.nextval,
8270: ''ZX_RATES'',
8271: TAX_RATE_ID,
8272: REPORTING_TYPE_ID,
8273: REPORTING_CODE_ID,
8333: REPORTING_CODE_DATE_VALUE,
8334: REPORTING_CODE_NUM_VALUE,
8335: OBJECT_VERSION_NUMBER)
8336: SELECT
8337: ZX_REPORT_CODES_ASSOC_S.nextval,
8338: ''ZX_RATES'',
8339: TAX_RATE_ID,
8340: REPORTING_TYPE_ID,
8341: REPORTING_CODE_ID,