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_LN_ITEMS_ATTR

Line 443: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||

439: ' AND fb_in.currency_code = ''' || p_from_ccy || '''' || g_nl ||
440: ' AND fb_in.ledger_id = ' || p_ledger_id || g_nl ||
441: ' AND fb_in.entity_id = ' || p_entity_id || g_nl ||
442: ' GROUP BY ' || g_nl ||' fb_in.line_item_id) fb,' || g_nl ||
443: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
444: ' FEM_EXT_ACCT_TYPES_ATTR fxata,' || g_nl ||
445: ' GCS_HISTORICAL_RATES ghr' || g_nl ||
446: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
447: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||

Line 526: FEM_LN_ITEMS_ATTR li,

522: AND fb_in.currency_code = p_from_ccy
523: AND fb_in.ledger_id = p_ledger_id
524: AND fb_in.entity_id = p_entity_id
525: GROUP BY fb_in.line_item_id) fb,
526: FEM_LN_ITEMS_ATTR li,
527: FEM_EXT_ACCT_TYPES_ATTR fxata,
528: GCS_HISTORICAL_RATES ghr
529: WHERE li.line_item_id = fb.line_item_id
530: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

Line 616: ' FEM_LN_ITEMS_ATTR li,' || 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 ||
614: ' AND fb_in.ledger_id = ' || p_ledger_id || g_nl ||
615: ' AND fb_in.entity_id = ' || p_entity_id || ') fb,' || g_nl ||
616: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
617: ' FEM_EXT_ACCT_TYPES_ATTR fxata,' || g_nl ||
618: ' GCS_HISTORICAL_RATES ghr' || g_nl ||
619: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
620: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||

Line 698: FEM_LN_ITEMS_ATTR li,

694: AND fb_in.source_system_code = p_source_system_code
695: AND fb_in.currency_code = p_from_ccy
696: AND fb_in.ledger_id = p_ledger_id
697: AND fb_in.entity_id = p_entity_id) fb,
698: FEM_LN_ITEMS_ATTR li,
699: FEM_EXT_ACCT_TYPES_ATTR fxata,
700: GCS_HISTORICAL_RATES ghr
701: WHERE li.line_item_id = fb.line_item_id
702: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

Line 873: ' FEM_LN_ITEMS_ATTR li,' || 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 ||
876: 'AND li.line_item_id = fb.line_item_id' || g_nl ||
877: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||

Line 969: FEM_LN_ITEMS_ATTR li,

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
972: AND li.line_item_id = fb.line_item_id
973: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

Line 1074: ' FEM_LN_ITEMS_ATTR li,' || 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 ||
1077: 'AND li.line_item_id = fb.line_item_id' || g_nl ||
1078: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||

Line 1169: FEM_LN_ITEMS_ATTR li,

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
1172: AND li.line_item_id = fb.line_item_id
1173: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id