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.INV_MIGRATE_PROCESS_ORG dependencies on SY_ORGN_MST

Line 234: FROM sy_orgn_mst a, gl_plcy_mst b

230: WHERE process_enabled_flag = 'Y';
231:
232: CURSOR Cur_get_oper_unit (V_orgn_code VARCHAR2)IS
233: SELECT a.co_code
234: FROM sy_orgn_mst a, gl_plcy_mst b
235: WHERE a.co_code = b.co_code
236: AND a.orgn_code = V_orgn_code
237: AND b.new_le_flag = 'Y';
238:

Line 785: FROM sy_orgn_mst

781: AND NVL(migrated_ind,0) = 0;
782:
783: CURSOR Cur_get_orgn(V_orgn_code VARCHAR2) IS
784: SELECT organization_id
785: FROM sy_orgn_mst
786: WHERE orgn_code = V_orgn_code;
787:
788: CURSOR Cur_check_subinventory(V_whse_code VARCHAR2, V_organization_id NUMBER) IS
789: SELECT 1

Line 1507: p_table_name => 'SY_ORGN_MST',

1503: GMA_COMMON_LOGGING.gma_migration_central_log (
1504: p_run_id => P_migration_run_id,
1505: p_log_level => FND_LOG.LEVEL_ERROR,
1506: p_message_token => 'GMA_TEMP_ORGN_MISSING_ERROR',
1507: p_table_name => 'SY_ORGN_MST',
1508: p_context => 'ORGANIZATION',
1509: p_token1 => 'ORGANIZATION',
1510: p_param1 => p_orgn_code,
1511: p_app_short_name => 'GMA');

Line 1519: p_table_name => 'SY_ORGN_MST',

1515: GMA_COMMON_LOGGING.gma_migration_central_log (
1516: p_run_id => P_migration_run_id,
1517: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1518: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1519: p_table_name => 'SY_ORGN_MST',
1520: p_context => 'ORGANIZATION',
1521: p_db_error => p_orgn_code||'-'||l_msg_data,
1522: p_app_short_name => 'GMA');
1523: --Bug #13981860

Line 1530: p_table_name => 'SY_ORGN_MST',

1526: GMA_COMMON_LOGGING.gma_migration_central_log (
1527: p_run_id => P_migration_run_id,
1528: p_log_level => FND_LOG.LEVEL_ERROR,
1529: p_message_token => 'INV_ALREADY_EXISTS',
1530: p_table_name => 'SY_ORGN_MST',
1531: p_context => 'ORGANIZATION',
1532: p_param1 => P_organization_code,
1533: p_token1 => 'ORGANIZATION',
1534: p_app_short_name => 'INV');

Line 1543: p_table_name => 'SY_ORGN_MST',

1539: GMA_COMMON_LOGGING.gma_migration_central_log (
1540: p_run_id => P_migration_run_id,
1541: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1542: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1543: p_table_name => 'SY_ORGN_MST',
1544: p_context => 'ORGANIZATION',
1545: p_db_error => SQLERRM,
1546: p_app_short_name => 'GMA');
1547: END create_organization;

Line 1589: FROM sy_orgn_mst

1585:
1586: --CURSORS
1587: CURSOR Cur_get_organization IS
1588: SELECT *
1589: FROM sy_orgn_mst
1590: WHERE (migrate_as_ind <> 0 OR migrate_as_ind IS NULL)
1591: AND (orgn_code <> co_code or plant_ind > 0) ;
1592: /* AND NVL(migrated_ind,0) = 0; Fix for Bug#9143261 */
1593: /* Organizations can be migrated in pre-migration. In this case, material

Line 1626: p_table_name => 'SY_ORGN_MST',

1622: GMA_COMMON_LOGGING.gma_migration_central_log (
1623: p_run_id => l_migration_id,
1624: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1625: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1626: p_table_name => 'SY_ORGN_MST',
1627: p_context => 'ORGANIZATION',
1628: p_app_short_name => 'GMA');
1629:
1630: FOR l_rec IN Cur_get_organization LOOP

Line 1676: UPDATE sy_orgn_mst_b

1672: SET default_status_id = l_default_status_id
1673: WHERE organization_id = l_rec.organization_id;
1674: END IF; /* IF NVL(l_rec.migrate_as_ind, 1) IN (1,3) */
1675:
1676: UPDATE sy_orgn_mst_b
1677: SET organization_id = l_organization_id,
1678: migrated_ind = 1
1679: WHERE orgn_code = l_rec.orgn_code;
1680:

Line 1719: p_table_name => 'SY_ORGN_MST',

1715: GMA_COMMON_LOGGING.gma_migration_central_log (
1716: p_run_id => l_migration_id,
1717: p_log_level => FND_LOG.LEVEL_ERROR,
1718: p_message_token => 'GMA_ORGN_MISSING_ERROR',
1719: p_table_name => 'SY_ORGN_MST',
1720: p_context => 'ORGANIZATION',
1721: p_token1 => 'ORGANIZATION',
1722: p_param1 => l_rec.orgn_code,
1723: p_app_short_name => 'GMA');

Line 1742: p_table_name => 'SY_ORGN_MST',

1738: GMA_COMMON_LOGGING.gma_migration_central_log(
1739: p_run_id => P_migration_run_id,
1740: p_log_level => FND_LOG.LEVEL_ERROR,
1741: p_message_token => 'GMA_DEFAULT_STATUS_MISSING_ERROR',
1742: p_table_name => 'SY_ORGN_MST',
1743: p_context => 'ORGANIZATION',
1744: p_token1 => 'ORGANIZATION',
1745: p_param1 => l_rec.organization_code,
1746: p_app_short_name => 'GMA');

Line 1768: p_table_name => 'SY_ORGN_MST',

1764: GMA_COMMON_LOGGING.gma_migration_central_log (
1765: p_run_id => l_migration_id,
1766: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1767: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1768: p_table_name => 'SY_ORGN_MST',
1769: p_context => 'ORGANIZATION',
1770: p_db_error => SQLERRM,
1771: p_app_short_name => 'GMA');
1772: END;

Line 1779: p_table_name => 'SY_ORGN_MST',

1775: GMA_COMMON_LOGGING.gma_migration_central_log (
1776: p_run_id => l_migration_id,
1777: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1778: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1779: p_table_name => 'SY_ORGN_MST',
1780: p_context => 'ORGANIZATION',
1781: p_param1 => l_migrate_count,
1782: p_param2 => X_failure_count,
1783: p_app_short_name => 'GMA');

Line 1794: p_table_name => 'SY_ORGN_MST',

1790: GMA_COMMON_LOGGING.gma_migration_central_log (
1791: p_run_id => l_migration_id,
1792: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1793: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1794: p_table_name => 'SY_ORGN_MST',
1795: p_context => 'ORGANIZATION',
1796: p_db_error => SQLERRM,
1797: p_app_short_name => 'GMA');
1798:

Line 1803: p_table_name => 'SY_ORGN_MST',

1799: GMA_COMMON_LOGGING.gma_migration_central_log (
1800: p_run_id => l_migration_id,
1801: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1802: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
1803: p_table_name => 'SY_ORGN_MST',
1804: p_context => 'ORGANIZATION',
1805: p_app_short_name => 'GMA');
1806:
1807: END migrate_organization;