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.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_FINANCIAL_DATA

Line 1349: The reason was that the financial data (ar_cmgt_financial_data)

1345:
1346: END;
1347:
1348: /* 6335440 - this procedure did not work prior to this bug.
1349: The reason was that the financial data (ar_cmgt_financial_data)
1350: had cust_acct_site_id in the site_use_id field. Additionally,
1351: prior to this bug, the procedure relied on completely un-indexed
1352: joins and multiple reads of the ar_cmgt_financial_data table
1353: which (for production data) would bave performed awful.

Line 1352: joins and multiple reads of the ar_cmgt_financial_data table

1348: /* 6335440 - this procedure did not work prior to this bug.
1349: The reason was that the financial data (ar_cmgt_financial_data)
1350: had cust_acct_site_id in the site_use_id field. Additionally,
1351: prior to this bug, the procedure relied on completely un-indexed
1352: joins and multiple reads of the ar_cmgt_financial_data table
1353: which (for production data) would bave performed awful.
1354:
1355: To correct these issues, we did the following:
1356:

Line 1359: join to the errant ar_cmgt_financial_data table.

1355: To correct these issues, we did the following:
1356:
1357: o revised initial select to fetch cust_acct_site_id
1358: instead of site_use_id. This is used to correctly
1359: join to the errant ar_cmgt_financial_data table.
1360:
1361: o revised second select to only join to
1362: ar_cmgt_financial_data once (was joining twice)
1363:

Line 1362: ar_cmgt_financial_data once (was joining twice)

1358: instead of site_use_id. This is used to correctly
1359: join to the errant ar_cmgt_financial_data table.
1360:
1361: o revised second select to only join to
1362: ar_cmgt_financial_data once (was joining twice)
1363:
1364: o Added index ar_cmgt_financial_data_n2 that contains following:
1365: 1) party_id
1366: 2) reporting_currency

Line 1364: o Added index ar_cmgt_financial_data_n2 that contains following:

1360:
1361: o revised second select to only join to
1362: ar_cmgt_financial_data once (was joining twice)
1363:
1364: o Added index ar_cmgt_financial_data_n2 that contains following:
1365: 1) party_id
1366: 2) reporting_currency
1367: 3) cust_account_id
1368: 4) site_use_id

Line 1383: l_reporting_currency ar_cmgt_financial_data.reporting_currency%type;

1379: p_mode IN VARCHAR2,
1380: p_resultout OUT NOCOPY VARCHAR2,
1381: p_errmsg OUT NOCOPY VARCHAR2) IS
1382:
1383: l_reporting_currency ar_cmgt_financial_data.reporting_currency%type;
1384: l_monetary_unit ar_cmgt_financial_data.monetary_unit%type;
1385: l_curr_fin_st_date ar_cmgt_financial_data.curr_fin_st_date%type;
1386: l_reporting_period ar_cmgt_financial_data.reporting_period%type;
1387: l_cash ar_cmgt_financial_data.cash%type;

Line 1384: l_monetary_unit ar_cmgt_financial_data.monetary_unit%type;

1380: p_resultout OUT NOCOPY VARCHAR2,
1381: p_errmsg OUT NOCOPY VARCHAR2) IS
1382:
1383: l_reporting_currency ar_cmgt_financial_data.reporting_currency%type;
1384: l_monetary_unit ar_cmgt_financial_data.monetary_unit%type;
1385: l_curr_fin_st_date ar_cmgt_financial_data.curr_fin_st_date%type;
1386: l_reporting_period ar_cmgt_financial_data.reporting_period%type;
1387: l_cash ar_cmgt_financial_data.cash%type;
1388: l_net_receivables ar_cmgt_financial_data.net_receivables%type;

Line 1385: l_curr_fin_st_date ar_cmgt_financial_data.curr_fin_st_date%type;

1381: p_errmsg OUT NOCOPY VARCHAR2) IS
1382:
1383: l_reporting_currency ar_cmgt_financial_data.reporting_currency%type;
1384: l_monetary_unit ar_cmgt_financial_data.monetary_unit%type;
1385: l_curr_fin_st_date ar_cmgt_financial_data.curr_fin_st_date%type;
1386: l_reporting_period ar_cmgt_financial_data.reporting_period%type;
1387: l_cash ar_cmgt_financial_data.cash%type;
1388: l_net_receivables ar_cmgt_financial_data.net_receivables%type;
1389: l_inventories ar_cmgt_financial_data.inventories%type;

Line 1386: l_reporting_period ar_cmgt_financial_data.reporting_period%type;

1382:
1383: l_reporting_currency ar_cmgt_financial_data.reporting_currency%type;
1384: l_monetary_unit ar_cmgt_financial_data.monetary_unit%type;
1385: l_curr_fin_st_date ar_cmgt_financial_data.curr_fin_st_date%type;
1386: l_reporting_period ar_cmgt_financial_data.reporting_period%type;
1387: l_cash ar_cmgt_financial_data.cash%type;
1388: l_net_receivables ar_cmgt_financial_data.net_receivables%type;
1389: l_inventories ar_cmgt_financial_data.inventories%type;
1390: l_other_cur_assets ar_cmgt_financial_data.other_cur_assets%type;

Line 1387: l_cash ar_cmgt_financial_data.cash%type;

1383: l_reporting_currency ar_cmgt_financial_data.reporting_currency%type;
1384: l_monetary_unit ar_cmgt_financial_data.monetary_unit%type;
1385: l_curr_fin_st_date ar_cmgt_financial_data.curr_fin_st_date%type;
1386: l_reporting_period ar_cmgt_financial_data.reporting_period%type;
1387: l_cash ar_cmgt_financial_data.cash%type;
1388: l_net_receivables ar_cmgt_financial_data.net_receivables%type;
1389: l_inventories ar_cmgt_financial_data.inventories%type;
1390: l_other_cur_assets ar_cmgt_financial_data.other_cur_assets%type;
1391: l_total_cur_assets ar_cmgt_financial_data.total_cur_assets%type;

Line 1388: l_net_receivables ar_cmgt_financial_data.net_receivables%type;

1384: l_monetary_unit ar_cmgt_financial_data.monetary_unit%type;
1385: l_curr_fin_st_date ar_cmgt_financial_data.curr_fin_st_date%type;
1386: l_reporting_period ar_cmgt_financial_data.reporting_period%type;
1387: l_cash ar_cmgt_financial_data.cash%type;
1388: l_net_receivables ar_cmgt_financial_data.net_receivables%type;
1389: l_inventories ar_cmgt_financial_data.inventories%type;
1390: l_other_cur_assets ar_cmgt_financial_data.other_cur_assets%type;
1391: l_total_cur_assets ar_cmgt_financial_data.total_cur_assets%type;
1392: l_net_fixed_assets ar_cmgt_financial_data.net_fixed_assets%type;

Line 1389: l_inventories ar_cmgt_financial_data.inventories%type;

1385: l_curr_fin_st_date ar_cmgt_financial_data.curr_fin_st_date%type;
1386: l_reporting_period ar_cmgt_financial_data.reporting_period%type;
1387: l_cash ar_cmgt_financial_data.cash%type;
1388: l_net_receivables ar_cmgt_financial_data.net_receivables%type;
1389: l_inventories ar_cmgt_financial_data.inventories%type;
1390: l_other_cur_assets ar_cmgt_financial_data.other_cur_assets%type;
1391: l_total_cur_assets ar_cmgt_financial_data.total_cur_assets%type;
1392: l_net_fixed_assets ar_cmgt_financial_data.net_fixed_assets%type;
1393: l_other_non_cur_assets ar_cmgt_financial_data.net_fixed_assets%type;

Line 1390: l_other_cur_assets ar_cmgt_financial_data.other_cur_assets%type;

1386: l_reporting_period ar_cmgt_financial_data.reporting_period%type;
1387: l_cash ar_cmgt_financial_data.cash%type;
1388: l_net_receivables ar_cmgt_financial_data.net_receivables%type;
1389: l_inventories ar_cmgt_financial_data.inventories%type;
1390: l_other_cur_assets ar_cmgt_financial_data.other_cur_assets%type;
1391: l_total_cur_assets ar_cmgt_financial_data.total_cur_assets%type;
1392: l_net_fixed_assets ar_cmgt_financial_data.net_fixed_assets%type;
1393: l_other_non_cur_assets ar_cmgt_financial_data.net_fixed_assets%type;
1394: l_total_assets ar_cmgt_financial_data.total_assets%type;

Line 1391: l_total_cur_assets ar_cmgt_financial_data.total_cur_assets%type;

1387: l_cash ar_cmgt_financial_data.cash%type;
1388: l_net_receivables ar_cmgt_financial_data.net_receivables%type;
1389: l_inventories ar_cmgt_financial_data.inventories%type;
1390: l_other_cur_assets ar_cmgt_financial_data.other_cur_assets%type;
1391: l_total_cur_assets ar_cmgt_financial_data.total_cur_assets%type;
1392: l_net_fixed_assets ar_cmgt_financial_data.net_fixed_assets%type;
1393: l_other_non_cur_assets ar_cmgt_financial_data.net_fixed_assets%type;
1394: l_total_assets ar_cmgt_financial_data.total_assets%type;
1395: l_accounts_payable ar_cmgt_financial_data.accounts_payable%type;

Line 1392: l_net_fixed_assets ar_cmgt_financial_data.net_fixed_assets%type;

1388: l_net_receivables ar_cmgt_financial_data.net_receivables%type;
1389: l_inventories ar_cmgt_financial_data.inventories%type;
1390: l_other_cur_assets ar_cmgt_financial_data.other_cur_assets%type;
1391: l_total_cur_assets ar_cmgt_financial_data.total_cur_assets%type;
1392: l_net_fixed_assets ar_cmgt_financial_data.net_fixed_assets%type;
1393: l_other_non_cur_assets ar_cmgt_financial_data.net_fixed_assets%type;
1394: l_total_assets ar_cmgt_financial_data.total_assets%type;
1395: l_accounts_payable ar_cmgt_financial_data.accounts_payable%type;
1396: l_short_term_debt ar_cmgt_financial_data.short_term_debt%type;

Line 1393: l_other_non_cur_assets ar_cmgt_financial_data.net_fixed_assets%type;

1389: l_inventories ar_cmgt_financial_data.inventories%type;
1390: l_other_cur_assets ar_cmgt_financial_data.other_cur_assets%type;
1391: l_total_cur_assets ar_cmgt_financial_data.total_cur_assets%type;
1392: l_net_fixed_assets ar_cmgt_financial_data.net_fixed_assets%type;
1393: l_other_non_cur_assets ar_cmgt_financial_data.net_fixed_assets%type;
1394: l_total_assets ar_cmgt_financial_data.total_assets%type;
1395: l_accounts_payable ar_cmgt_financial_data.accounts_payable%type;
1396: l_short_term_debt ar_cmgt_financial_data.short_term_debt%type;
1397: l_other_cur_liabilities ar_cmgt_financial_data.other_cur_liabilities%type;

Line 1394: l_total_assets ar_cmgt_financial_data.total_assets%type;

1390: l_other_cur_assets ar_cmgt_financial_data.other_cur_assets%type;
1391: l_total_cur_assets ar_cmgt_financial_data.total_cur_assets%type;
1392: l_net_fixed_assets ar_cmgt_financial_data.net_fixed_assets%type;
1393: l_other_non_cur_assets ar_cmgt_financial_data.net_fixed_assets%type;
1394: l_total_assets ar_cmgt_financial_data.total_assets%type;
1395: l_accounts_payable ar_cmgt_financial_data.accounts_payable%type;
1396: l_short_term_debt ar_cmgt_financial_data.short_term_debt%type;
1397: l_other_cur_liabilities ar_cmgt_financial_data.other_cur_liabilities%type;
1398: l_total_cur_liabilities ar_cmgt_financial_data.total_cur_liabilities%type;

Line 1395: l_accounts_payable ar_cmgt_financial_data.accounts_payable%type;

1391: l_total_cur_assets ar_cmgt_financial_data.total_cur_assets%type;
1392: l_net_fixed_assets ar_cmgt_financial_data.net_fixed_assets%type;
1393: l_other_non_cur_assets ar_cmgt_financial_data.net_fixed_assets%type;
1394: l_total_assets ar_cmgt_financial_data.total_assets%type;
1395: l_accounts_payable ar_cmgt_financial_data.accounts_payable%type;
1396: l_short_term_debt ar_cmgt_financial_data.short_term_debt%type;
1397: l_other_cur_liabilities ar_cmgt_financial_data.other_cur_liabilities%type;
1398: l_total_cur_liabilities ar_cmgt_financial_data.total_cur_liabilities%type;
1399: l_long_term_debt ar_cmgt_financial_data.long_term_debt%type;

Line 1396: l_short_term_debt ar_cmgt_financial_data.short_term_debt%type;

1392: l_net_fixed_assets ar_cmgt_financial_data.net_fixed_assets%type;
1393: l_other_non_cur_assets ar_cmgt_financial_data.net_fixed_assets%type;
1394: l_total_assets ar_cmgt_financial_data.total_assets%type;
1395: l_accounts_payable ar_cmgt_financial_data.accounts_payable%type;
1396: l_short_term_debt ar_cmgt_financial_data.short_term_debt%type;
1397: l_other_cur_liabilities ar_cmgt_financial_data.other_cur_liabilities%type;
1398: l_total_cur_liabilities ar_cmgt_financial_data.total_cur_liabilities%type;
1399: l_long_term_debt ar_cmgt_financial_data.long_term_debt%type;
1400: l_other_non_cur_liabilities ar_cmgt_financial_data.other_non_cur_liabilities%type;

Line 1397: l_other_cur_liabilities ar_cmgt_financial_data.other_cur_liabilities%type;

1393: l_other_non_cur_assets ar_cmgt_financial_data.net_fixed_assets%type;
1394: l_total_assets ar_cmgt_financial_data.total_assets%type;
1395: l_accounts_payable ar_cmgt_financial_data.accounts_payable%type;
1396: l_short_term_debt ar_cmgt_financial_data.short_term_debt%type;
1397: l_other_cur_liabilities ar_cmgt_financial_data.other_cur_liabilities%type;
1398: l_total_cur_liabilities ar_cmgt_financial_data.total_cur_liabilities%type;
1399: l_long_term_debt ar_cmgt_financial_data.long_term_debt%type;
1400: l_other_non_cur_liabilities ar_cmgt_financial_data.other_non_cur_liabilities%type;
1401: l_total_liabilities ar_cmgt_financial_data.total_liabilities%type;

Line 1398: l_total_cur_liabilities ar_cmgt_financial_data.total_cur_liabilities%type;

1394: l_total_assets ar_cmgt_financial_data.total_assets%type;
1395: l_accounts_payable ar_cmgt_financial_data.accounts_payable%type;
1396: l_short_term_debt ar_cmgt_financial_data.short_term_debt%type;
1397: l_other_cur_liabilities ar_cmgt_financial_data.other_cur_liabilities%type;
1398: l_total_cur_liabilities ar_cmgt_financial_data.total_cur_liabilities%type;
1399: l_long_term_debt ar_cmgt_financial_data.long_term_debt%type;
1400: l_other_non_cur_liabilities ar_cmgt_financial_data.other_non_cur_liabilities%type;
1401: l_total_liabilities ar_cmgt_financial_data.total_liabilities%type;
1402: l_stockholder_equity ar_cmgt_financial_data.stockholder_equity%type;

Line 1399: l_long_term_debt ar_cmgt_financial_data.long_term_debt%type;

1395: l_accounts_payable ar_cmgt_financial_data.accounts_payable%type;
1396: l_short_term_debt ar_cmgt_financial_data.short_term_debt%type;
1397: l_other_cur_liabilities ar_cmgt_financial_data.other_cur_liabilities%type;
1398: l_total_cur_liabilities ar_cmgt_financial_data.total_cur_liabilities%type;
1399: l_long_term_debt ar_cmgt_financial_data.long_term_debt%type;
1400: l_other_non_cur_liabilities ar_cmgt_financial_data.other_non_cur_liabilities%type;
1401: l_total_liabilities ar_cmgt_financial_data.total_liabilities%type;
1402: l_stockholder_equity ar_cmgt_financial_data.stockholder_equity%type;
1403: l_total_liabilities_equity ar_cmgt_financial_data.total_liabilities_equity%type;

Line 1400: l_other_non_cur_liabilities ar_cmgt_financial_data.other_non_cur_liabilities%type;

1396: l_short_term_debt ar_cmgt_financial_data.short_term_debt%type;
1397: l_other_cur_liabilities ar_cmgt_financial_data.other_cur_liabilities%type;
1398: l_total_cur_liabilities ar_cmgt_financial_data.total_cur_liabilities%type;
1399: l_long_term_debt ar_cmgt_financial_data.long_term_debt%type;
1400: l_other_non_cur_liabilities ar_cmgt_financial_data.other_non_cur_liabilities%type;
1401: l_total_liabilities ar_cmgt_financial_data.total_liabilities%type;
1402: l_stockholder_equity ar_cmgt_financial_data.stockholder_equity%type;
1403: l_total_liabilities_equity ar_cmgt_financial_data.total_liabilities_equity%type;
1404: l_revenue ar_cmgt_financial_data.revenue%type;

Line 1401: l_total_liabilities ar_cmgt_financial_data.total_liabilities%type;

1397: l_other_cur_liabilities ar_cmgt_financial_data.other_cur_liabilities%type;
1398: l_total_cur_liabilities ar_cmgt_financial_data.total_cur_liabilities%type;
1399: l_long_term_debt ar_cmgt_financial_data.long_term_debt%type;
1400: l_other_non_cur_liabilities ar_cmgt_financial_data.other_non_cur_liabilities%type;
1401: l_total_liabilities ar_cmgt_financial_data.total_liabilities%type;
1402: l_stockholder_equity ar_cmgt_financial_data.stockholder_equity%type;
1403: l_total_liabilities_equity ar_cmgt_financial_data.total_liabilities_equity%type;
1404: l_revenue ar_cmgt_financial_data.revenue%type;
1405: l_cost_of_goods_sold ar_cmgt_financial_data.cost_of_goods_sold%type;

Line 1402: l_stockholder_equity ar_cmgt_financial_data.stockholder_equity%type;

1398: l_total_cur_liabilities ar_cmgt_financial_data.total_cur_liabilities%type;
1399: l_long_term_debt ar_cmgt_financial_data.long_term_debt%type;
1400: l_other_non_cur_liabilities ar_cmgt_financial_data.other_non_cur_liabilities%type;
1401: l_total_liabilities ar_cmgt_financial_data.total_liabilities%type;
1402: l_stockholder_equity ar_cmgt_financial_data.stockholder_equity%type;
1403: l_total_liabilities_equity ar_cmgt_financial_data.total_liabilities_equity%type;
1404: l_revenue ar_cmgt_financial_data.revenue%type;
1405: l_cost_of_goods_sold ar_cmgt_financial_data.cost_of_goods_sold%type;
1406: l_sga_expenses ar_cmgt_financial_data.sga_expenses%type;

Line 1403: l_total_liabilities_equity ar_cmgt_financial_data.total_liabilities_equity%type;

1399: l_long_term_debt ar_cmgt_financial_data.long_term_debt%type;
1400: l_other_non_cur_liabilities ar_cmgt_financial_data.other_non_cur_liabilities%type;
1401: l_total_liabilities ar_cmgt_financial_data.total_liabilities%type;
1402: l_stockholder_equity ar_cmgt_financial_data.stockholder_equity%type;
1403: l_total_liabilities_equity ar_cmgt_financial_data.total_liabilities_equity%type;
1404: l_revenue ar_cmgt_financial_data.revenue%type;
1405: l_cost_of_goods_sold ar_cmgt_financial_data.cost_of_goods_sold%type;
1406: l_sga_expenses ar_cmgt_financial_data.sga_expenses%type;
1407: l_operating_income ar_cmgt_financial_data.operating_income%type;

Line 1404: l_revenue ar_cmgt_financial_data.revenue%type;

1400: l_other_non_cur_liabilities ar_cmgt_financial_data.other_non_cur_liabilities%type;
1401: l_total_liabilities ar_cmgt_financial_data.total_liabilities%type;
1402: l_stockholder_equity ar_cmgt_financial_data.stockholder_equity%type;
1403: l_total_liabilities_equity ar_cmgt_financial_data.total_liabilities_equity%type;
1404: l_revenue ar_cmgt_financial_data.revenue%type;
1405: l_cost_of_goods_sold ar_cmgt_financial_data.cost_of_goods_sold%type;
1406: l_sga_expenses ar_cmgt_financial_data.sga_expenses%type;
1407: l_operating_income ar_cmgt_financial_data.operating_income%type;
1408: l_operating_margin ar_cmgt_financial_data.operating_margin%type;

Line 1405: l_cost_of_goods_sold ar_cmgt_financial_data.cost_of_goods_sold%type;

1401: l_total_liabilities ar_cmgt_financial_data.total_liabilities%type;
1402: l_stockholder_equity ar_cmgt_financial_data.stockholder_equity%type;
1403: l_total_liabilities_equity ar_cmgt_financial_data.total_liabilities_equity%type;
1404: l_revenue ar_cmgt_financial_data.revenue%type;
1405: l_cost_of_goods_sold ar_cmgt_financial_data.cost_of_goods_sold%type;
1406: l_sga_expenses ar_cmgt_financial_data.sga_expenses%type;
1407: l_operating_income ar_cmgt_financial_data.operating_income%type;
1408: l_operating_margin ar_cmgt_financial_data.operating_margin%type;
1409: l_non_operating_income ar_cmgt_financial_data.non_operating_income%type;

Line 1406: l_sga_expenses ar_cmgt_financial_data.sga_expenses%type;

1402: l_stockholder_equity ar_cmgt_financial_data.stockholder_equity%type;
1403: l_total_liabilities_equity ar_cmgt_financial_data.total_liabilities_equity%type;
1404: l_revenue ar_cmgt_financial_data.revenue%type;
1405: l_cost_of_goods_sold ar_cmgt_financial_data.cost_of_goods_sold%type;
1406: l_sga_expenses ar_cmgt_financial_data.sga_expenses%type;
1407: l_operating_income ar_cmgt_financial_data.operating_income%type;
1408: l_operating_margin ar_cmgt_financial_data.operating_margin%type;
1409: l_non_operating_income ar_cmgt_financial_data.non_operating_income%type;
1410: l_non_operating_expenses ar_cmgt_financial_data.non_operating_expenses%type;

Line 1407: l_operating_income ar_cmgt_financial_data.operating_income%type;

1403: l_total_liabilities_equity ar_cmgt_financial_data.total_liabilities_equity%type;
1404: l_revenue ar_cmgt_financial_data.revenue%type;
1405: l_cost_of_goods_sold ar_cmgt_financial_data.cost_of_goods_sold%type;
1406: l_sga_expenses ar_cmgt_financial_data.sga_expenses%type;
1407: l_operating_income ar_cmgt_financial_data.operating_income%type;
1408: l_operating_margin ar_cmgt_financial_data.operating_margin%type;
1409: l_non_operating_income ar_cmgt_financial_data.non_operating_income%type;
1410: l_non_operating_expenses ar_cmgt_financial_data.non_operating_expenses%type;
1411: l_pre_tax_net_income ar_cmgt_financial_data.pre_tax_net_income%type;

Line 1408: l_operating_margin ar_cmgt_financial_data.operating_margin%type;

1404: l_revenue ar_cmgt_financial_data.revenue%type;
1405: l_cost_of_goods_sold ar_cmgt_financial_data.cost_of_goods_sold%type;
1406: l_sga_expenses ar_cmgt_financial_data.sga_expenses%type;
1407: l_operating_income ar_cmgt_financial_data.operating_income%type;
1408: l_operating_margin ar_cmgt_financial_data.operating_margin%type;
1409: l_non_operating_income ar_cmgt_financial_data.non_operating_income%type;
1410: l_non_operating_expenses ar_cmgt_financial_data.non_operating_expenses%type;
1411: l_pre_tax_net_income ar_cmgt_financial_data.pre_tax_net_income%type;
1412: l_income_taxes ar_cmgt_financial_data.income_taxes%type;

Line 1409: l_non_operating_income ar_cmgt_financial_data.non_operating_income%type;

1405: l_cost_of_goods_sold ar_cmgt_financial_data.cost_of_goods_sold%type;
1406: l_sga_expenses ar_cmgt_financial_data.sga_expenses%type;
1407: l_operating_income ar_cmgt_financial_data.operating_income%type;
1408: l_operating_margin ar_cmgt_financial_data.operating_margin%type;
1409: l_non_operating_income ar_cmgt_financial_data.non_operating_income%type;
1410: l_non_operating_expenses ar_cmgt_financial_data.non_operating_expenses%type;
1411: l_pre_tax_net_income ar_cmgt_financial_data.pre_tax_net_income%type;
1412: l_income_taxes ar_cmgt_financial_data.income_taxes%type;
1413: l_net_income ar_cmgt_financial_data.net_income%type;

Line 1410: l_non_operating_expenses ar_cmgt_financial_data.non_operating_expenses%type;

1406: l_sga_expenses ar_cmgt_financial_data.sga_expenses%type;
1407: l_operating_income ar_cmgt_financial_data.operating_income%type;
1408: l_operating_margin ar_cmgt_financial_data.operating_margin%type;
1409: l_non_operating_income ar_cmgt_financial_data.non_operating_income%type;
1410: l_non_operating_expenses ar_cmgt_financial_data.non_operating_expenses%type;
1411: l_pre_tax_net_income ar_cmgt_financial_data.pre_tax_net_income%type;
1412: l_income_taxes ar_cmgt_financial_data.income_taxes%type;
1413: l_net_income ar_cmgt_financial_data.net_income%type;
1414: l_earnings_per_share ar_cmgt_financial_data.earnings_per_share%type;

Line 1411: l_pre_tax_net_income ar_cmgt_financial_data.pre_tax_net_income%type;

1407: l_operating_income ar_cmgt_financial_data.operating_income%type;
1408: l_operating_margin ar_cmgt_financial_data.operating_margin%type;
1409: l_non_operating_income ar_cmgt_financial_data.non_operating_income%type;
1410: l_non_operating_expenses ar_cmgt_financial_data.non_operating_expenses%type;
1411: l_pre_tax_net_income ar_cmgt_financial_data.pre_tax_net_income%type;
1412: l_income_taxes ar_cmgt_financial_data.income_taxes%type;
1413: l_net_income ar_cmgt_financial_data.net_income%type;
1414: l_earnings_per_share ar_cmgt_financial_data.earnings_per_share%type;
1415: l_financial_data_id ar_cmgt_financial_data.financial_data_id%type;

Line 1412: l_income_taxes ar_cmgt_financial_data.income_taxes%type;

1408: l_operating_margin ar_cmgt_financial_data.operating_margin%type;
1409: l_non_operating_income ar_cmgt_financial_data.non_operating_income%type;
1410: l_non_operating_expenses ar_cmgt_financial_data.non_operating_expenses%type;
1411: l_pre_tax_net_income ar_cmgt_financial_data.pre_tax_net_income%type;
1412: l_income_taxes ar_cmgt_financial_data.income_taxes%type;
1413: l_net_income ar_cmgt_financial_data.net_income%type;
1414: l_earnings_per_share ar_cmgt_financial_data.earnings_per_share%type;
1415: l_financial_data_id ar_cmgt_financial_data.financial_data_id%type;
1416: l_party_id ar_cmgt_case_folders.party_id%type;

Line 1413: l_net_income ar_cmgt_financial_data.net_income%type;

1409: l_non_operating_income ar_cmgt_financial_data.non_operating_income%type;
1410: l_non_operating_expenses ar_cmgt_financial_data.non_operating_expenses%type;
1411: l_pre_tax_net_income ar_cmgt_financial_data.pre_tax_net_income%type;
1412: l_income_taxes ar_cmgt_financial_data.income_taxes%type;
1413: l_net_income ar_cmgt_financial_data.net_income%type;
1414: l_earnings_per_share ar_cmgt_financial_data.earnings_per_share%type;
1415: l_financial_data_id ar_cmgt_financial_data.financial_data_id%type;
1416: l_party_id ar_cmgt_case_folders.party_id%type;
1417: l_cust_account_id ar_cmgt_case_folders.cust_account_id%type;

Line 1414: l_earnings_per_share ar_cmgt_financial_data.earnings_per_share%type;

1410: l_non_operating_expenses ar_cmgt_financial_data.non_operating_expenses%type;
1411: l_pre_tax_net_income ar_cmgt_financial_data.pre_tax_net_income%type;
1412: l_income_taxes ar_cmgt_financial_data.income_taxes%type;
1413: l_net_income ar_cmgt_financial_data.net_income%type;
1414: l_earnings_per_share ar_cmgt_financial_data.earnings_per_share%type;
1415: l_financial_data_id ar_cmgt_financial_data.financial_data_id%type;
1416: l_party_id ar_cmgt_case_folders.party_id%type;
1417: l_cust_account_id ar_cmgt_case_folders.cust_account_id%type;
1418: l_site_use_id ar_cmgt_case_folders.site_use_id%type;

Line 1415: l_financial_data_id ar_cmgt_financial_data.financial_data_id%type;

1411: l_pre_tax_net_income ar_cmgt_financial_data.pre_tax_net_income%type;
1412: l_income_taxes ar_cmgt_financial_data.income_taxes%type;
1413: l_net_income ar_cmgt_financial_data.net_income%type;
1414: l_earnings_per_share ar_cmgt_financial_data.earnings_per_share%type;
1415: l_financial_data_id ar_cmgt_financial_data.financial_data_id%type;
1416: l_party_id ar_cmgt_case_folders.party_id%type;
1417: l_cust_account_id ar_cmgt_case_folders.cust_account_id%type;
1418: l_site_use_id ar_cmgt_case_folders.site_use_id%type;
1419: l_limit_currency ar_cmgt_case_folders.limit_currency%type;

Line 1460: reduces the number of reads on ar_cmgt_financial_data

1456: financial_data_id on the maximum date that matches
1457: the parameters (currency,party,customer,site).
1458:
1459: This sql has same result as predecessor only it
1460: reduces the number of reads on ar_cmgt_financial_data
1461: to a single read */
1462:
1463: SELECT to_number(
1464: substr(

Line 1470: FROM ar_cmgt_financial_data

1466: ltrim(to_char(financial_data_id,
1467: '0999999999999999999999')))
1468: ,9))
1469: INTO l_financial_data_id
1470: FROM ar_cmgt_financial_data
1471: WHERE reporting_currency = l_limit_currency
1472: AND party_id = l_party_id
1473: AND cust_account_id = l_cust_account_id
1474: AND site_use_id = l_site_use_id;

