VIEW: APPS.AR_CM_ITEM_CAT_L_VL

Source

View Text - Preformatted

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ mtlctlf.description cm_line_item_cat_description ,l.event_id event_id ,l.line_number line_number ,mtlctlf.language language ,l.ledger_id ledger_id FROM mtl_item_categories mtlic ,mtl_categories_tl mtlctlf ,ar_xla_lines_extract l WHERE l.inventory_item_id = mtlic.inventory_item_id (+) AND nvl(l.warehouse_id, l.so_organization_id) = mtlic.organization_id (+) AND 1 = mtlic.category_set_id (+) AND mtlic.category_id = mtlctlf.category_id (+) AND l.level_flag = 'L' AND l.event_type_code IN ('CM_CREATE','CM_UPDATE') GROUP BY mtlctlf.description ,l.event_id ,l.line_number ,mtlctlf.language ,l.ledger_id

View Text - HTML Formatted

SELECT /*+INDEX(L AR_XLA_LINES_EXTRACT_N1)*/ MTLCTLF.DESCRIPTION CM_LINE_ITEM_CAT_DESCRIPTION
, L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, MTLCTLF.LANGUAGE LANGUAGE
, L.LEDGER_ID LEDGER_ID
FROM MTL_ITEM_CATEGORIES MTLIC
, MTL_CATEGORIES_TL MTLCTLF
, AR_XLA_LINES_EXTRACT L
WHERE L.INVENTORY_ITEM_ID = MTLIC.INVENTORY_ITEM_ID (+)
AND NVL(L.WAREHOUSE_ID
, L.SO_ORGANIZATION_ID) = MTLIC.ORGANIZATION_ID (+)
AND 1 = MTLIC.CATEGORY_SET_ID (+)
AND MTLIC.CATEGORY_ID = MTLCTLF.CATEGORY_ID (+)
AND L.LEVEL_FLAG = 'L'
AND L.EVENT_TYPE_CODE IN ('CM_CREATE'
, 'CM_UPDATE') GROUP BY MTLCTLF.DESCRIPTION
, L.EVENT_ID
, L.LINE_NUMBER
, MTLCTLF.LANGUAGE
, L.LEDGER_ID