[Home] [Help]
280: 0
281: FROM
282: GCS_ENTRY_LINES l2,
283: FEM_LN_ITEMS_ATTR lia,
284: FEM_EXT_ACCT_TYPES_ATTR feata
285: WHERE l2.entry_id = l_entry_list(i)
286: AND lia.attribute_id = g_li_eat_attr_id
287: AND lia.version_id = g_li_eat_ver_id
288: AND lia.line_item_id = l2.line_item_id
435: FROM
436: --Bugfix 5449718: Remove source, target entry, and category joins.
437: GCS_ENTRY_LINES l2,
438: FEM_LN_ITEMS_ATTR lia,
439: FEM_EXT_ACCT_TYPES_ATTR feata
440: WHERE
441: l2.entry_id = l_entry_list(i)
442: AND lia.attribute_id = g_li_eat_attr_id
443: AND lia.version_id = g_li_eat_ver_id
531: 0,
532: ytd_debit_balance_e,
533: ytd_credit_balance_e
534: FROM
535: --Bugfix 5449718: Remove source, target entry, and category joins. Add join to fem_ext_acct_types_attr
536: GCS_ENTRY_LINES l2,
537: FEM_LN_ITEMS_ATTR lia,
538: FEM_EXT_ACCT_TYPES_ATTR feata
539: WHERE
534: FROM
535: --Bugfix 5449718: Remove source, target entry, and category joins. Add join to fem_ext_acct_types_attr
536: GCS_ENTRY_LINES l2,
537: FEM_LN_ITEMS_ATTR lia,
538: FEM_EXT_ACCT_TYPES_ATTR feata
539: WHERE
540: l2.entry_id = l_entry_list(i)
541: AND lia.attribute_id = g_li_eat_attr_id
542: AND lia.version_id = g_li_eat_ver_id