APPS.GMF_MIGRATION dependencies on GL_ALOC_BAS

Line 5966: FROM gl_aloc_bas a,

5962: organization_id
5963: FROM (
5964: SELECT a.item_id,
5965: DECODE(NVL(b.subinventory_ind_flag,'N'), 'Y', b.organization_id, b.mtl_organization_id) organization_id
5966: FROM gl_aloc_bas a,
5967: ic_whse_mst b
5968: WHERE a.item_id IS NOT NULL
5969: AND b.whse_code = a.whse_code
5970: );

Line 5975: G_Table_name := 'GL_ALOC_BAS';

5971:
5972: BEGIN
5973:
5974: G_Migration_run_id := P_migration_run_id;
5975: G_Table_name := 'GL_ALOC_BAS';
5976: G_Context := 'Expense Allocation Basis Migration';
5977: X_failure_count := 0;
5978:
5979: /********************************

Line 5995: * Migrating Items IN GL_ALOC_BAS table to Converged Item Master *

5991: p_app_short_name => 'GMA'
5992: );
5993:
5994: /****************************************************************
5995: * Migrating Items IN GL_ALOC_BAS table to Converged Item Master *
5996: ****************************************************************/
5997:
5998: FOR i IN cur_get_gmf_items
5999: LOOP

Line 6018: * Update a row in GL_ALOC_BAS for Account Codes *

6014: l_itm_failure_count_all := nvl(l_itm_failure_count_all,0) + nvl(l_itm_failure_count,0);
6015: END LOOP;
6016:
6017: /**********************************************************
6018: * Update a row in GL_ALOC_BAS for Account Codes *
6019: **********************************************************/
6020:
6021: BEGIN
6022: /* B8266256 -- Splitting update into 2 parts Starts */

Line 6023: -- UPDATE gl_aloc_bas a

6019: **********************************************************/
6020:
6021: BEGIN
6022: /* B8266256 -- Splitting update into 2 parts Starts */
6023: -- UPDATE gl_aloc_bas a
6024: -- SET a.basis_account_id
6025: -- = (
6026: -- SELECT gmf_migration.get_account_id(a.basis_Account_key, x.co_code)
6027: -- FROM gl_aloc_mst x

Line 6051: UPDATE gl_aloc_bas a

6047: -- OR (a.organization_id IS NULL AND a.whse_code IS NOT NULL)
6048: -- );
6049:
6050: /* For fixed percentage allocations */
6051: UPDATE gl_aloc_bas a
6052: SET a.basis_type = decode(a.alloc_method, 0, a.basis_type, 1),
6053: (
6054: a.organization_id,
6055: a.inventory_item_id

Line 6074: UPDATE gl_aloc_bas a

6070: )
6071: AND a.alloc_method <> 0 ;
6072:
6073: /* For GL Balance percentage allocations */
6074: UPDATE gl_aloc_bas a
6075: SET a.basis_account_id
6076: = (
6077: SELECT decode(a.alloc_method,0, gmf_migration.get_account_id(a.basis_Account_key, x.co_code), NULL)
6078: FROM gl_aloc_mst x

Line 6151: FROM gl_aloc_bas

6147: **********************************************/
6148:
6149: SELECT count(*)
6150: INTO x_failure_count
6151: FROM gl_aloc_bas
6152: WHERE (
6153: (basis_account_key IS NOT NULL AND basis_account_id IS NULL)
6154: OR (inventory_item_id IS NULL AND item_id IS NOT NULL)
6155: OR (organization_id IS NULL AND whse_code IS NOT NULL)

Line 10193: CURSOR c_gl_aloc_bas

10189: /**********
10190: * Cursors *
10191: **********/
10192:
10193: CURSOR c_gl_aloc_bas
10194: IS
10195: SELECT y.alloc_id,
10196: y.mina,
10197: count(x.alloc_id) cnt

Line 10198: FROM gl_aloc_bas x, (

10194: IS
10195: SELECT y.alloc_id,
10196: y.mina,
10197: count(x.alloc_id) cnt
10198: FROM gl_aloc_bas x, (
10199: SELECT a.alloc_id,
10200: (
10201: SELECT MIN(h.alloc_id)
10202: FROM gl_aloc_mst h

Line 10209: FROM gl_aloc_bas a

10205: FROM gl_aloc_mst i
10206: WHERE i.alloc_id = a.alloc_id
10207: )
10208: ) mina
10209: FROM gl_aloc_bas a
10210: GROUP BY a.alloc_id
10211: ) y
10212: WHERE x.alloc_id(+) = y.mina
10213: GROUP BY y.alloc_id,

Line 10325: * Deleting referenced records and updating records in GL_ALOC_BAS *

10321: AND x.delete_mark <> 1
10322: );
10323:
10324: /******************************************************************
10325: * Deleting referenced records and updating records in GL_ALOC_BAS *
10326: ******************************************************************/
10327:
10328: FOR i IN c_gl_aloc_bas LOOP
10329: IF i.cnt > 0 THEN

Line 10328: FOR i IN c_gl_aloc_bas LOOP

10324: /******************************************************************
10325: * Deleting referenced records and updating records in GL_ALOC_BAS *
10326: ******************************************************************/
10327:
10328: FOR i IN c_gl_aloc_bas LOOP
10329: IF i.cnt > 0 THEN
10330: UPDATE gl_aloc_bas a
10331: SET a.delete_mark = 1
10332: WHERE a.alloc_id = i.alloc_id

Line 10330: UPDATE gl_aloc_bas a

10326: ******************************************************************/
10327:
10328: FOR i IN c_gl_aloc_bas LOOP
10329: IF i.cnt > 0 THEN
10330: UPDATE gl_aloc_bas a
10331: SET a.delete_mark = 1
10332: WHERE a.alloc_id = i.alloc_id
10333: AND a.delete_mark <> 1;
10334: ELSE

Line 10335: UPDATE gl_aloc_bas a

10331: SET a.delete_mark = 1
10332: WHERE a.alloc_id = i.alloc_id
10333: AND a.delete_mark <> 1;
10334: ELSE
10335: UPDATE gl_aloc_bas a
10336: SET a.alloc_id = i.mina
10337: WHERE a.alloc_id = i.alloc_id
10338: AND a.delete_mark <> 1;
10339: END IF;