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.GMF_MIGRATION dependencies on GL_ALOC_MST

Line 6004: FROM gl_aloc_mst x

6000: UPDATE gl_aloc_bas a
6001: SET a.basis_account_id
6002: = (
6003: SELECT gmf_migration.get_account_id(a.basis_Account_key, x.co_code)
6004: FROM gl_aloc_mst x
6005: WHERE x.alloc_id = a.alloc_id
6006: ),
6007: a.basis_type = decode(a.alloc_method, 0, a.basis_type, 1),
6008: (

Line 6241: FROM gl_aloc_mst x

6237: )
6238: = (
6239: SELECT gmf_migration.get_account_id(a.from_account, x.co_code),
6240: gmf_migration.get_account_id(a.to_account, x.co_code)
6241: FROM gl_aloc_mst x
6242: WHERE x.alloc_id = a.alloc_id
6243: )
6244: WHERE (
6245: (from_account_id IS NULL AND from_account IS NOT NULL)

Line 9236: FROM gl_aloc_mst x

9232:
9233: UPDATE gl_aloc_inp a
9234: SET a.account_id = (
9235: SELECT gmf_migration.get_account_id(a.account_key, x.co_code)
9236: FROM gl_aloc_mst x
9237: WHERE x.alloc_id = a.alloc_id
9238: )
9239: WHERE (account_id IS NULL AND a.account_key IS NOT NULL);
9240:

Line 9875: FROM gl_aloc_mst h

9871: FROM gl_aloc_bas x, (
9872: SELECT a.alloc_id,
9873: (
9874: SELECT MIN(h.alloc_id)
9875: FROM gl_aloc_mst h
9876: WHERE (h.legal_entity_id, h.alloc_code) IN (
9877: SELECT i.legal_entity_id, i.alloc_code
9878: FROM gl_aloc_mst i
9879: WHERE i.alloc_id = a.alloc_id

Line 9878: FROM gl_aloc_mst i

9874: SELECT MIN(h.alloc_id)
9875: FROM gl_aloc_mst h
9876: WHERE (h.legal_entity_id, h.alloc_code) IN (
9877: SELECT i.legal_entity_id, i.alloc_code
9878: FROM gl_aloc_mst i
9879: WHERE i.alloc_id = a.alloc_id
9880: )
9881: ) mina
9882: FROM gl_aloc_bas a

Line 9900: FROM gl_aloc_mst h

9896: FROM gl_aloc_exp x, (
9897: SELECT a.alloc_id,
9898: (
9899: SELECT MIN(h.alloc_id)
9900: FROM gl_aloc_mst h
9901: WHERE (h.legal_entity_id, h.alloc_code) IN (
9902: SELECT i.legal_entity_id, i.alloc_code
9903: FROM gl_aloc_mst i
9904: WHERE i.alloc_id = a.alloc_id

Line 9903: FROM gl_aloc_mst i

9899: SELECT MIN(h.alloc_id)
9900: FROM gl_aloc_mst h
9901: WHERE (h.legal_entity_id, h.alloc_code) IN (
9902: SELECT i.legal_entity_id, i.alloc_code
9903: FROM gl_aloc_mst i
9904: WHERE i.alloc_id = a.alloc_id
9905: )
9906: ) mina
9907: FROM gl_aloc_exp a

Line 9925: FROM gl_aloc_mst h

9921: FROM gl_aloc_inp x, (
9922: SELECT a.alloc_id,
9923: (
9924: SELECT MIN(h.alloc_id)
9925: FROM gl_aloc_mst h
9926: WHERE (h.legal_entity_id, h.alloc_code) IN (
9927: SELECT i.legal_entity_id, i.alloc_code
9928: FROM gl_aloc_mst i
9929: WHERE i.alloc_id = a.alloc_id

Line 9928: FROM gl_aloc_mst i

9924: SELECT MIN(h.alloc_id)
9925: FROM gl_aloc_mst h
9926: WHERE (h.legal_entity_id, h.alloc_code) IN (
9927: SELECT i.legal_entity_id, i.alloc_code
9928: FROM gl_aloc_mst i
9929: WHERE i.alloc_id = a.alloc_id
9930: )
9931: ) mina
9932: FROM gl_aloc_inp a

Line 9948: G_Table_name := 'GL_ALOC_MST';

9944:
9945: BEGIN
9946:
9947: G_Migration_run_id := P_migration_run_id;
9948: G_Table_name := 'GL_ALOC_MST';
9949: G_Context := 'Expense Allocation Codes Migration';
9950: X_failure_count := 0;
9951:
9952: /********************************

Line 9971: UPDATE gl_aloc_mst a

9967: /*****************************************
9968: * Update rows For Legal Entity *
9969: *****************************************/
9970:
9971: UPDATE gl_aloc_mst a
9972: SET a.legal_entity_id = (
9973: SELECT x.legal_entity_id
9974: FROM gl_plcy_mst x
9975: WHERE x.co_code = a.co_code

Line 9986: UPDATE gl_aloc_mst a

9982: * from the allocation tables. Since there are some references too the allocation codes in Allocation basis *
9983: * we have to delete the records from those tables as well. *
9984: **************************************************************************************************************/
9985:
9986: UPDATE gl_aloc_mst a
9987: SET a.delete_mark = 1
9988: WHERE a.ROWID NOT IN (
9989: SELECT MIN(x.ROWID)
9990: FROM gl_aloc_mst x

Line 9990: FROM gl_aloc_mst x

9986: UPDATE gl_aloc_mst a
9987: SET a.delete_mark = 1
9988: WHERE a.ROWID NOT IN (
9989: SELECT MIN(x.ROWID)
9990: FROM gl_aloc_mst x
9991: WHERE x.alloc_code = a.alloc_code
9992: AND x.legal_entity_id = a.legal_Entity_id
9993: AND x.delete_mark <> 1
9994: );

Line 10056: FROM gl_aloc_mst

10052: **********************************************/
10053:
10054: SELECT count(*)
10055: INTO x_failure_count
10056: FROM gl_aloc_mst
10057: WHERE (legal_entity_id IS NULL AND co_code IS NOT NULL);
10058:
10059: IF nvl(x_failure_count,0) > 0 THEN
10060: