eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_FINREPORTS_INT

Line 1187: UPDATE HZ_IMP_FINREPORTS_INT

1183: AND party_orig_system_reference = l_posr(i);
1184:
1185: --Update Financial Reports
1186: FORALL i in l_posr.FIRST..l_posr.LAST
1187: UPDATE HZ_IMP_FINREPORTS_INT
1188: SET interface_status = 'D'
1189: WHERE batch_id = p_batch_id AND Nvl(party_id,l_pid(i)) = l_pid(i)
1190: AND party_orig_system = l_pos(i)
1191: AND party_orig_system_reference = l_posr(i);

Line 1334: update HZ_IMP_FINREPORTS_INT

1330: where BATCH_ID = P_BATCH_ID
1331: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM
1332: and INTERFACE_STATUS = 'C';
1333:
1334: update HZ_IMP_FINREPORTS_INT
1335: set error_id = null,
1336: interface_status = null
1337: where BATCH_ID = P_BATCH_ID
1338: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM

Line 1452: update HZ_IMP_FINREPORTS_INT

1448: and batch_id = P_BATCH_ID
1449: and stage = 3
1450: and status = 'C');
1451:
1452: update HZ_IMP_FINREPORTS_INT
1453: set error_id = null, interface_status = null
1454: where batch_id = P_BATCH_ID
1455: and party_orig_system = P_ORIG_SYSTEM
1456: and interface_status = 'C'

