1. Tables and Views for Financials
  2. AR_ITEM_CAT_L_VL

AR_ITEM_CAT_L_VL

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: VIEW

Columns

Name

INV_ITEM_CAT_DESCRIPTION

EVENT_ID

LINE_NUMBER

LANGUAGE

LEDGER_ID

Query

SQL_Statement

SELECT /*+ INDEX(l ar_xla_lines_extract_n1) leading(edcs l ITEMCATS) */ mtlctlf.description inv_item_cat_description ,l.event_id event_id ,l.line_number line_number ,mtlctlf.language language ,l.ledger_id ledger_id FROM

(SELECT ITEMCATS.inventory_item_id inventory_item_id,

ORG.organization_id organization_id,

ITEMCATS.category_set_id category_set_id,

ITEMCATS.category_id category_id

FROM egp_item_cat_assignments ITEMCATS,

egp_category_sets_b CATSETS,

inv_org_parameters ORG

WHERE CATSETS.category_set_id = ITEMCATS.category_set_id

AND EXISTS ( SELECT /*+ NO_UNNEST */ 1

FROM egp_item_org_associations ITEMS

WHERE ORG.organization_id = ITEMS.organization_id

AND ITEMS.inventory_item_id = ITEMCATS.inventory_item_id)

AND ( ( CATSETS.control_level = 1 AND ITEMCATS.organization_id = ORG.master_organization_id )

OR

( CATSETS.control_level = 2 AND ITEMCATS.organization_id = ORG.item_definition_org_id ) )

) mtlic ,

EGP_CATEGORIES_TL mtlctlf ,ar_xla_lines_extract l ,egp_Default_category_sets edcs WHERE l.inventory_item_id = mtlic.inventory_item_id (+) AND nvl(l.warehouse_id, l.so_organization_id) = mtlic.organization_id (+)

AND mtlic.category_set_id = edcs.category_set_id (+)

AND edcs.functional_area_id = 1

AND mtlctlf.LANGUAGE(+) = USERENV('LANG')

AND mtlic.category_id = mtlctlf.category_id (+) AND l.level_flag = 'L' GROUP BY mtlctlf.description ,l.event_id ,l.line_number ,mtlctlf.language ,l.ledger_id