563: 'N',
564: start_date_active,
565: NULL,
566: fnd.LOOKUP_CODE,
567: fnd_global.user_id,
568: SYSDATE,
569: fnd_global.user_id,
570: SYSDATE,
571: FND_GLOBAL.CONC_LOGIN_ID
565: NULL,
566: fnd.LOOKUP_CODE,
567: fnd_global.user_id,
568: SYSDATE,
569: fnd_global.user_id,
570: SYSDATE,
571: FND_GLOBAL.CONC_LOGIN_ID
572: FROM fnd_lookup_values fnd
573: WHERE lookup_type = l_lookup_type
567: fnd_global.user_id,
568: SYSDATE,
569: fnd_global.user_id,
570: SYSDATE,
571: FND_GLOBAL.CONC_LOGIN_ID
572: FROM fnd_lookup_values fnd
573: WHERE lookup_type = l_lookup_type
574: AND language=userenv('lang') -- Bug 6441455
575: AND enabled_flag = 'Y'
592: fnd.LANGUAGE,
593: fnd.source_lang,
594: fnd.Meaning,
595: SYSDATE,
596: fnd_global.user_id,
597: SYSDATE,
598: fnd_global.user_id,
599: FND_GLOBAL.CONC_LOGIN_ID
600: FROM fnd_lookup_values fnd, mtl_categories_b mtl
594: fnd.Meaning,
595: SYSDATE,
596: fnd_global.user_id,
597: SYSDATE,
598: fnd_global.user_id,
599: FND_GLOBAL.CONC_LOGIN_ID
600: FROM fnd_lookup_values fnd, mtl_categories_b mtl
601: WHERE lookup_type = l_lookup_type
602: AND FND.lookup_code = mtl.segment1
595: SYSDATE,
596: fnd_global.user_id,
597: SYSDATE,
598: fnd_global.user_id,
599: FND_GLOBAL.CONC_LOGIN_ID
600: FROM fnd_lookup_values fnd, mtl_categories_b mtl
601: WHERE lookup_type = l_lookup_type
602: AND FND.lookup_code = mtl.segment1
603: AND NOT EXISTS
705: 'STATISTICAL_CODE',
706: SYSDATE,
707: NULL,
708: 'MIGRATED',
709: fnd_global.user_id,
710: SYSDATE,
711: fnd_global.user_id,
712: SYSDATE,
713: FND_GLOBAL.CONC_LOGIN_ID,
707: NULL,
708: 'MIGRATED',
709: fnd_global.user_id,
710: SYSDATE,
711: fnd_global.user_id,
712: SYSDATE,
713: FND_GLOBAL.CONC_LOGIN_ID,
714: zx_fc_types_reg_assoc_s.nextval,
715: 1)
709: fnd_global.user_id,
710: SYSDATE,
711: fnd_global.user_id,
712: SYSDATE,
713: FND_GLOBAL.CONC_LOGIN_ID,
714: zx_fc_types_reg_assoc_s.nextval,
715: 1)
716: SELECT unique tax_regime_code
717: FROM ZX_RATES_B rates,
802: 'FISCAL CLASSIFICATION CODE',--parent_classification_code
803: l_fc_id, --parent_classification_id
804: 'BR',
805: 'MIGRATED',
806: fnd_global.user_id,
807: SYSDATE,
808: fnd_global.user_id,
809: SYSDATE,
810: FND_GLOBAL.CONC_LOGIN_ID,
804: 'BR',
805: 'MIGRATED',
806: fnd_global.user_id,
807: SYSDATE,
808: fnd_global.user_id,
809: SYSDATE,
810: FND_GLOBAL.CONC_LOGIN_ID,
811: 1
812: FROM
806: fnd_global.user_id,
807: SYSDATE,
808: fnd_global.user_id,
809: SYSDATE,
810: FND_GLOBAL.CONC_LOGIN_ID,
811: 1
812: FROM
813: FND_LOOKUPS lookups
814: WHERE
836: THEN Initcap(fc_name)
837: ELSE
838: fc_name
839: END,
840: fnd_global.user_id,
841: SYSDATE,
842: fnd_global.user_id,
843: SYSDATE,
844: FND_GLOBAL.CONC_LOGIN_ID,
838: fc_name
839: END,
840: fnd_global.user_id,
841: SYSDATE,
842: fnd_global.user_id,
843: SYSDATE,
844: FND_GLOBAL.CONC_LOGIN_ID,
845: LANGUAGE,
846: SOURCE_LANGUAGE)
840: fnd_global.user_id,
841: SYSDATE,
842: fnd_global.user_id,
843: SYSDATE,
844: FND_GLOBAL.CONC_LOGIN_ID,
845: LANGUAGE,
846: SOURCE_LANGUAGE)
847: INTO ZX_FC_CODES_DENORM_B(
848: CLASSIFICATION_TYPE_ID,
931: Null,
932: Null,
933: Null,
934: Null,
935: fnd_global.user_id,
936: SYSDATE,
937: fnd_global.user_id,
938: FND_GLOBAL.CONC_LOGIN_ID,
939: sysdate,
933: Null,
934: Null,
935: fnd_global.user_id,
936: SYSDATE,
937: fnd_global.user_id,
938: FND_GLOBAL.CONC_LOGIN_ID,
939: sysdate,
940: FND_GLOBAL.CONC_REQUEST_ID,
941: fnd_global.CONC_PROGRAM_ID,
934: Null,
935: fnd_global.user_id,
936: SYSDATE,
937: fnd_global.user_id,
938: FND_GLOBAL.CONC_LOGIN_ID,
939: sysdate,
940: FND_GLOBAL.CONC_REQUEST_ID,
941: fnd_global.CONC_PROGRAM_ID,
942: 235,
936: SYSDATE,
937: fnd_global.user_id,
938: FND_GLOBAL.CONC_LOGIN_ID,
939: sysdate,
940: FND_GLOBAL.CONC_REQUEST_ID,
941: fnd_global.CONC_PROGRAM_ID,
942: 235,
943: FND_GLOBAL.CONC_LOGIN_ID,
944: 'MIGRATED')
937: fnd_global.user_id,
938: FND_GLOBAL.CONC_LOGIN_ID,
939: sysdate,
940: FND_GLOBAL.CONC_REQUEST_ID,
941: fnd_global.CONC_PROGRAM_ID,
942: 235,
943: FND_GLOBAL.CONC_LOGIN_ID,
944: 'MIGRATED')
945:
939: sysdate,
940: FND_GLOBAL.CONC_REQUEST_ID,
941: fnd_global.CONC_PROGRAM_ID,
942: 235,
943: FND_GLOBAL.CONC_LOGIN_ID,
944: 'MIGRATED')
945:
946: SELECT
947: FL.LOOKUP_CODE fc_code,
1009: 'FISCAL_CLASSIFICATION',
1010: SYSDATE,
1011: NULL,
1012: 'MIGRATED',
1013: fnd_global.user_id,
1014: SYSDATE,
1015: fnd_global.user_id,
1016: SYSDATE,
1017: FND_GLOBAL.CONC_LOGIN_ID,
1011: NULL,
1012: 'MIGRATED',
1013: fnd_global.user_id,
1014: SYSDATE,
1015: fnd_global.user_id,
1016: SYSDATE,
1017: FND_GLOBAL.CONC_LOGIN_ID,
1018: zx_fc_types_reg_assoc_s.nextval,
1019: 1)
1013: fnd_global.user_id,
1014: SYSDATE,
1015: fnd_global.user_id,
1016: SYSDATE,
1017: FND_GLOBAL.CONC_LOGIN_ID,
1018: zx_fc_types_reg_assoc_s.nextval,
1019: 1)
1020: SELECT
1021: unique tax_regime_code
1132: null,----parent_classification_code
1133: null,----parent_classification_id
1134: 'BR',
1135: 'MIGRATED',
1136: fnd_global.user_id,
1137: SYSDATE,
1138: fnd_global.user_id,
1139: SYSDATE,
1140: FND_GLOBAL.CONC_LOGIN_ID,
1134: 'BR',
1135: 'MIGRATED',
1136: fnd_global.user_id,
1137: SYSDATE,
1138: fnd_global.user_id,
1139: SYSDATE,
1140: FND_GLOBAL.CONC_LOGIN_ID,
1141: 1
1142: FROM JL_BR_AP_OPERATIONS JLBR
1136: fnd_global.user_id,
1137: SYSDATE,
1138: fnd_global.user_id,
1139: SYSDATE,
1140: FND_GLOBAL.CONC_LOGIN_ID,
1141: 1
1142: FROM JL_BR_AP_OPERATIONS JLBR
1143: WHERE NOT EXISTS
1144: -- this condition makes sure we dont duplicate data
1165: THEN Initcap(Meaning)
1166: ELSE
1167: Meaning
1168: END,
1169: fnd_global.user_id,
1170: SYSDATE,
1171: fnd_global.user_id,
1172: SYSDATE,
1173: FND_GLOBAL.CONC_LOGIN_ID,
1167: Meaning
1168: END,
1169: fnd_global.user_id,
1170: SYSDATE,
1171: fnd_global.user_id,
1172: SYSDATE,
1173: FND_GLOBAL.CONC_LOGIN_ID,
1174: lang_code,
1175: userenv('LANG'))
1169: fnd_global.user_id,
1170: SYSDATE,
1171: fnd_global.user_id,
1172: SYSDATE,
1173: FND_GLOBAL.CONC_LOGIN_ID,
1174: lang_code,
1175: userenv('LANG'))
1176: INTO ZX_FC_CODES_DENORM_B(
1177: CLASSIFICATION_TYPE_ID,
1260: Null,
1261: Null,
1262: Null,
1263: Null,
1264: fnd_global.user_id,
1265: SYSDATE,
1266: fnd_global.user_id,
1267: FND_GLOBAL.CONC_LOGIN_ID,
1268: sysdate,
1262: Null,
1263: Null,
1264: fnd_global.user_id,
1265: SYSDATE,
1266: fnd_global.user_id,
1267: FND_GLOBAL.CONC_LOGIN_ID,
1268: sysdate,
1269: FND_GLOBAL.CONC_REQUEST_ID,
1270: fnd_global.CONC_PROGRAM_ID,
1263: Null,
1264: fnd_global.user_id,
1265: SYSDATE,
1266: fnd_global.user_id,
1267: FND_GLOBAL.CONC_LOGIN_ID,
1268: sysdate,
1269: FND_GLOBAL.CONC_REQUEST_ID,
1270: fnd_global.CONC_PROGRAM_ID,
1271: 235,
1265: SYSDATE,
1266: fnd_global.user_id,
1267: FND_GLOBAL.CONC_LOGIN_ID,
1268: sysdate,
1269: FND_GLOBAL.CONC_REQUEST_ID,
1270: fnd_global.CONC_PROGRAM_ID,
1271: 235,
1272: FND_GLOBAL.CONC_LOGIN_ID,
1273: 'MIGRATED')
1266: fnd_global.user_id,
1267: FND_GLOBAL.CONC_LOGIN_ID,
1268: sysdate,
1269: FND_GLOBAL.CONC_REQUEST_ID,
1270: fnd_global.CONC_PROGRAM_ID,
1271: 235,
1272: FND_GLOBAL.CONC_LOGIN_ID,
1273: 'MIGRATED')
1274: SELECT cfo_code Code,
1268: sysdate,
1269: FND_GLOBAL.CONC_REQUEST_ID,
1270: fnd_global.CONC_PROGRAM_ID,
1271: 235,
1272: FND_GLOBAL.CONC_LOGIN_ID,
1273: 'MIGRATED')
1274: SELECT cfo_code Code,
1275: cfo_description Meaning,
1276: JLBR.creation_date ,
1340: fc.classification_code,--parent_classification_code
1341: fc.classification_id, --parent_classification_id
1342: 'BR',
1343: 'MIGRATED',
1344: fnd_global.user_id,
1345: SYSDATE,
1346: fnd_global.user_id,
1347: SYSDATE,
1348: FND_GLOBAL.CONC_LOGIN_ID,
1342: 'BR',
1343: 'MIGRATED',
1344: fnd_global.user_id,
1345: SYSDATE,
1346: fnd_global.user_id,
1347: SYSDATE,
1348: FND_GLOBAL.CONC_LOGIN_ID,
1349: 1
1350: FROM
1344: fnd_global.user_id,
1345: SYSDATE,
1346: fnd_global.user_id,
1347: SYSDATE,
1348: FND_GLOBAL.CONC_LOGIN_ID,
1349: 1
1350: FROM
1351: JL_BR_AP_OPERATIONS ap_op,
1352: ZX_FC_CODES_DENORM_B fc,
1381: THEN Initcap(Meaning)
1382: ELSE
1383: Meaning
1384: END,
1385: fnd_global.user_id,
1386: SYSDATE,
1387: fnd_global.user_id,
1388: SYSDATE,
1389: FND_GLOBAL.CONC_LOGIN_ID,
1383: Meaning
1384: END,
1385: fnd_global.user_id,
1386: SYSDATE,
1387: fnd_global.user_id,
1388: SYSDATE,
1389: FND_GLOBAL.CONC_LOGIN_ID,
1390: lang_code,
1391: userenv('LANG'))
1385: fnd_global.user_id,
1386: SYSDATE,
1387: fnd_global.user_id,
1388: SYSDATE,
1389: FND_GLOBAL.CONC_LOGIN_ID,
1390: lang_code,
1391: userenv('LANG'))
1392: INTO ZX_FC_CODES_DENORM_B(
1393: CLASSIFICATION_TYPE_ID,
1476: Null,
1477: Null,
1478: Null,
1479: Null,
1480: fnd_global.user_id,
1481: SYSDATE,
1482: fnd_global.user_id,
1483: FND_GLOBAL.CONC_LOGIN_ID,
1484: sysdate,
1478: Null,
1479: Null,
1480: fnd_global.user_id,
1481: SYSDATE,
1482: fnd_global.user_id,
1483: FND_GLOBAL.CONC_LOGIN_ID,
1484: sysdate,
1485: FND_GLOBAL.CONC_REQUEST_ID,
1486: fnd_global.CONC_PROGRAM_ID,
1479: Null,
1480: fnd_global.user_id,
1481: SYSDATE,
1482: fnd_global.user_id,
1483: FND_GLOBAL.CONC_LOGIN_ID,
1484: sysdate,
1485: FND_GLOBAL.CONC_REQUEST_ID,
1486: fnd_global.CONC_PROGRAM_ID,
1487: 235,
1481: SYSDATE,
1482: fnd_global.user_id,
1483: FND_GLOBAL.CONC_LOGIN_ID,
1484: sysdate,
1485: FND_GLOBAL.CONC_REQUEST_ID,
1486: fnd_global.CONC_PROGRAM_ID,
1487: 235,
1488: FND_GLOBAL.CONC_LOGIN_ID,
1489: 'MIGRATED')
1482: fnd_global.user_id,
1483: FND_GLOBAL.CONC_LOGIN_ID,
1484: sysdate,
1485: FND_GLOBAL.CONC_REQUEST_ID,
1486: fnd_global.CONC_PROGRAM_ID,
1487: 235,
1488: FND_GLOBAL.CONC_LOGIN_ID,
1489: 'MIGRATED')
1490:
1484: sysdate,
1485: FND_GLOBAL.CONC_REQUEST_ID,
1486: fnd_global.CONC_PROGRAM_ID,
1487: 235,
1488: FND_GLOBAL.CONC_LOGIN_ID,
1489: 'MIGRATED')
1490:
1491: SELECT cfo_code Code,
1492: cfo_description Meaning,
1588: 'GUI TYPE', --parent_classification_code
1589: l_fc_id, --parent_classification_id
1590: 'TW',
1591: 'MIGRATED',
1592: fnd_global.user_id,
1593: SYSDATE,
1594: fnd_global.user_id,
1595: SYSDATE,
1596: FND_GLOBAL.CONC_LOGIN_ID,
1590: 'TW',
1591: 'MIGRATED',
1592: fnd_global.user_id,
1593: SYSDATE,
1594: fnd_global.user_id,
1595: SYSDATE,
1596: FND_GLOBAL.CONC_LOGIN_ID,
1597: 1
1598:
1592: fnd_global.user_id,
1593: SYSDATE,
1594: fnd_global.user_id,
1595: SYSDATE,
1596: FND_GLOBAL.CONC_LOGIN_ID,
1597: 1
1598:
1599: FROM FND_LOOKUP_VALUES lookups
1600: WHERE
1625: THEN Initcap(Meaning)
1626: ELSE
1627: Meaning
1628: END,
1629: fnd_global.user_id,
1630: SYSDATE,
1631: fnd_global.user_id,
1632: SYSDATE,
1633: FND_GLOBAL.CONC_LOGIN_ID,
1627: Meaning
1628: END,
1629: fnd_global.user_id,
1630: SYSDATE,
1631: fnd_global.user_id,
1632: SYSDATE,
1633: FND_GLOBAL.CONC_LOGIN_ID,
1634: language,
1635: source_lang)
1629: fnd_global.user_id,
1630: SYSDATE,
1631: fnd_global.user_id,
1632: SYSDATE,
1633: FND_GLOBAL.CONC_LOGIN_ID,
1634: language,
1635: source_lang)
1636:
1637: INTO ZX_FC_CODES_DENORM_B
1721: Null,
1722: Null,
1723: Null,
1724: Null,
1725: fnd_global.user_id,
1726: SYSDATE,
1727: fnd_global.user_id,
1728: FND_GLOBAL.CONC_LOGIN_ID,
1729: sysdate,
1723: Null,
1724: Null,
1725: fnd_global.user_id,
1726: SYSDATE,
1727: fnd_global.user_id,
1728: FND_GLOBAL.CONC_LOGIN_ID,
1729: sysdate,
1730: FND_GLOBAL.CONC_REQUEST_ID,
1731: fnd_global.CONC_PROGRAM_ID,
1724: Null,
1725: fnd_global.user_id,
1726: SYSDATE,
1727: fnd_global.user_id,
1728: FND_GLOBAL.CONC_LOGIN_ID,
1729: sysdate,
1730: FND_GLOBAL.CONC_REQUEST_ID,
1731: fnd_global.CONC_PROGRAM_ID,
1732: 235,
1726: SYSDATE,
1727: fnd_global.user_id,
1728: FND_GLOBAL.CONC_LOGIN_ID,
1729: sysdate,
1730: FND_GLOBAL.CONC_REQUEST_ID,
1731: fnd_global.CONC_PROGRAM_ID,
1732: 235,
1733: FND_GLOBAL.CONC_LOGIN_ID,
1734: 'MIGRATED')
1727: fnd_global.user_id,
1728: FND_GLOBAL.CONC_LOGIN_ID,
1729: sysdate,
1730: FND_GLOBAL.CONC_REQUEST_ID,
1731: fnd_global.CONC_PROGRAM_ID,
1732: 235,
1733: FND_GLOBAL.CONC_LOGIN_ID,
1734: 'MIGRATED')
1735: SELECT
1729: sysdate,
1730: FND_GLOBAL.CONC_REQUEST_ID,
1731: fnd_global.CONC_PROGRAM_ID,
1732: 235,
1733: FND_GLOBAL.CONC_LOGIN_ID,
1734: 'MIGRATED')
1735: SELECT
1736: lookup_code,
1737: meaning,
1868: Null,
1869: Null,
1870: 'MIGRATED',
1871: zx_fc_country_defaults_s.nextval,
1872: fnd_global.user_id,
1873: SYSDATE,
1874: fnd_global.user_id,
1875: SYSDATE,
1876: FND_GLOBAL.CONC_LOGIN_ID,
1870: 'MIGRATED',
1871: zx_fc_country_defaults_s.nextval,
1872: fnd_global.user_id,
1873: SYSDATE,
1874: fnd_global.user_id,
1875: SYSDATE,
1876: FND_GLOBAL.CONC_LOGIN_ID,
1877: 1
1878: FROM ZX_FC_TYPES_B
1872: fnd_global.user_id,
1873: SYSDATE,
1874: fnd_global.user_id,
1875: SYSDATE,
1876: FND_GLOBAL.CONC_LOGIN_ID,
1877: 1
1878: FROM ZX_FC_TYPES_B
1879: WHERE
1880: classification_type_code = 'STATISTICAL_CODE'
1908: Null,
1909: Null,
1910: 'MIGRATED',
1911: zx_fc_country_defaults_s.nextval,
1912: fnd_global.user_id,
1913: SYSDATE,
1914: fnd_global.user_id,
1915: SYSDATE,
1916: FND_GLOBAL.CONC_LOGIN_ID,
1910: 'MIGRATED',
1911: zx_fc_country_defaults_s.nextval,
1912: fnd_global.user_id,
1913: SYSDATE,
1914: fnd_global.user_id,
1915: SYSDATE,
1916: FND_GLOBAL.CONC_LOGIN_ID,
1917: 1
1918: FROM ZX_FC_TYPES_B
1912: fnd_global.user_id,
1913: SYSDATE,
1914: fnd_global.user_id,
1915: SYSDATE,
1916: FND_GLOBAL.CONC_LOGIN_ID,
1917: 1
1918: FROM ZX_FC_TYPES_B
1919: WHERE
1920: classification_type_code = 'STATISTICAL_CODE'
1948: Null,
1949: Null,
1950: 'MIGRATED',
1951: zx_fc_country_defaults_s.nextval,
1952: fnd_global.user_id,
1953: SYSDATE,
1954: fnd_global.user_id,
1955: SYSDATE,
1956: FND_GLOBAL.CONC_LOGIN_ID,
1950: 'MIGRATED',
1951: zx_fc_country_defaults_s.nextval,
1952: fnd_global.user_id,
1953: SYSDATE,
1954: fnd_global.user_id,
1955: SYSDATE,
1956: FND_GLOBAL.CONC_LOGIN_ID,
1957: 1
1958: FROM ZX_FC_TYPES_B
1952: fnd_global.user_id,
1953: SYSDATE,
1954: fnd_global.user_id,
1955: SYSDATE,
1956: FND_GLOBAL.CONC_LOGIN_ID,
1957: 1
1958: FROM ZX_FC_TYPES_B
1959: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1960: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1987: Null,
1988: Null,
1989: 'MIGRATED',
1990: zx_fc_country_defaults_s.nextval,
1991: fnd_global.user_id,
1992: SYSDATE,
1993: fnd_global.user_id,
1994: SYSDATE,
1995: FND_GLOBAL.CONC_LOGIN_ID,
1989: 'MIGRATED',
1990: zx_fc_country_defaults_s.nextval,
1991: fnd_global.user_id,
1992: SYSDATE,
1993: fnd_global.user_id,
1994: SYSDATE,
1995: FND_GLOBAL.CONC_LOGIN_ID,
1996: 1
1997: FROM ZX_FC_TYPES_B
1991: fnd_global.user_id,
1992: SYSDATE,
1993: fnd_global.user_id,
1994: SYSDATE,
1995: FND_GLOBAL.CONC_LOGIN_ID,
1996: 1
1997: FROM ZX_FC_TYPES_B
1998: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1999: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
2023: Null,
2024: Null,
2025: 'MIGRATED',
2026: zx_fc_country_defaults_s.nextval,
2027: fnd_global.user_id,
2028: SYSDATE,
2029: fnd_global.user_id,
2030: SYSDATE,
2031: FND_GLOBAL.CONC_LOGIN_ID,
2025: 'MIGRATED',
2026: zx_fc_country_defaults_s.nextval,
2027: fnd_global.user_id,
2028: SYSDATE,
2029: fnd_global.user_id,
2030: SYSDATE,
2031: FND_GLOBAL.CONC_LOGIN_ID,
2032: 1
2033: FROM ZX_FC_TYPES_B
2027: fnd_global.user_id,
2028: SYSDATE,
2029: fnd_global.user_id,
2030: SYSDATE,
2031: FND_GLOBAL.CONC_LOGIN_ID,
2032: 1
2033: FROM ZX_FC_TYPES_B
2034: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
2035: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
2099: p_country_code,
2100: 'SEEDED',
2101: 120,
2102: SYSDATE,
2103: fnd_global.user_id,
2104: SYSDATE,
2105: FND_GLOBAL.CONC_LOGIN_ID,
2106: 1
2107: FROM DUAL
2101: 120,
2102: SYSDATE,
2103: fnd_global.user_id,
2104: SYSDATE,
2105: FND_GLOBAL.CONC_LOGIN_ID,
2106: 1
2107: FROM DUAL
2108: WHERE NOT EXISTS
2109: (select NULL from ZX_FC_CODES_B Codes where
2129: THEN Initcap(p_classification_name)
2130: ELSE
2131: p_classification_name
2132: END,
2133: fnd_global.user_id,
2134: SYSDATE,
2135: fnd_global.user_id,
2136: SYSDATE,
2137: FND_GLOBAL.CONC_LOGIN_ID,
2131: p_classification_name
2132: END,
2133: fnd_global.user_id,
2134: SYSDATE,
2135: fnd_global.user_id,
2136: SYSDATE,
2137: FND_GLOBAL.CONC_LOGIN_ID,
2138: lang_code,
2139: userenv('LANG'))
2133: fnd_global.user_id,
2134: SYSDATE,
2135: fnd_global.user_id,
2136: SYSDATE,
2137: FND_GLOBAL.CONC_LOGIN_ID,
2138: lang_code,
2139: userenv('LANG'))
2140: INTO ZX_FC_CODES_DENORM_B
2141: (CLASSIFICATION_TYPE_ID,
2226: Null,
2227: Null,
2228: 120,
2229: SYSDATE,
2230: fnd_global.user_id,
2231: FND_GLOBAL.CONC_LOGIN_ID,
2232: sysdate,
2233: FND_GLOBAL.CONC_REQUEST_ID,
2234: fnd_global.CONC_PROGRAM_ID,
2227: Null,
2228: 120,
2229: SYSDATE,
2230: fnd_global.user_id,
2231: FND_GLOBAL.CONC_LOGIN_ID,
2232: sysdate,
2233: FND_GLOBAL.CONC_REQUEST_ID,
2234: fnd_global.CONC_PROGRAM_ID,
2235: 235,
2229: SYSDATE,
2230: fnd_global.user_id,
2231: FND_GLOBAL.CONC_LOGIN_ID,
2232: sysdate,
2233: FND_GLOBAL.CONC_REQUEST_ID,
2234: fnd_global.CONC_PROGRAM_ID,
2235: 235,
2236: FND_GLOBAL.CONC_LOGIN_ID,
2237: 'SEEDED')
2230: fnd_global.user_id,
2231: FND_GLOBAL.CONC_LOGIN_ID,
2232: sysdate,
2233: FND_GLOBAL.CONC_REQUEST_ID,
2234: fnd_global.CONC_PROGRAM_ID,
2235: 235,
2236: FND_GLOBAL.CONC_LOGIN_ID,
2237: 'SEEDED')
2238: select
2232: sysdate,
2233: FND_GLOBAL.CONC_REQUEST_ID,
2234: fnd_global.CONC_PROGRAM_ID,
2235: 235,
2236: FND_GLOBAL.CONC_LOGIN_ID,
2237: 'SEEDED')
2238: select
2239: language_code lang_code, fc_codes.classification_id
2240: from
2324: p_ancestor_code,----parent_classification_code
2325: p_parent_fc_id,-----parent_classification_id
2326: p_country_code,
2327: 'MIGRATED',
2328: fnd_global.user_id,
2329: SYSDATE,
2330: fnd_global.user_id,
2331: SYSDATE,
2332: FND_GLOBAL.CONC_LOGIN_ID,
2326: p_country_code,
2327: 'MIGRATED',
2328: fnd_global.user_id,
2329: SYSDATE,
2330: fnd_global.user_id,
2331: SYSDATE,
2332: FND_GLOBAL.CONC_LOGIN_ID,
2333: 1
2334: FROM FND_LOOKUP_VALUES lookups
2328: fnd_global.user_id,
2329: SYSDATE,
2330: fnd_global.user_id,
2331: SYSDATE,
2332: FND_GLOBAL.CONC_LOGIN_ID,
2333: 1
2334: FROM FND_LOOKUP_VALUES lookups
2335: WHERE
2336: lookups.lookup_type=p_lookup_type
2360: THEN Initcap(Meaning)
2361: ELSE
2362: Meaning
2363: END,
2364: fnd_global.user_id,
2365: SYSDATE,
2366: fnd_global.user_id,
2367: SYSDATE,
2368: FND_GLOBAL.CONC_LOGIN_ID,
2362: Meaning
2363: END,
2364: fnd_global.user_id,
2365: SYSDATE,
2366: fnd_global.user_id,
2367: SYSDATE,
2368: FND_GLOBAL.CONC_LOGIN_ID,
2369: language,
2370: SOURCE_LANG)
2364: fnd_global.user_id,
2365: SYSDATE,
2366: fnd_global.user_id,
2367: SYSDATE,
2368: FND_GLOBAL.CONC_LOGIN_ID,
2369: language,
2370: SOURCE_LANG)
2371: INTO ZX_FC_CODES_DENORM_B(
2372: CLASSIFICATION_TYPE_ID,
2459: Null,
2460: Null,
2461: Null,
2462: Null,
2463: fnd_global.user_id,
2464: SYSDATE,
2465: fnd_global.user_id,
2466: FND_GLOBAL.CONC_LOGIN_ID,
2467: sysdate,
2461: Null,
2462: Null,
2463: fnd_global.user_id,
2464: SYSDATE,
2465: fnd_global.user_id,
2466: FND_GLOBAL.CONC_LOGIN_ID,
2467: sysdate,
2468: FND_GLOBAL.CONC_REQUEST_ID,
2469: fnd_global.CONC_PROGRAM_ID,
2462: Null,
2463: fnd_global.user_id,
2464: SYSDATE,
2465: fnd_global.user_id,
2466: FND_GLOBAL.CONC_LOGIN_ID,
2467: sysdate,
2468: FND_GLOBAL.CONC_REQUEST_ID,
2469: fnd_global.CONC_PROGRAM_ID,
2470: 235,
2464: SYSDATE,
2465: fnd_global.user_id,
2466: FND_GLOBAL.CONC_LOGIN_ID,
2467: sysdate,
2468: FND_GLOBAL.CONC_REQUEST_ID,
2469: fnd_global.CONC_PROGRAM_ID,
2470: 235,
2471: FND_GLOBAL.CONC_LOGIN_ID,
2472: 'MIGRATED')
2465: fnd_global.user_id,
2466: FND_GLOBAL.CONC_LOGIN_ID,
2467: sysdate,
2468: FND_GLOBAL.CONC_REQUEST_ID,
2469: fnd_global.CONC_PROGRAM_ID,
2470: 235,
2471: FND_GLOBAL.CONC_LOGIN_ID,
2472: 'MIGRATED')
2473: SELECT lookup_code,
2467: sysdate,
2468: FND_GLOBAL.CONC_REQUEST_ID,
2469: fnd_global.CONC_PROGRAM_ID,
2470: 235,
2471: FND_GLOBAL.CONC_LOGIN_ID,
2472: 'MIGRATED')
2473: SELECT lookup_code,
2474: Meaning,
2475: Language,
2576: fc.classification_code ,---parent_classification_code
2577: fc.classification_id, ---parent_classification_id
2578: p_country_code,
2579: p_record_type_code,
2580: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2581: SYSDATE,
2582: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2583: SYSDATE,
2584: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2578: p_country_code,
2579: p_record_type_code,
2580: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2581: SYSDATE,
2582: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2583: SYSDATE,
2584: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2585: 1
2586: FROM
2580: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2581: SYSDATE,
2582: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2583: SYSDATE,
2584: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2585: 1
2586: FROM
2587: ZX_FC_CODES_DENORM_B fc,
2588: ZX_EVENT_CLASSES_VL event,
2622: THEN Initcap(Meaning)
2623: ELSE
2624: Meaning
2625: END,
2626: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2627: SYSDATE,
2628: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2629: SYSDATE,
2630: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2624: Meaning
2625: END,
2626: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2627: SYSDATE,
2628: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2629: SYSDATE,
2630: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2631: language,
2632: SOURCE_LANG)
2626: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2627: SYSDATE,
2628: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2629: SYSDATE,
2630: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2631: language,
2632: SOURCE_LANG)
2633: INTO ZX_FC_CODES_DENORM_B(
2634: CLASSIFICATION_TYPE_ID,
2717: Null,
2718: Null,
2719: Null,
2720: Null,
2721: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2722: SYSDATE,
2723: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2724: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2725: sysdate,
2719: Null,
2720: Null,
2721: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2722: SYSDATE,
2723: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2724: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2725: sysdate,
2726: FND_GLOBAL.CONC_REQUEST_ID,
2727: fnd_global.CONC_PROGRAM_ID,
2720: Null,
2721: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2722: SYSDATE,
2723: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2724: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2725: sysdate,
2726: FND_GLOBAL.CONC_REQUEST_ID,
2727: fnd_global.CONC_PROGRAM_ID,
2728: 235,
2722: SYSDATE,
2723: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2724: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2725: sysdate,
2726: FND_GLOBAL.CONC_REQUEST_ID,
2727: fnd_global.CONC_PROGRAM_ID,
2728: 235,
2729: FND_GLOBAL.CONC_LOGIN_ID,
2730: p_record_type_code)
2723: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2724: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2725: sysdate,
2726: FND_GLOBAL.CONC_REQUEST_ID,
2727: fnd_global.CONC_PROGRAM_ID,
2728: 235,
2729: FND_GLOBAL.CONC_LOGIN_ID,
2730: p_record_type_code)
2731: SELECT
2725: sysdate,
2726: FND_GLOBAL.CONC_REQUEST_ID,
2727: fnd_global.CONC_PROGRAM_ID,
2728: 235,
2729: FND_GLOBAL.CONC_LOGIN_ID,
2730: p_record_type_code)
2731: SELECT
2732: lookup_code,
2733: meaning,
2834: p_country_code, --country_code
2835: 'SEEDED', --record_type_code
2836: 120,
2837: sysdate,
2838: fnd_global.user_id,
2839: sysdate,
2840: fnd_global.conc_login_id,
2841: 1
2842: FROM
2836: 120,
2837: sysdate,
2838: fnd_global.user_id,
2839: sysdate,
2840: fnd_global.conc_login_id,
2841: 1
2842: FROM
2843: ZX_FC_CODES_B fc,
2844: ZX_EVENT_CLASSES_B event
2872: THEN Initcap(p_classification_name)
2873: ELSE
2874: p_classification_name
2875: END,
2876: fnd_global.user_id,
2877: sysdate,
2878: fnd_global.user_id,
2879: sysdate,
2880: fnd_global.conc_login_id,
2874: p_classification_name
2875: END,
2876: fnd_global.user_id,
2877: sysdate,
2878: fnd_global.user_id,
2879: sysdate,
2880: fnd_global.conc_login_id,
2881: lang_code,
2882: userenv('LANG'))
2876: fnd_global.user_id,
2877: sysdate,
2878: fnd_global.user_id,
2879: sysdate,
2880: fnd_global.conc_login_id,
2881: lang_code,
2882: userenv('LANG'))
2883:
2884: INTO ZX_FC_CODES_DENORM_B(
2972: Null,
2973: Null,
2974: 120,
2975: sysdate,
2976: fnd_global.user_id,
2977: fnd_global.conc_login_id,
2978: sysdate,
2979: fnd_global.conc_request_id,
2980: fnd_global.conc_program_id,
2973: Null,
2974: 120,
2975: sysdate,
2976: fnd_global.user_id,
2977: fnd_global.conc_login_id,
2978: sysdate,
2979: fnd_global.conc_request_id,
2980: fnd_global.conc_program_id,
2981: 235,
2975: sysdate,
2976: fnd_global.user_id,
2977: fnd_global.conc_login_id,
2978: sysdate,
2979: fnd_global.conc_request_id,
2980: fnd_global.conc_program_id,
2981: 235,
2982: fnd_global.conc_login_id,
2983: 'SEEDED')
2976: fnd_global.user_id,
2977: fnd_global.conc_login_id,
2978: sysdate,
2979: fnd_global.conc_request_id,
2980: fnd_global.conc_program_id,
2981: 235,
2982: fnd_global.conc_login_id,
2983: 'SEEDED')
2984: SELECT
2978: sysdate,
2979: fnd_global.conc_request_id,
2980: fnd_global.conc_program_id,
2981: 235,
2982: fnd_global.conc_login_id,
2983: 'SEEDED')
2984: SELECT
2985: event.tax_event_class_code,
2986: event.tax_event_class_name name,
3046: 'STATISTICAL CODE',
3047: SYSDATE,
3048: NULL,
3049: 'MIGRATED',
3050: fnd_global.user_id,
3051: SYSDATE,
3052: fnd_global.user_id,
3053: SYSDATE,
3054: FND_GLOBAL.CONC_LOGIN_ID,
3048: NULL,
3049: 'MIGRATED',
3050: fnd_global.user_id,
3051: SYSDATE,
3052: fnd_global.user_id,
3053: SYSDATE,
3054: FND_GLOBAL.CONC_LOGIN_ID,
3055: zx_fc_types_reg_assoc_s.nextval,
3056: 1)
3050: fnd_global.user_id,
3051: SYSDATE,
3052: fnd_global.user_id,
3053: SYSDATE,
3054: FND_GLOBAL.CONC_LOGIN_ID,
3055: zx_fc_types_reg_assoc_s.nextval,
3056: 1)
3057: Select unique
3058: tax_regime_code
3114: p_owner_id_num,
3115: 1,
3116: 400,
3117: 'MIGRATED',
3118: fnd_global.user_id,
3119: SYSDATE,
3120: fnd_global.user_id,
3121: SYSDATE,
3122: FND_GLOBAL.CONC_LOGIN_ID,
3116: 400,
3117: 'MIGRATED',
3118: fnd_global.user_id,
3119: SYSDATE,
3120: fnd_global.user_id,
3121: SYSDATE,
3122: FND_GLOBAL.CONC_LOGIN_ID,
3123: 1
3124: FROM dual
3118: fnd_global.user_id,
3119: SYSDATE,
3120: fnd_global.user_id,
3121: SYSDATE,
3122: FND_GLOBAL.CONC_LOGIN_ID,
3123: 1
3124: FROM dual
3125: WHERE NOT EXISTS
3126: (SELECT null from ZX_FC_TYPES_B
3146: THEN Initcap(p_classification_type_name)
3147: ELSE
3148: p_classification_type_name
3149: END,
3150: fnd_global.user_id,
3151: SYSDATE,
3152: fnd_global.user_id,
3153: SYSDATE,
3154: FND_GLOBAL.CONC_LOGIN_ID,
3148: p_classification_type_name
3149: END,
3150: fnd_global.user_id,
3151: SYSDATE,
3152: fnd_global.user_id,
3153: SYSDATE,
3154: FND_GLOBAL.CONC_LOGIN_ID,
3155: language_code,
3156: userenv('LANG')
3150: fnd_global.user_id,
3151: SYSDATE,
3152: fnd_global.user_id,
3153: SYSDATE,
3154: FND_GLOBAL.CONC_LOGIN_ID,
3155: language_code,
3156: userenv('LANG')
3157:
3158: FROM FND_LANGUAGES L,
3210: 'Y', --INTERNAL_FLAG
3211: 'N', --RECORD_ONLY_FLAG
3212: NULL,
3213: SYSDATE,
3214: FND_GLOBAL.USER_ID,
3215: SYSDATE,
3216: FND_GLOBAL.USER_ID,
3217: FND_GLOBAL.CONC_LOGIN_ID,
3218: 1
3212: NULL,
3213: SYSDATE,
3214: FND_GLOBAL.USER_ID,
3215: SYSDATE,
3216: FND_GLOBAL.USER_ID,
3217: FND_GLOBAL.CONC_LOGIN_ID,
3218: 1
3219: FROM dual
3220: WHERE NOT EXISTS
3213: SYSDATE,
3214: FND_GLOBAL.USER_ID,
3215: SYSDATE,
3216: FND_GLOBAL.USER_ID,
3217: FND_GLOBAL.CONC_LOGIN_ID,
3218: 1
3219: FROM dual
3220: WHERE NOT EXISTS
3221: (SELECT null from ZX_DETERMINING_FACTORS_B
3241: p_classification_type_name
3242: END,
3243: NULL,
3244: SYSDATE,
3245: FND_GLOBAL.USER_ID,
3246: SYSDATE,
3247: FND_GLOBAL.USER_ID,
3248: FND_GLOBAL.CONC_LOGIN_ID,
3249: detFactors.DETERMINING_FACTOR_ID,
3243: NULL,
3244: SYSDATE,
3245: FND_GLOBAL.USER_ID,
3246: SYSDATE,
3247: FND_GLOBAL.USER_ID,
3248: FND_GLOBAL.CONC_LOGIN_ID,
3249: detFactors.DETERMINING_FACTOR_ID,
3250: L.LANGUAGE_CODE,
3251: userenv('LANG')
3244: SYSDATE,
3245: FND_GLOBAL.USER_ID,
3246: SYSDATE,
3247: FND_GLOBAL.USER_ID,
3248: FND_GLOBAL.CONC_LOGIN_ID,
3249: detFactors.DETERMINING_FACTOR_ID,
3250: L.LANGUAGE_CODE,
3251: userenv('LANG')
3252:
3308: p_tca_class,
3309: NULL,
3310: NULL,
3311: 'MIGRATED',
3312: fnd_global.user_id,
3313: SYSDATE,
3314: fnd_global.user_id,
3315: SYSDATE,
3316: FND_GLOBAL.CONC_LOGIN_ID,
3310: NULL,
3311: 'MIGRATED',
3312: fnd_global.user_id,
3313: SYSDATE,
3314: fnd_global.user_id,
3315: SYSDATE,
3316: FND_GLOBAL.CONC_LOGIN_ID,
3317: 1
3318: FROM dual
3312: fnd_global.user_id,
3313: SYSDATE,
3314: fnd_global.user_id,
3315: SYSDATE,
3316: FND_GLOBAL.CONC_LOGIN_ID,
3317: 1
3318: FROM dual
3319: WHERE NOT EXISTS
3320: (SELECT null from ZX_FC_TYPES_B
3340: THEN Initcap(p_classification_type_name)
3341: ELSE
3342: p_classification_type_name
3343: END,
3344: fnd_global.user_id,
3345: SYSDATE,
3346: fnd_global.user_id,
3347: SYSDATE,
3348: FND_GLOBAL.CONC_LOGIN_ID,
3342: p_classification_type_name
3343: END,
3344: fnd_global.user_id,
3345: SYSDATE,
3346: fnd_global.user_id,
3347: SYSDATE,
3348: FND_GLOBAL.CONC_LOGIN_ID,
3349: language_code,
3350: userenv('LANG')
3344: fnd_global.user_id,
3345: SYSDATE,
3346: fnd_global.user_id,
3347: SYSDATE,
3348: FND_GLOBAL.CONC_LOGIN_ID,
3349: language_code,
3350: userenv('LANG')
3351:
3352: FROM FND_LANGUAGES L,
3404: 'Y', --INTERNAL_FLAG
3405: 'N', --RECORD_ONLY_FLAG
3406: NULL,
3407: SYSDATE,
3408: FND_GLOBAL.USER_ID,
3409: SYSDATE,
3410: FND_GLOBAL.USER_ID,
3411: FND_GLOBAL.CONC_LOGIN_ID,
3412: 1
3406: NULL,
3407: SYSDATE,
3408: FND_GLOBAL.USER_ID,
3409: SYSDATE,
3410: FND_GLOBAL.USER_ID,
3411: FND_GLOBAL.CONC_LOGIN_ID,
3412: 1
3413: FROM dual
3414: WHERE NOT EXISTS
3407: SYSDATE,
3408: FND_GLOBAL.USER_ID,
3409: SYSDATE,
3410: FND_GLOBAL.USER_ID,
3411: FND_GLOBAL.CONC_LOGIN_ID,
3412: 1
3413: FROM dual
3414: WHERE NOT EXISTS
3415: (SELECT null from ZX_DETERMINING_FACTORS_B
3435: p_classification_type_name
3436: END,
3437: NULL,
3438: SYSDATE,
3439: FND_GLOBAL.USER_ID,
3440: SYSDATE,
3441: FND_GLOBAL.USER_ID,
3442: FND_GLOBAL.CONC_LOGIN_ID,
3443: detFactors.DETERMINING_FACTOR_ID,
3437: NULL,
3438: SYSDATE,
3439: FND_GLOBAL.USER_ID,
3440: SYSDATE,
3441: FND_GLOBAL.USER_ID,
3442: FND_GLOBAL.CONC_LOGIN_ID,
3443: detFactors.DETERMINING_FACTOR_ID,
3444: L.LANGUAGE_CODE,
3445: userenv('LANG')
3438: SYSDATE,
3439: FND_GLOBAL.USER_ID,
3440: SYSDATE,
3441: FND_GLOBAL.USER_ID,
3442: FND_GLOBAL.CONC_LOGIN_ID,
3443: detFactors.DETERMINING_FACTOR_ID,
3444: L.LANGUAGE_CODE,
3445: userenv('LANG')
3446: FROM FND_LANGUAGES L,
3499: owner_id_num = l_category_set,
3500: start_position = 1,
3501: num_characters = 400,
3502: last_update_date = sysdate,
3503: last_updated_by = fnd_global.user_id,
3504: object_version_number = object_version_number + 1
3505: WHERE
3506: classification_type_code = 'INTENDED_USE' and
3507: classification_type_categ_code = 'INTENDED_USE_CLASSIFICATION';
3546: 'STATISTICAL_CODE',
3547: SYSDATE,
3548: NULL,
3549: 'MIGRATED',
3550: fnd_global.user_id,
3551: SYSDATE,
3552: fnd_global.user_id,
3553: SYSDATE,
3554: FND_GLOBAL.CONC_LOGIN_ID,
3548: NULL,
3549: 'MIGRATED',
3550: fnd_global.user_id,
3551: SYSDATE,
3552: fnd_global.user_id,
3553: SYSDATE,
3554: FND_GLOBAL.CONC_LOGIN_ID,
3555: zx_fc_types_reg_assoc_s.NEXTVAL,
3556: 1)
3550: fnd_global.user_id,
3551: SYSDATE,
3552: fnd_global.user_id,
3553: SYSDATE,
3554: FND_GLOBAL.CONC_LOGIN_ID,
3555: zx_fc_types_reg_assoc_s.NEXTVAL,
3556: 1)
3557: SELECT
3558: unique tax_regime_code
3632: 'DEDUCTION TAX RULE',--parent_classification_code
3633: l_fc_id,--parent_classification_id
3634: 'FR',
3635: 'MIGRATED',
3636: fnd_global.user_id,
3637: SYSDATE,
3638: fnd_global.user_id,
3639: SYSDATE,
3640: FND_GLOBAL.CONC_LOGIN_ID,
3634: 'FR',
3635: 'MIGRATED',
3636: fnd_global.user_id,
3637: SYSDATE,
3638: fnd_global.user_id,
3639: SYSDATE,
3640: FND_GLOBAL.CONC_LOGIN_ID,
3641: 1
3642: FROM
3636: fnd_global.user_id,
3637: SYSDATE,
3638: fnd_global.user_id,
3639: SYSDATE,
3640: FND_GLOBAL.CONC_LOGIN_ID,
3641: 1
3642: FROM
3643: FND_FLEX_VALUES V,
3644: fnd_flex_value_sets vs
3670: THEN Initcap(flex_value)
3671: ELSE
3672: flex_value
3673: END,
3674: fnd_global.user_id,
3675: SYSDATE,
3676: fnd_global.user_id,
3677: SYSDATE,
3678: FND_GLOBAL.CONC_LOGIN_ID,
3672: flex_value
3673: END,
3674: fnd_global.user_id,
3675: SYSDATE,
3676: fnd_global.user_id,
3677: SYSDATE,
3678: FND_GLOBAL.CONC_LOGIN_ID,
3679: lang_code,
3680: userenv('LANG'))
3674: fnd_global.user_id,
3675: SYSDATE,
3676: fnd_global.user_id,
3677: SYSDATE,
3678: FND_GLOBAL.CONC_LOGIN_ID,
3679: lang_code,
3680: userenv('LANG'))
3681: INTO ZX_FC_CODES_DENORM_B
3682: (CLASSIFICATION_TYPE_ID,
3765: Null,
3766: Null,
3767: Null,
3768: Null,
3769: fnd_global.user_id,
3770: SYSDATE,
3771: fnd_global.user_id,
3772: FND_GLOBAL.CONC_LOGIN_ID,
3773: sysdate,
3767: Null,
3768: Null,
3769: fnd_global.user_id,
3770: SYSDATE,
3771: fnd_global.user_id,
3772: FND_GLOBAL.CONC_LOGIN_ID,
3773: sysdate,
3774: FND_GLOBAL.CONC_REQUEST_ID,
3775: fnd_global.CONC_PROGRAM_ID,
3768: Null,
3769: fnd_global.user_id,
3770: SYSDATE,
3771: fnd_global.user_id,
3772: FND_GLOBAL.CONC_LOGIN_ID,
3773: sysdate,
3774: FND_GLOBAL.CONC_REQUEST_ID,
3775: fnd_global.CONC_PROGRAM_ID,
3776: 235,
3770: SYSDATE,
3771: fnd_global.user_id,
3772: FND_GLOBAL.CONC_LOGIN_ID,
3773: sysdate,
3774: FND_GLOBAL.CONC_REQUEST_ID,
3775: fnd_global.CONC_PROGRAM_ID,
3776: 235,
3777: FND_GLOBAL.CONC_LOGIN_ID,
3778: 'MIGRATED')
3771: fnd_global.user_id,
3772: FND_GLOBAL.CONC_LOGIN_ID,
3773: sysdate,
3774: FND_GLOBAL.CONC_REQUEST_ID,
3775: fnd_global.CONC_PROGRAM_ID,
3776: 235,
3777: FND_GLOBAL.CONC_LOGIN_ID,
3778: 'MIGRATED')
3779: SELECT
3773: sysdate,
3774: FND_GLOBAL.CONC_REQUEST_ID,
3775: fnd_global.CONC_PROGRAM_ID,
3776: 235,
3777: FND_GLOBAL.CONC_LOGIN_ID,
3778: 'MIGRATED')
3779: SELECT
3780: flex_value,
3781: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')) start_date_active,
3858: 'DOCUMENT TYPE',--parent_classification_code
3859: l_fc_id, --parent_classification_id
3860: 'CL',
3861: 'MIGRATED',
3862: fnd_global.user_id,
3863: SYSDATE,
3864: fnd_global.user_id,
3865: SYSDATE,
3866: FND_GLOBAL.CONC_LOGIN_ID,
3860: 'CL',
3861: 'MIGRATED',
3862: fnd_global.user_id,
3863: SYSDATE,
3864: fnd_global.user_id,
3865: SYSDATE,
3866: FND_GLOBAL.CONC_LOGIN_ID,
3867: 1
3868:
3862: fnd_global.user_id,
3863: SYSDATE,
3864: fnd_global.user_id,
3865: SYSDATE,
3866: FND_GLOBAL.CONC_LOGIN_ID,
3867: 1
3868:
3869: FROM FND_LOOKUPS lookups
3870: WHERE
3891: SOURCE_LANG)
3892: VALUES
3893: (classification_id,
3894: meaning,
3895: fnd_global.user_id,
3896: SYSDATE,
3897: fnd_global.user_id,
3898: SYSDATE,
3899: FND_GLOBAL.CONC_LOGIN_ID,
3893: (classification_id,
3894: meaning,
3895: fnd_global.user_id,
3896: SYSDATE,
3897: fnd_global.user_id,
3898: SYSDATE,
3899: FND_GLOBAL.CONC_LOGIN_ID,
3900: language,
3901: source_lang)
3895: fnd_global.user_id,
3896: SYSDATE,
3897: fnd_global.user_id,
3898: SYSDATE,
3899: FND_GLOBAL.CONC_LOGIN_ID,
3900: language,
3901: source_lang)
3902:
3903: INTO ZX_FC_CODES_DENORM_B
3988: Null,
3989: Null,
3990: Null,
3991: Null,
3992: fnd_global.user_id,
3993: SYSDATE,
3994: fnd_global.user_id,
3995: FND_GLOBAL.CONC_LOGIN_ID,
3996: sysdate,
3990: Null,
3991: Null,
3992: fnd_global.user_id,
3993: SYSDATE,
3994: fnd_global.user_id,
3995: FND_GLOBAL.CONC_LOGIN_ID,
3996: sysdate,
3997: FND_GLOBAL.CONC_REQUEST_ID,
3998: fnd_global.CONC_PROGRAM_ID,
3991: Null,
3992: fnd_global.user_id,
3993: SYSDATE,
3994: fnd_global.user_id,
3995: FND_GLOBAL.CONC_LOGIN_ID,
3996: sysdate,
3997: FND_GLOBAL.CONC_REQUEST_ID,
3998: fnd_global.CONC_PROGRAM_ID,
3999: 235,
3993: SYSDATE,
3994: fnd_global.user_id,
3995: FND_GLOBAL.CONC_LOGIN_ID,
3996: sysdate,
3997: FND_GLOBAL.CONC_REQUEST_ID,
3998: fnd_global.CONC_PROGRAM_ID,
3999: 235,
4000: FND_GLOBAL.CONC_LOGIN_ID,
4001: 'MIGRATED')
3994: fnd_global.user_id,
3995: FND_GLOBAL.CONC_LOGIN_ID,
3996: sysdate,
3997: FND_GLOBAL.CONC_REQUEST_ID,
3998: fnd_global.CONC_PROGRAM_ID,
3999: 235,
4000: FND_GLOBAL.CONC_LOGIN_ID,
4001: 'MIGRATED')
4002: SELECT
3996: sysdate,
3997: FND_GLOBAL.CONC_REQUEST_ID,
3998: fnd_global.CONC_PROGRAM_ID,
3999: 235,
4000: FND_GLOBAL.CONC_LOGIN_ID,
4001: 'MIGRATED')
4002: SELECT
4003: lookup_code,
4004: meaning,
4102: 'FISCAL_CLASSIFICATION',
4103: SYSDATE,
4104: NULL,
4105: 'MIGRATED',
4106: fnd_global.user_id,
4107: SYSDATE,
4108: fnd_global.user_id,
4109: SYSDATE,
4110: FND_GLOBAL.CONC_LOGIN_ID,
4104: NULL,
4105: 'MIGRATED',
4106: fnd_global.user_id,
4107: SYSDATE,
4108: fnd_global.user_id,
4109: SYSDATE,
4110: FND_GLOBAL.CONC_LOGIN_ID,
4111: zx_fc_types_reg_assoc_s.NEXTVAL,
4112: 1)
4106: fnd_global.user_id,
4107: SYSDATE,
4108: fnd_global.user_id,
4109: SYSDATE,
4110: FND_GLOBAL.CONC_LOGIN_ID,
4111: zx_fc_types_reg_assoc_s.NEXTVAL,
4112: 1)
4113:
4114: SELECT unique
4157: event.tax_event_class_code, --parent_classification_code
4158: fc.classification_id, --parent_classification_id
4159: NULL, --country_code is null to share AR,BR,CO country
4160: 'MIGRATED', --record_type_code
4161: fnd_global.user_id,
4162: sysdate,
4163: fnd_global.user_id,
4164: sysdate,
4165: fnd_global.conc_login_id,
4159: NULL, --country_code is null to share AR,BR,CO country
4160: 'MIGRATED', --record_type_code
4161: fnd_global.user_id,
4162: sysdate,
4163: fnd_global.user_id,
4164: sysdate,
4165: fnd_global.conc_login_id,
4166: 1
4167:
4161: fnd_global.user_id,
4162: sysdate,
4163: fnd_global.user_id,
4164: sysdate,
4165: fnd_global.conc_login_id,
4166: 1
4167:
4168: FROM
4169:
4209: THEN Initcap(fc_name)
4210: ELSE
4211: fc_name
4212: END,
4213: fnd_global.user_id,
4214: sysdate,
4215: fnd_global.user_id,
4216: sysdate,
4217: fnd_global.conc_login_id,
4211: fc_name
4212: END,
4213: fnd_global.user_id,
4214: sysdate,
4215: fnd_global.user_id,
4216: sysdate,
4217: fnd_global.conc_login_id,
4218: LANGUAGE,
4219: SOURCE_LANGUAGE)
4213: fnd_global.user_id,
4214: sysdate,
4215: fnd_global.user_id,
4216: sysdate,
4217: fnd_global.conc_login_id,
4218: LANGUAGE,
4219: SOURCE_LANGUAGE)
4220:
4221: INTO ZX_FC_CODES_DENORM_B(
4306: Null,
4307: Null,
4308: Null,
4309: Null,
4310: fnd_global.user_id,
4311: sysdate,
4312: fnd_global.user_id,
4313: fnd_global.conc_login_id,
4314: sysdate,
4308: Null,
4309: Null,
4310: fnd_global.user_id,
4311: sysdate,
4312: fnd_global.user_id,
4313: fnd_global.conc_login_id,
4314: sysdate,
4315: fnd_global.conc_request_id,
4316: fnd_global.conc_program_id,
4309: Null,
4310: fnd_global.user_id,
4311: sysdate,
4312: fnd_global.user_id,
4313: fnd_global.conc_login_id,
4314: sysdate,
4315: fnd_global.conc_request_id,
4316: fnd_global.conc_program_id,
4317: 235,
4311: sysdate,
4312: fnd_global.user_id,
4313: fnd_global.conc_login_id,
4314: sysdate,
4315: fnd_global.conc_request_id,
4316: fnd_global.conc_program_id,
4317: 235,
4318: fnd_global.conc_login_id,
4319: 'MIGRATED')
4312: fnd_global.user_id,
4313: fnd_global.conc_login_id,
4314: sysdate,
4315: fnd_global.conc_request_id,
4316: fnd_global.conc_program_id,
4317: 235,
4318: fnd_global.conc_login_id,
4319: 'MIGRATED')
4320: SELECT
4314: sysdate,
4315: fnd_global.conc_request_id,
4316: fnd_global.conc_program_id,
4317: 235,
4318: fnd_global.conc_login_id,
4319: 'MIGRATED')
4320: SELECT
4321: codes.fc_code,
4322: codes.fc_name,
4672: 'LEASE_MGT_PROD_FISC_CLASS',
4673: SYSDATE,
4674: NULL,
4675: 'MIGRATED',
4676: fnd_global.user_id,
4677: SYSDATE,
4678: fnd_global.user_id,
4679: SYSDATE,
4680: FND_GLOBAL.CONC_LOGIN_ID,
4674: NULL,
4675: 'MIGRATED',
4676: fnd_global.user_id,
4677: SYSDATE,
4678: fnd_global.user_id,
4679: SYSDATE,
4680: FND_GLOBAL.CONC_LOGIN_ID,
4681: zx_fc_types_reg_assoc_s.nextval,
4682: 1)
4676: fnd_global.user_id,
4677: SYSDATE,
4678: fnd_global.user_id,
4679: SYSDATE,
4680: FND_GLOBAL.CONC_LOGIN_ID,
4681: zx_fc_types_reg_assoc_s.nextval,
4682: 1)
4683: SELECT unique rates.tax_regime_code
4684: FROM ZX_RATES_B rates,
4814: null,----parent_classification_code
4815: null,----parent_classification_id
4816: null,
4817: 'MIGRATED',
4818: fnd_global.user_id,
4819: SYSDATE,
4820: fnd_global.user_id,
4821: SYSDATE,
4822: FND_GLOBAL.CONC_LOGIN_ID,
4816: null,
4817: 'MIGRATED',
4818: fnd_global.user_id,
4819: SYSDATE,
4820: fnd_global.user_id,
4821: SYSDATE,
4822: FND_GLOBAL.CONC_LOGIN_ID,
4823: 1
4824: FROM FND_LOOKUP_VALUES lookups
4818: fnd_global.user_id,
4819: SYSDATE,
4820: fnd_global.user_id,
4821: SYSDATE,
4822: FND_GLOBAL.CONC_LOGIN_ID,
4823: 1
4824: FROM FND_LOOKUP_VALUES lookups
4825: WHERE lookups.lookup_type='AR_TAX_TRX_BUSINESS_CATEGORY'
4826: AND LANGUAGE = userenv('LANG')
4848: THEN Initcap(Meaning)
4849: ELSE
4850: Meaning
4851: END,
4852: fnd_global.user_id,
4853: SYSDATE,
4854: fnd_global.user_id,
4855: SYSDATE,
4856: FND_GLOBAL.CONC_LOGIN_ID,
4850: Meaning
4851: END,
4852: fnd_global.user_id,
4853: SYSDATE,
4854: fnd_global.user_id,
4855: SYSDATE,
4856: FND_GLOBAL.CONC_LOGIN_ID,
4857: language,
4858: source_lang)
4852: fnd_global.user_id,
4853: SYSDATE,
4854: fnd_global.user_id,
4855: SYSDATE,
4856: FND_GLOBAL.CONC_LOGIN_ID,
4857: language,
4858: source_lang)
4859: INTO ZX_FC_CODES_DENORM_B(
4860: CLASSIFICATION_TYPE_ID,
4943: Null,
4944: Null,
4945: Null,
4946: Null,
4947: fnd_global.user_id,
4948: SYSDATE,
4949: fnd_global.user_id,
4950: FND_GLOBAL.CONC_LOGIN_ID,
4951: sysdate,
4945: Null,
4946: Null,
4947: fnd_global.user_id,
4948: SYSDATE,
4949: fnd_global.user_id,
4950: FND_GLOBAL.CONC_LOGIN_ID,
4951: sysdate,
4952: FND_GLOBAL.CONC_REQUEST_ID,
4953: fnd_global.CONC_PROGRAM_ID,
4946: Null,
4947: fnd_global.user_id,
4948: SYSDATE,
4949: fnd_global.user_id,
4950: FND_GLOBAL.CONC_LOGIN_ID,
4951: sysdate,
4952: FND_GLOBAL.CONC_REQUEST_ID,
4953: fnd_global.CONC_PROGRAM_ID,
4954: 235,
4948: SYSDATE,
4949: fnd_global.user_id,
4950: FND_GLOBAL.CONC_LOGIN_ID,
4951: sysdate,
4952: FND_GLOBAL.CONC_REQUEST_ID,
4953: fnd_global.CONC_PROGRAM_ID,
4954: 235,
4955: FND_GLOBAL.CONC_LOGIN_ID,
4956: 'MIGRATED')
4949: fnd_global.user_id,
4950: FND_GLOBAL.CONC_LOGIN_ID,
4951: sysdate,
4952: FND_GLOBAL.CONC_REQUEST_ID,
4953: fnd_global.CONC_PROGRAM_ID,
4954: 235,
4955: FND_GLOBAL.CONC_LOGIN_ID,
4956: 'MIGRATED')
4957: SELECT
4951: sysdate,
4952: FND_GLOBAL.CONC_REQUEST_ID,
4953: fnd_global.CONC_PROGRAM_ID,
4954: 235,
4955: FND_GLOBAL.CONC_LOGIN_ID,
4956: 'MIGRATED')
4957: SELECT
4958: lookup_code,
4959: meaning,