[Home] [Help]
649: FROM
650: ZX_REPORTING_TYPES_B TYPES,
651: ZX_REPORTING_CODES_B CODES,
652: FND_LOOKUP_VALUES lookups,
653: FND_LANGUAGES L
654: WHERE
655:
656: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
657: AND TYPES.REPORTING_TYPE_CODE = 'TW_GOVERNMENT_TAX_TYPE'
732: ELSE types.REPORTING_TYPE_CODE END REPORTING_TYPE_NAME -- Bug 4886324
733:
734: FROM
735: ZX_REPORTING_TYPES_B TYPES,
736: FND_LANGUAGES L
737: WHERE
738: TYPES.RECORD_TYPE_CODE = 'MIGRATED'
739: AND L.INSTALLED_FLAG in ('I', 'B')
740: ) TYPES
773: FROM
774: ZX_REPORTING_TYPES_B TYPES,
775: ZX_REPORTING_CODES_B CODES,
776: FND_LOOKUP_VALUES lookups,
777: FND_LANGUAGES L
778: WHERE
779:
780: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
781: AND TYPES.REPORTING_TYPE_CODE = 'AR_DGI_TRX_CODE'
828: SYSDATE ,
829: fnd_global.conc_login_id
830: FROM
831: ZX_REPORTING_CODES_B CODES,
832: FND_LANGUAGES L
833:
834: WHERE
835: CODES.RECORD_TYPE_CODE = 'MIGRATED'
836: AND L.INSTALLED_FLAG in ('I', 'B')
1141: FROM
1142: ZX_REPORTING_TYPES_B TYPES,
1143: ZX_REPORTING_CODES_B CODES,
1144: FND_LOOKUP_VALUES lookups,
1145: FND_LANGUAGES L
1146: WHERE
1147:
1148: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
1149: AND TYPES.REPORTING_TYPE_CODE = p_reporting_type_code
2637: codes.vat_tax_id = Nvl(rates.source_id,rates.tax_rate_id)
2638: AND rates.record_type_code = 'MIGRATED'
2639: AND report_types.tax_regime_code = rates.tax_regime_code
2640: AND codes.printed_tax_name = report_codes.REPORTING_CODE_CHAR_VALUE
2641: AND codes.LANGUAGE = (select nvl(language_code,'US') from FND_LANGUAGES where installed_flag = 'B' )
2642: AND report_types.reporting_type_id = report_codes.reporting_type_id
2643: AND report_types.REPORTING_TYPE_CODE= 'PRINTED_TAX_RATE_NAME'
2644: AND report_codes.record_type_code = 'MIGRATED'
2645:
4762: declare
4763: l_language_code varchar2(30);
4764: l_seqid number;
4765: begin
4766: select nvl(language_code,'US') into l_language_code from FND_LANGUAGES where installed_flag = 'B' ;
4767:
4768:
4769: for cursor_rec in
4770: (select vat_tax_id from ar_vat_tax_all_b )
5222: THEN 'Korean Business Locations'
5223: ELSE types.REPORTING_TYPE_CODE END REPORTING_TYPE_NAME -- Bug 4886324
5224: FROM
5225: ZX_REPORTING_TYPES_B TYPES,
5226: FND_LANGUAGES L
5227: WHERE
5228:
5229: TYPES.RECORD_TYPE_CODE = 'MIGRATED'
5230: AND L.INSTALLED_FLAG in ('I', 'B')
5377: FROM
5378: ZX_REPORTING_TYPES_B TYPES,
5379: ZX_REPORTING_CODES_B CODES,
5380: FND_LOOKUP_VALUES lookups,
5381: FND_LANGUAGES L
5382: WHERE
5383: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
5384: AND TYPES.REPORTING_TYPE_CODE = 'CL_TAX_CODE_CLASSIF'
5385: AND lookups.LOOKUP_TYPE = 'JLCL_TAX_CODE_CLASS'
5425: FROM
5426: ZX_REPORTING_TYPES_B TYPES,
5427: ZX_REPORTING_CODES_B CODES,
5428: FND_LOOKUP_VALUES lookups,
5429: FND_LANGUAGES L
5430: WHERE
5431: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
5432: AND TYPES.REPORTING_TYPE_CODE = 'AR_TURN_OVER_JUR_CODE'
5433: AND lookups.LOOKUP_TYPE = 'JLZZ_AR_TO_JURISDICTION_CODE'
5539: FROM
5540: ZX_REPORTING_TYPES_B TYPES,
5541: ZX_REPORTING_CODES_B CODES,
5542: FND_LOOKUP_VALUES lookups,
5543: FND_LANGUAGES L
5544: WHERE
5545:
5546: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
5547: AND TYPES.REPORTING_TYPE_CODE = 'KR_LOCATION'
6195: ELSE types.REPORTING_TYPE_CODE END REPORTING_TYPE_NAME
6196:
6197: FROM
6198: ZX_REPORTING_TYPES_B TYPES,
6199: FND_LANGUAGES L
6200: WHERE
6201: TYPES.RECORD_TYPE_CODE = 'SEEDED'
6202: AND L.INSTALLED_FLAG in ('I', 'B')
6203: ) TYPES
6339: FROM
6340: ZX_REPORTING_TYPES_B TYPES,
6341: ZX_REPORTING_CODES_B CODES,
6342: FND_LOOKUP_VALUES lookups,
6343: FND_LANGUAGES L
6344: WHERE
6345:
6346: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
6347: AND TYPES.REPORTING_TYPE_CODE = p_reporting_type_code
6602: SYSDATE ,
6603: 0
6604: FROM
6605: ZX_REPORTING_CODES_B CODES,
6606: FND_LANGUAGES L
6607: WHERE
6608: CODES.RECORD_TYPE_CODE = 'SEEDED'
6609: AND codes.reporting_type_id = ( SELECT reporting_type_id FROM ZX_REPORTING_TYPES_B
6610: WHERE REPORTING_TYPE_CODE = 'PT_LOCATION' AND record_type_code = 'SEEDED' )
6759: FROM
6760: ZX_REPORTING_TYPES_B TYPES,
6761: ZX_REPORTING_CODES_B CODES,
6762: FND_LOOKUP_VALUES lookups,
6763: FND_LANGUAGES L
6764: WHERE
6765:
6766: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
6767: AND TYPES.REPORTING_TYPE_CODE = 'TW_GOVERNMENT_TAX_TYPE'
7040: TYPES.REPORTING_TYPE_ID ,
7041: L.LANGUAGE_CODE
7042: FROM
7043: ZX_REPORTING_TYPES_B TYPES,
7044: FND_LANGUAGES L
7045: WHERE TYPES.RECORD_TYPE_CODE = 'MIGRATED'
7046: AND TYPES.REPORTING_TYPE_CODE = 'EMEA_VAT_REPORTING_TYPE'
7047: AND L.INSTALLED_FLAG in ('I', 'B')
7048: ) TYPES
7241: FROM
7242: ZX_REPORTING_TYPES_B TYPES,
7243: ZX_REPORTING_CODES_B CODES,
7244: FND_LOOKUP_VALUES lookups,
7245: FND_LANGUAGES L
7246: WHERE
7247:
7248: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
7249: AND TYPES.REPORTING_TYPE_CODE = 'EMEA_VAT_REPORTING_TYPE'
7553: TYPES.REPORTING_TYPE_ID ,
7554: L.LANGUAGE_CODE
7555: FROM
7556: ZX_REPORTING_TYPES_B TYPES,
7557: FND_LANGUAGES L
7558: WHERE TYPES.RECORD_TYPE_CODE = 'MIGRATED'
7559: AND TYPES.REPORTING_TYPE_CODE = 'REVERSE_CHARGE_VAT'
7560: AND L.INSTALLED_FLAG in ('I', 'B')
7561: ) TYPES
7697: FROM
7698: ZX_REPORTING_TYPES_B TYPES,
7699: ZX_REPORTING_CODES_B CODES,
7700: FND_LOOKUP_VALUES lookups,
7701: FND_LANGUAGES L
7702: WHERE
7703:
7704: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
7705: AND TYPES.REPORTING_TYPE_CODE = 'REVERSE_CHARGE_VAT'