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_SUBLEDGER_PKG dependencies on GL_LEDGERS

Line 427: FROM org_organization_definitions le, gl_ledgers led,

423: mthd.default_lot_cost_type_id
424: INTO g_legal_entity_name, g_ledger_name,
425: g_cost_method_type, g_cost_type_code, g_cost_method,
426: g_default_cost_type_id
427: FROM org_organization_definitions le, gl_ledgers led,
428: cm_mthd_mst mthd, gem_lookups lk
429: WHERE le.organization_id = g_legal_entity_id
430: AND led.ledger_id = g_ledger_id
431: AND mthd.cost_type_id = g_cost_type_id

Line 451: FROM gl_ledgers gl

447: END;
448: BEGIN
449: SELECT gl.name
450: INTO g_ledger_name
451: FROM gl_ledgers gl
452: WHERE gl.ledger_id = g_ledger_id;
453: EXCEPTION
454: WHEN NO_DATA_FOUND then
455: gmf_util.log(l_procedure_name || ': No data found in gl_ledgers query');

Line 455: gmf_util.log(l_procedure_name || ': No data found in gl_ledgers query');

451: FROM gl_ledgers gl
452: WHERE gl.ledger_id = g_ledger_id;
453: EXCEPTION
454: WHEN NO_DATA_FOUND then
455: gmf_util.log(l_procedure_name || ': No data found in gl_ledgers query');
456: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
457: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
458: END IF;
459: RAISE;

Line 2055: gl_ledgers gl,

2051: FROM org_acct_periods oap,
2052: hr_organization_information hoi,
2053: mtl_parameters mp,
2054: gmf_period_statuses gps,
2055: gl_ledgers gl,
2056: gmf_period_balances gpb
2057: WHERE gps.period_id = p_period_id
2058: AND hoi.org_information2 = gps.legal_entity_id
2059: AND hoi.org_information1 = gl.ledger_id

Line 2214: gl_ledgers gl

2210: x_inv_period
2211: FROM org_acct_periods oap,
2212: hr_organization_information hoi,
2213: gmf_period_statuses gps,
2214: gl_ledgers gl
2215: WHERE gps.period_id = l_prior_period_id
2216: AND hoi.org_information2 = gps.legal_entity_id
2217: AND hoi.org_information1 = gl.ledger_id
2218: AND oap.period_set_name = gl.period_set_name

Line 2522: FROM org_organization_definitions le, gl_ledgers led,

2518: mthd.default_lot_cost_type_id
2519: INTO g_legal_entity_name, g_ledger_name,
2520: g_cost_method_type, g_cost_type_code, g_cost_method,
2521: g_default_cost_type_id
2522: FROM org_organization_definitions le, gl_ledgers led,
2523: cm_mthd_mst mthd, gem_lookups lk
2524: WHERE le.organization_id = g_legal_entity_id
2525: AND led.ledger_id = g_ledger_id
2526: AND mthd.cost_type_id = g_cost_type_id

Line 2546: FROM gl_ledgers gl

2542: END;
2543: BEGIN
2544: SELECT gl.name
2545: INTO g_ledger_name
2546: FROM gl_ledgers gl
2547: WHERE gl.ledger_id = g_ledger_id;
2548: EXCEPTION
2549: WHEN NO_DATA_FOUND then
2550: gmf_util.log(l_procedure_name || ': No data found in gl_ledgers query');

Line 2550: gmf_util.log(l_procedure_name || ': No data found in gl_ledgers query');

2546: FROM gl_ledgers gl
2547: WHERE gl.ledger_id = g_ledger_id;
2548: EXCEPTION
2549: WHEN NO_DATA_FOUND then
2550: gmf_util.log(l_procedure_name || ': No data found in gl_ledgers query');
2551: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2552: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2553: END IF;
2554: RAISE;