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_GET_MAPPINGS dependencies on GL_ACCT_MAP

Line 232: /* selecting the acct_id in gl_acct_map

228: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,k,x_tmp1);
229: END LOOP;
230: X_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);
231:
232: /* selecting the acct_id in gl_acct_map
233: create the order_by based on the priority retrieved above.
234: company is always the first column selected */
235:
236: -- Bug 2031374 - umoogala : 19 -> 21 for 2 new attributes, Bug 2468912: 21 to 22,

Line 425: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlordby,DBMS_SQL.V7);

421: X_sqlordby:= X_my_order_by;
422:
423: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
424:
425: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlordby,DBMS_SQL.V7);
426: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
427: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',x_co_code);
428: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
429: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',x_map_orgn_code);

Line 506: sv_gl_acct_map.co_code := v_co_code;

502: v_acctg_unit_id := crec.acctg_unit_id;
503: EXIT;
504: END LOOP;
505:
506: sv_gl_acct_map.co_code := v_co_code;
507: sv_gl_acct_map.acct_id := v_acct_id;
508: sv_acctg_unit_id := v_acctg_unit_id;
509:
510: END get_account_mappings;

Line 507: sv_gl_acct_map.acct_id := v_acct_id;

503: EXIT;
504: END LOOP;
505:
506: sv_gl_acct_map.co_code := v_co_code;
507: sv_gl_acct_map.acct_id := v_acct_id;
508: sv_acctg_unit_id := v_acctg_unit_id;
509:
510: END get_account_mappings;
511:

Line 787: /*selecting the acct_id in gl_acct_map

783: FOR k IN 2..23 LOOP
784: DBMS_SQL.DEFINE_COLUMN(X_cursor_handle,k,x_tmp1);
785: END LOOP;
786: X_rows_processed := DBMS_SQL.EXECUTE(X_cursor_handle);
787: /*selecting the acct_id in gl_acct_map
788: create the order_by based on the priority retrieved above.
789: company is always the first column selected */
790:
791: -- Bug 2031374 - umoogala : 19 -> 21 for 2 new attributes, Bug 2468912: 21 to 22,

Line 991: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlwhere7||X_sqlordby,DBMS_SQL.V7);

987: X_sqlordby:= X_my_order_by;
988: X_cursor_handle := DBMS_SQL.OPEN_CURSOR;
989:
990:
991: DBMS_SQL.PARSE(X_cursor_handle,X_sqlcolumns||X_sqlcolumns1||X_sqlcolumns2||' FROM gl_acct_map '||X_sqlwhere||X_sqlwhere1||X_sqlwhere2||X_sqlwhere3||X_sqlwhere4||X_sqlwhere5||X_sqlwhere6||X_sqlwhere7||X_sqlordby,DBMS_SQL.V7);
992: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pacct_ttl_type',Cur_subevtacct_ttl.acct_ttl_type);
993: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pco_code',nvl(x_co_code,v_co_code));
994: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pwhse_code',v_whse_code);
995: DBMS_SQL.BIND_VARIABLE(x_cursor_handle,':pmap_orgn_code',nvl(X_map_orgn_code,v_orgn_code));