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.GCS_TRANS_HRATES_DYNAMIC_PKG dependencies on FEM_BALANCES

Line 435: ' FROM FEM_BALANCES fb_in' || g_nl ||

431: p_round_factor || g_nl ||
432: 'FROM (SELECT' || g_nl ||
433: ' fb_in.line_item_id,' || g_nl ||' SUM(ytd_debit_balance_e) sum_ytd_debit_balance_e,' || g_nl ||
434: ' SUM(ytd_credit_balance_e) sum_ytd_credit_balance_e' || g_nl ||
435: ' FROM FEM_BALANCES fb_in' || g_nl ||
436: ' WHERE fb_in.dataset_code = ' || p_hier_dataset_code || g_nl ||
437: ' AND fb_in.cal_period_id = ' || p_cal_period_id || g_nl ||
438: ' AND fb_in.source_system_code = ' || p_source_system_code || g_nl ||
439: ' AND fb_in.currency_code = ''' || p_from_ccy || '''' || g_nl ||

Line 518: FROM FEM_BALANCES fb_in

514: p_round_factor
515: FROM (SELECT
516: fb_in.line_item_id, SUM(ytd_debit_balance_e) sum_ytd_debit_balance_e,
517: SUM(ytd_credit_balance_e) sum_ytd_credit_balance_e
518: FROM FEM_BALANCES fb_in
519: WHERE fb_in.dataset_code = p_hier_dataset_code
520: AND fb_in.cal_period_id = p_cal_period_id
521: AND fb_in.source_system_code = p_source_system_code
522: AND fb_in.currency_code = p_from_ccy

Line 609: ' FROM FEM_BALANCES fb_in' || g_nl ||

605: p_round_factor || g_nl ||
606: 'FROM (SELECT' || g_nl ||
607: ' fb_in.line_item_id,' || g_nl ||' ytd_debit_balance_e sum_ytd_debit_balance_e,' || g_nl ||
608: ' ytd_credit_balance_e sum_ytd_credit_balance_e' || g_nl ||
609: ' FROM FEM_BALANCES fb_in' || g_nl ||
610: ' WHERE fb_in.dataset_code = ' || p_hier_dataset_code || g_nl ||
611: ' AND fb_in.cal_period_id = ' || p_cal_period_id || g_nl ||
612: ' AND fb_in.source_system_code = ' || p_source_system_code || g_nl ||
613: ' AND fb_in.currency_code = ''' || p_from_ccy || '''' || g_nl ||

Line 691: FROM FEM_BALANCES fb_in

687: p_round_factor
688: FROM (SELECT
689: fb_in.line_item_id, ytd_debit_balance_e sum_ytd_debit_balance_e,
690: ytd_credit_balance_e sum_ytd_credit_balance_e
691: FROM FEM_BALANCES fb_in
692: WHERE fb_in.dataset_code = p_hier_dataset_code
693: AND fb_in.cal_period_id = p_cal_period_id
694: AND fb_in.source_system_code = p_source_system_code
695: AND fb_in.currency_code = p_from_ccy

Line 863: ' FROM FEM_BALANCES fb_in' || g_nl ||

859: ' fb_in.line_item_id,' || g_nl ||' SUM(ptd_debit_balance_e) sum_ptd_debit_balance_e,' || g_nl ||
860: ' SUM(ptd_credit_balance_e) sum_ptd_credit_balance_e,' || g_nl ||
861: ' SUM(ytd_debit_balance_e) sum_ytd_debit_balance_e,' || g_nl ||
862: ' SUM(ytd_credit_balance_e) sum_ytd_credit_balance_e' || g_nl ||
863: ' FROM FEM_BALANCES fb_in' || g_nl ||
864: ' WHERE fb_in.dataset_code = ' || p_hier_dataset_code || g_nl ||
865: ' AND fb_in.cal_period_id = ' || p_cal_period_id || g_nl ||
866: ' AND fb_in.source_system_code = ' || p_source_system_code || g_nl ||
867: ' AND fb_in.currency_code = ''' || p_from_ccy || '''' || g_nl ||

Line 871: ' FEM_BALANCES fbp,' || g_nl ||

867: ' AND fb_in.currency_code = ''' || p_from_ccy || '''' || g_nl ||
868: ' AND fb_in.ledger_id = ' || p_ledger_id || g_nl ||
869: ' AND fb_in.entity_id = ' || p_entity_id || g_nl ||
870: ' GROUP BY ' || g_nl ||' fb_in.line_item_id) fb,' || g_nl ||
871: ' FEM_BALANCES fbp,' || g_nl ||
872: ' GCS_HISTORICAL_RATES ghr,' || g_nl ||
873: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
874: ' FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
875: 'WHERE fbp.created_by_object_id (+)= ' || fb_object_id || g_nl ||

Line 959: FROM FEM_BALANCES fb_in

955: fb_in.line_item_id, SUM(ptd_debit_balance_e) sum_ptd_debit_balance_e,
956: SUM(ptd_credit_balance_e) sum_ptd_credit_balance_e,
957: SUM(ytd_debit_balance_e) sum_ytd_debit_balance_e,
958: SUM(ytd_credit_balance_e) sum_ytd_credit_balance_e
959: FROM FEM_BALANCES fb_in
960: WHERE fb_in.dataset_code = p_hier_dataset_code
961: AND fb_in.cal_period_id = p_cal_period_id
962: AND fb_in.source_system_code = p_source_system_code
963: AND fb_in.currency_code = p_from_ccy

Line 967: FEM_BALANCES fbp,

963: AND fb_in.currency_code = p_from_ccy
964: AND fb_in.ledger_id = p_ledger_id
965: AND fb_in.entity_id = p_entity_id
966: GROUP BY fb_in.line_item_id) fb,
967: FEM_BALANCES fbp,
968: GCS_HISTORICAL_RATES ghr,
969: FEM_LN_ITEMS_ATTR li,
970: FEM_EXT_ACCT_TYPES_ATTR fxata
971: WHERE fbp.created_by_object_id (+)= fb_object_id

Line 1065: ' FROM FEM_BALANCES fb_in' || g_nl ||

1061: ' fb_in.line_item_id,' || g_nl ||' ptd_debit_balance_e sum_ptd_debit_balance_e,' || g_nl ||
1062: ' ptd_credit_balance_e sum_ptd_credit_balance_e,' || g_nl ||
1063: ' ytd_debit_balance_e sum_ytd_debit_balance_e,' || g_nl ||
1064: ' ytd_credit_balance_e sum_ytd_credit_balance_e' || g_nl ||
1065: ' FROM FEM_BALANCES fb_in' || g_nl ||
1066: ' WHERE fb_in.dataset_code = ' || p_hier_dataset_code || g_nl ||
1067: ' AND fb_in.cal_period_id = ' || p_cal_period_id || g_nl ||
1068: ' AND fb_in.source_system_code = ' || p_source_system_code || g_nl ||
1069: ' AND fb_in.currency_code = ''' || p_from_ccy || '''' || g_nl ||

Line 1072: ' FEM_BALANCES fbp,' || g_nl ||

1068: ' AND fb_in.source_system_code = ' || p_source_system_code || g_nl ||
1069: ' AND fb_in.currency_code = ''' || p_from_ccy || '''' || g_nl ||
1070: ' AND fb_in.ledger_id = ' || p_ledger_id || g_nl ||
1071: ' AND fb_in.entity_id = ' || p_entity_id || ') fb,' || g_nl ||
1072: ' FEM_BALANCES fbp,' || g_nl ||
1073: ' GCS_HISTORICAL_RATES ghr,' || g_nl ||
1074: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
1075: ' FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
1076: 'WHERE fbp.created_by_object_id (+)= ' || fb_object_id || g_nl ||

Line 1160: FROM FEM_BALANCES fb_in

1156: fb_in.line_item_id, ptd_debit_balance_e sum_ptd_debit_balance_e,
1157: ptd_credit_balance_e sum_ptd_credit_balance_e,
1158: ytd_debit_balance_e sum_ytd_debit_balance_e,
1159: ytd_credit_balance_e sum_ytd_credit_balance_e
1160: FROM FEM_BALANCES fb_in
1161: WHERE fb_in.dataset_code = p_hier_dataset_code
1162: AND fb_in.cal_period_id = p_cal_period_id
1163: AND fb_in.source_system_code = p_source_system_code
1164: AND fb_in.currency_code = p_from_ccy

Line 1167: FEM_BALANCES fbp,

1163: AND fb_in.source_system_code = p_source_system_code
1164: AND fb_in.currency_code = p_from_ccy
1165: AND fb_in.ledger_id = p_ledger_id
1166: AND fb_in.entity_id = p_entity_id) fb,
1167: FEM_BALANCES fbp,
1168: GCS_HISTORICAL_RATES ghr,
1169: FEM_LN_ITEMS_ATTR li,
1170: FEM_EXT_ACCT_TYPES_ATTR fxata
1171: WHERE fbp.created_by_object_id (+)= fb_object_id