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_DP_DYNAMIC_PKG dependencies on FEM_LN_ITEMS_ATTR

Line 1085: fem_ln_items_attr flia,

1081: SYSDATE,
1082: FND_GLOBAL.USER_ID,
1083: FND_GLOBAL.LOGIN_ID
1084: FROM gcs_entry_lines_gt fb,
1085: fem_ln_items_attr flia,
1086: fem_ext_acct_types_attr fea_attr
1087: WHERE fb.line_item_id = flia.line_item_id
1088: AND flia.attribute_id = l_line_item_type_attr
1089: AND flia.version_id = l_line_item_type_version

Line 1125: fem_ln_items_attr flia,

1121: SYSDATE,
1122: FND_GLOBAL.USER_ID,
1123: FND_GLOBAL.LOGIN_ID
1124: FROM gcs_entry_lines_gt fb,
1125: fem_ln_items_attr flia,
1126: fem_ext_acct_types_attr fea_attr
1127: WHERE fb.line_item_id = flia.line_item_id
1128: AND flia.attribute_id = l_line_item_type_attr
1129: AND flia.version_id = l_line_item_type_version

Line 1174: FROM fem_ln_items_attr flia,

1170: gel.ytd_debit_balance_e = gel.ptd_debit_balance_e,
1171: gel.ytd_credit_balance_e = gel.ptd_credit_balance_e
1172: WHERE gel.entry_id = '||l_entry_id ||'
1173: AND EXISTS ( SELECT ''X''
1174: FROM fem_ln_items_attr flia,
1175: fem_ext_acct_types_attr feata
1176: WHERE feata.dim_attribute_varchar_member IN (''REVENUE'', ''EXPENSE'')
1177: AND flia.attribute_id ='|| g_li_eat_attr_id ||'
1178: AND flia.version_id ='|| g_li_eat_ver_id ||'

Line 1191: FROM fem_ln_items_attr flia,

1187: gel.ytd_debit_balance_e = gel.ptd_debit_balance_e,
1188: gel.ytd_credit_balance_e = gel.ptd_credit_balance_e
1189: WHERE gel.entry_id = l_entry_id
1190: AND EXISTS ( SELECT 'X'
1191: FROM fem_ln_items_attr flia,
1192: fem_ext_acct_types_attr feata
1193: WHERE feata.dim_attribute_varchar_member IN ('REVENUE', 'EXPENSE')
1194: AND flia.attribute_id = g_li_eat_attr_id
1195: AND flia.version_id = g_li_eat_ver_id

Line 1215: fem_ln_items_attr flia,

1211: + NVL (gel.ptd_credit_balance_e, 0),
1212: NVL (fb.ytd_debit_balance_e, 0)
1213: + NVL (gel.ptd_debit_balance_e, 0)
1214: FROM fem_balances fb,
1215: fem_ln_items_attr flia,
1216: fem_ext_acct_types_attr feata
1217: WHERE feata.dim_attribute_varchar_member IN
1218: (''REVENUE'', ''EXPENSE'')
1219: AND flia.attribute_id ='|| g_li_eat_attr_id ||'

Line 1240: fem_ln_items_attr flia,

1236: + NVL (gel.ptd_credit_balance_e, 0),
1237: NVL (fb.ytd_debit_balance_e, 0)
1238: + NVL (gel.ptd_debit_balance_e, 0)
1239: FROM fem_balances fb,
1240: fem_ln_items_attr flia,
1241: fem_ext_acct_types_attr feata
1242: WHERE feata.dim_attribute_varchar_member IN ('REVENUE', 'EXPENSE')
1243: AND flia.attribute_id = g_li_eat_attr_id
1244: AND flia.version_id = g_li_eat_ver_id