Line 1483: p_errmsg := 'Error while getting max data from ar_cmgt_financial_data '||

1479: WHEN TOO_MANY_ROWS THEN
1480: NULL;
1481: WHEN OTHERS THEN
1482: p_resultout := 1;
1483: p_errmsg := 'Error while getting max data from ar_cmgt_financial_data '||
1484: ' SqlError '|| sqlerrm;
1485: ar_cmgt_util.wf_debug(p_case_folder_id, p_errmsg);
1486: return;
1487:

Line 1555: FROM ar_cmgt_financial_data

1551: l_pre_tax_net_income ,
1552: l_income_taxes ,
1553: l_net_income ,
1554: l_earnings_per_share
1555: FROM ar_cmgt_financial_data
1556: WHERE financial_data_id = l_financial_data_id;
1557:
1558: EXCEPTION
1559: WHEN NO_DATA_FOUND THEN

Line 1565: p_errmsg := 'Error while getting records from ar_cmgt_financial_data '||

1561: WHEN TOO_MANY_ROWS THEN
1562: NULL;
1563: WHEN OTHERS THEN
1564: p_resultout := 1;
1565: p_errmsg := 'Error while getting records from ar_cmgt_financial_data '||
1566: ' SqlError '|| sqlerrm;
1567: ar_cmgt_util.wf_debug(p_case_folder_id, p_errmsg);
1568: return;
1569: