[Home] [Help]
View: AR_ITEM_CAT_L_VL
Product: | AR - Receivables |
Description: | inventory item category line extract |
Implementation/DBA Data: |
APPS.AR_ITEM_CAT_L_VL
|
View Text
SELECT /*+ INDEX(L AR_XLA_LINES_EXTRACT_N1) */ 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 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' GROUP BY MTLCTLF.DESCRIPTION
, L.EVENT_ID
, L.LINE_NUMBER
, MTLCTLF.LANGUAGE
, L.LEDGER_ID
Columns
Name |
INV_ITEM_CAT_DESCRIPTION |
EVENT_ID |
LINE_NUMBER |
LANGUAGE |
LEDGER_ID |