Line 1673: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1669: into hz_imp_errors (
1670: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1671: token1_name, token1_value, token2_name, token2_value)
1672: values (
1673: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1674: 'HZ_API_DATE_GREATER', 'DATE2', 'REPORT_END_DATE', 'DATE1',
1675: 'REPORT_START_DATE')
1676: when (E2_FLAG is null) then
1677: into hz_imp_errors (

Line 1681: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1677: into hz_imp_errors (
1678: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1679: token1_name, token1_value, token2_name, token2_value)
1680: values (
1681: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1682: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'AUDIT_IND', 'LOOKUP_TYPE', 'YES/NO')
1683: when (E3_FLAG is null) then
1684: into hz_imp_errors (
1685: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 1688: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1684: into hz_imp_errors (
1685: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1686: token1_name, token1_value, token2_name, token2_value)
1687: values (
1688: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1689: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CONSOLIDATED_IND',
1690: 'LOOKUP_TYPE', 'YES/NO')
1691: when (E4_FLAG is null) then
1692: into hz_imp_errors (

Line 1696: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1692: into hz_imp_errors (
1693: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1694: token1_name, token1_value, token2_name, token2_value)
1695: values (
1696: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1697: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'ESTIMATED_IND', 'LOOKUP_TYPE',
1698: 'YES/NO')
1699: when (E5_FLAG is null) then
1700: into hz_imp_errors (

Line 1704: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1700: into hz_imp_errors (
1701: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1702: token1_name, token1_value, token2_name, token2_value)
1703: values (
1704: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1705: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FINAL_IND', 'LOOKUP_TYPE', 'YES/NO')
1706: when (E6_FLAG is null) then
1707: into hz_imp_errors (
1708: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 1711: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1707: into hz_imp_errors (
1708: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1709: token1_name, token1_value, token2_name, token2_value)
1710: values (
1711: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1712: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FISCAL_IND', 'LOOKUP_TYPE', 'YES/NO')
1713: when (E7_FLAG is null) then
1714: into hz_imp_errors (
1715: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 1718: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1714: into hz_imp_errors (
1715: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1716: token1_name, token1_value, token2_name, token2_value)
1717: values (
1718: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1719: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FORECAST_IND', 'LOOKUP_TYPE',
1720: 'YES/NO')
1721: when (E8_FLAG is null) then
1722: into hz_imp_errors (

Line 1726: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1722: into hz_imp_errors (
1723: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1724: token1_name, token1_value, token2_name, token2_value)
1725: values (
1726: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1727: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'OPENING_IND', 'LOOKUP_TYPE',
1728: 'YES/NO')
1729: when (E9_FLAG is null) then
1730: into hz_imp_errors (

Line 1734: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1730: into hz_imp_errors (
1731: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1732: token1_name, token1_value, token2_name, token2_value)
1733: values (
1734: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1735: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'PROFORMA_IND', 'LOOKUP_TYPE',
1736: 'YES/NO')
1737: when (E10_FLAG is null) then
1738: into hz_imp_errors (

Line 1742: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1738: into hz_imp_errors (
1739: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1740: token1_name, token1_value, token2_name, token2_value)
1741: values (
1742: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1743: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'QUALIFIED_IND', 'LOOKUP_TYPE',
1744: 'YES/NO')
1745: when (E11_FLAG is null) then
1746: into hz_imp_errors (

Line 1750: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1746: into hz_imp_errors (
1747: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1748: token1_name, token1_value, token2_name, token2_value)
1749: values (
1750: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1751: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'RESTATED_IND', 'LOOKUP_TYPE',
1752: 'YES/NO')
1753: when (E12_FLAG is null) then
1754: into hz_imp_errors (

Line 1758: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1754: into hz_imp_errors (
1755: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1756: token1_name, token1_value, token2_name, token2_value)
1757: values (
1758: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1759: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'SIGNED_BY_PRINCIPALS_IND',
1760: 'LOOKUP_TYPE', 'YES/NO')
1761: when (E13_FLAG is null) then
1762: into hz_imp_errors (

Line 1766: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1762: into hz_imp_errors (
1763: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1764: token1_name, token1_value, token2_name, token2_value)
1765: values (
1766: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1767: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'TRIAL_BALANCE_IND',
1768: 'LOOKUP_TYPE', 'YES/NO')
1769:
1770: when (E14_FLAG is null) then

Line 1775: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1771: into hz_imp_errors (
1772: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1773: token1_name, token1_value, token2_name, token2_value)
1774: values (
1775: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1776: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'UNBALANCED_IND', 'LOOKUP_TYPE',
1777: 'YES/NO')
1778: when (E15_FLAG is null) then
1779: into hz_imp_errors (

Line 1783: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1779: into hz_imp_errors (
1780: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1781: token1_name, token1_value, token2_name, token2_value)
1782: values (
1783: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1784: 'HZ_API_INVALID_COMBINATION2', 'COLUMN1', 'issued_period', 'COLUMN2',
1785: 'report_start_date')
1786: when (E16_FLAG is null) then
1787: into hz_imp_errors (

Line 1791: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1787: into hz_imp_errors (
1788: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1789: token1_name, token1_value, token2_name, token2_value)
1790: values (
1791: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1792: 'HZ_API_INVALID_COMBINATION3', 'COLUMN1', 'report_start_date', 'COLUMN2',
1793: 'report_end_date')
1794: when (E17_FLAG is null) then
1795: into hz_imp_errors (

Line 1799: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1795: into hz_imp_errors (
1796: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1797: token1_name, token1_value, token2_name, token2_value)
1798: values (
1799: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1800: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
1801: 'HZ_CREATED_BY_MODULES')
1802: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
1803: into hz_imp_errors (

Line 1807: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1803: into hz_imp_errors (
1804: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1805: token1_name, token1_value, token2_name, token2_value)
1806: values (
1807: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1808: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_FINANCIAL_REPORTS_U1', 'ENTITY',
1809: 'HZ_FINANCIAL_REPORTS')
1810: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
1811: into hz_imp_errors (

Line 1815: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1811: into hz_imp_errors (
1812: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1813: token1_name, token1_value, token2_name, token2_value)
1814: values (
1815: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1816: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_FINANCIAL_REPORTS_U2', 'ENTITY',
1817: 'HZ_FINANCIAL_REPORTS')
1818: when (ACTION_MISMATCH_FLAG is null) then
1819: into hz_imp_errors (

Line 1822: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1818: when (ACTION_MISMATCH_FLAG is null) then
1819: into hz_imp_errors (
1820: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1821: values (
1822: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1823: 'HZ_IMP_ACTION_MISMATCH')
1824: when (MISSING_PARENT_FLAG is null) then
1825: into hz_imp_errors (
1826: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)

Line 1828: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

1824: when (MISSING_PARENT_FLAG is null) then
1825: into hz_imp_errors (
1826: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1827: values (
1828: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1829: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')
1830: select /*+ leading(e) use_nl(int) rowid(int) */ e.creation_date, e.created_by, e.last_update_date, e.last_updated_by, e.last_update_login, e.program_application_id,
1831: e.program_id, e.program_update_date, e.error_id, e.batch_id, e.request_id, e.interface_table_name, E1_FLAG, E2_FLAG,
1832: E3_FLAG, E4_FLAG, E5_FLAG, E6_FLAG, E7_FLAG, E8_FLAG, E9_FLAG,

Line 1838: HZ_IMP_FINREPORTS_INT int

1834: E17_FLAG,
1835: DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG,
1836: INT.REPORT_START_DATE, INT.REPORT_END_DATE
1837: from hz_imp_tmp_errors e,
1838: HZ_IMP_FINREPORTS_INT int
1839: where e.batch_id = P_BATCH_ID
1840: and e.request_id = P_REQUEST_ID
1841: and e.int_row_id = int.rowid
1842: and e.interface_table_name = 'HZ_IMP_FINREPORTS_INT';

Line 1842: and e.interface_table_name = 'HZ_IMP_FINREPORTS_INT';

1838: HZ_IMP_FINREPORTS_INT int
1839: where e.batch_id = P_BATCH_ID
1840: and e.request_id = P_REQUEST_ID
1841: and e.int_row_id = int.rowid
1842: and e.interface_table_name = 'HZ_IMP_FINREPORTS_INT';
1843:
1844: insert all
1845: when (E1_FLAG is null) then
1846: into hz_imp_errors (

Line 3270: update hz_imp_finreports_int

3266: where rowid = l_row_id(i)
3267: and l_table_name(i) = 'HZ_IMP_ADDRESSUSES_INT';
3268:
3269: ForAll i in 1..l_row_id.count
3270: update hz_imp_finreports_int
3271: set interface_status = 'E',
3272: error_id = l_error_id(i)
3273: where rowid = l_row_id(i)
3274: and l_table_name(i) = 'HZ_IMP_FINREPORTS_INT';

Line 3274: and l_table_name(i) = 'HZ_IMP_FINREPORTS_INT';

3270: update hz_imp_finreports_int
3271: set interface_status = 'E',
3272: error_id = l_error_id(i)
3273: where rowid = l_row_id(i)
3274: and l_table_name(i) = 'HZ_IMP_FINREPORTS_INT';
3275:
3276: ForAll i in 1..l_row_id.count
3277: update hz_imp_finnumbers_int
3278: set interface_status = 'E',

Line 3953: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_INT');

3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');
3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');
3953: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_INT');
3954: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_INT');
3955: END IF;
3956:
3957: /* Stage 1 preprocess before calling parties matching */

Line 4457: select /+ index_ffs(a,hz_imp_finreports_int_n1) parallel_index(a)/

4453: from hz_imp_creditrtngs_int a
4454: where party_orig_system = :2
4455: and batch_id=:1
4456: union all -- Financial Reports
4457: select /*+ index_ffs(a,hz_imp_finreports_int_n1) parallel_index(a)*/
4458: party_orig_system_reference
4459: from hz_imp_finreports_int a
4460: where party_orig_system = :2
4461: and batch_id=:1

Line 4459: from hz_imp_finreports_int a

4455: and batch_id=:1
4456: union all -- Financial Reports
4457: select /*+ index_ffs(a,hz_imp_finreports_int_n1) parallel_index(a)*/
4458: party_orig_system_reference
4459: from hz_imp_finreports_int a
4460: where party_orig_system = :2
4461: and batch_id=:1
4462: union all -- Financial Numbers
4463: select /*+ index_ffs(a,hz_imp_finnumbers_int_n1) parallel_index(a)*/

Line 4554: select /+ index(a,hz_imp_finreports_int_n1) /

4550: from hz_imp_creditrtngs_int a
4551: where party_orig_system = :2
4552: and batch_id=:1
4553: union all -- Financial Reports
4554: select /*+ index(a,hz_imp_finreports_int_n1) */
4555: party_orig_system_reference
4556: from hz_imp_finreports_int a
4557: where party_orig_system = :2
4558: and batch_id=:1

Line 4556: from hz_imp_finreports_int a

4552: and batch_id=:1
4553: union all -- Financial Reports
4554: select /*+ index(a,hz_imp_finreports_int_n1) */
4555: party_orig_system_reference
4556: from hz_imp_finreports_int a
4557: where party_orig_system = :2
4558: and batch_id=:1
4559: union all -- Financial Numbers
4560: select /*+ index(a,hz_imp_finnumbers_int_n1) */