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_RE_DYNAMIC_PKG dependencies on FEM_BALANCES

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

439: p_round_factor || g_nl ||
440: 'FROM (SELECT' || g_nl ||
441: ' fb_in.line_item_id,' || g_nl ||' SUM(ytd_debit_balance_e) sum_ytd_debit_balance_e,' || g_nl ||
442: ' SUM(ytd_credit_balance_e) sum_ytd_credit_balance_e' || g_nl ||
443: ' FROM FEM_BALANCES fb_in' || g_nl ||
444: ' WHERE fb_in.dataset_code = ' || p_hier_dataset_code || g_nl ||
445: ' AND fb_in.cal_period_id = ' || p_cal_period_id || g_nl ||
446: ' AND fb_in.source_system_code = ' || p_source_system_code || g_nl ||
447: ' AND fb_in.currency_code = ''' || p_from_ccy || '''' || g_nl ||

Line 528: FROM FEM_BALANCES fb_in

524: p_round_factor
525: FROM (SELECT
526: fb_in.line_item_id, SUM(ytd_debit_balance_e) sum_ytd_debit_balance_e,
527: SUM(ytd_credit_balance_e) sum_ytd_credit_balance_e
528: FROM FEM_BALANCES fb_in
529: WHERE fb_in.dataset_code = p_hier_dataset_code
530: AND fb_in.cal_period_id = p_cal_period_id
531: AND fb_in.source_system_code = p_source_system_code
532: AND fb_in.currency_code = p_from_ccy

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

610: p_round_factor || g_nl ||
611: 'FROM (SELECT' || g_nl ||
612: ' fb_in.line_item_id,' || g_nl ||' ytd_debit_balance_e sum_ytd_debit_balance_e,' || g_nl ||
613: ' ytd_credit_balance_e sum_ytd_credit_balance_e' || g_nl ||
614: ' FROM FEM_BALANCES fb_in' || g_nl ||
615: ' WHERE fb_in.dataset_code = ' || p_hier_dataset_code || g_nl ||
616: ' AND fb_in.cal_period_id = ' || p_cal_period_id || g_nl ||
617: ' AND fb_in.source_system_code = ' || p_source_system_code || g_nl ||
618: ' AND fb_in.currency_code = ''' || p_from_ccy || '''' || g_nl ||

Line 698: FROM FEM_BALANCES fb_in

694: p_round_factor
695: FROM (SELECT
696: fb_in.line_item_id, ytd_debit_balance_e sum_ytd_debit_balance_e,
697: ytd_credit_balance_e sum_ytd_credit_balance_e
698: FROM FEM_BALANCES fb_in
699: WHERE fb_in.dataset_code = p_hier_dataset_code
700: AND fb_in.cal_period_id = p_cal_period_id
701: AND fb_in.source_system_code = p_source_system_code
702: AND fb_in.currency_code = p_from_ccy

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

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

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

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

Line 964: FROM FEM_BALANCES fb_in

960: fb_in.line_item_id, SUM(ptd_debit_balance_e) sum_ptd_debit_balance_e,
961: SUM(ptd_credit_balance_e) sum_ptd_credit_balance_e,
962: SUM(ytd_debit_balance_e) sum_ytd_debit_balance_e,
963: SUM(ytd_credit_balance_e) sum_ytd_credit_balance_e
964: FROM FEM_BALANCES fb_in
965: WHERE fb_in.dataset_code = p_hier_dataset_code
966: AND fb_in.cal_period_id = p_cal_period_id
967: AND fb_in.source_system_code = p_source_system_code
968: AND fb_in.currency_code = p_from_ccy

Line 972: FEM_BALANCES fbp,

968: AND fb_in.currency_code = p_from_ccy
969: AND fb_in.ledger_id = p_ledger_id
970: AND fb_in.entity_id = p_entity_id
971: GROUP BY fb_in.line_item_id) fb,
972: FEM_BALANCES fbp,
973: GCS_HISTORICAL_RATES ghr,
974: FEM_LN_ITEMS_ATTR li,
975: FEM_EXT_ACCT_TYPES_ATTR fxata
976: 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 1162: FROM FEM_BALANCES fb_in

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

Line 1169: FEM_BALANCES fbp,

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