View: AR_CM_INVENTORY_L_V

Product:	AR - Receivables
Description:	credit memo item line line extract
Implementation/DBA Data:	APPS.AR_CM_INVENTORY_L_V

View Text

SELECT /*+INDEX(L AR_XLA_LINES_EXTRACT_N1)*/ MTLBF.DESCRIPTION CM_LINE_ITEM_DESCRIPTION
, MTLBF.GLOBAL_ATTRIBUTE1 CM_LINE_ITEM_GLOBAL_ATTR1
, MTLBF.GLOBAL_ATTRIBUTE10 CM_LINE_ITEM_GLOBAL_ATTR10
, MTLBF.GLOBAL_ATTRIBUTE2 CM_LINE_ITEM_GLOBAL_ATTR2
, MTLBF.GLOBAL_ATTRIBUTE3 CM_LINE_ITEM_GLOBAL_ATTR3
, MTLBF.GLOBAL_ATTRIBUTE4 CM_LINE_ITEM_GLOBAL_ATTR4
, MTLBF.GLOBAL_ATTRIBUTE5 CM_LINE_ITEM_GLOBAL_ATTR5
, MTLBF.GLOBAL_ATTRIBUTE6 CM_LINE_ITEM_GLOBAL_ATTR6
, MTLBF.GLOBAL_ATTRIBUTE7 CM_LINE_ITEM_GLOBAL_ATTR7
, MTLBF.GLOBAL_ATTRIBUTE8 CM_LINE_ITEM_GLOBAL_ATTR8
, MTLBF.GLOBAL_ATTRIBUTE9 CM_LINE_ITEM_GLOBAL_ATTR9
, MTLBF.GLOBAL_ATTRIBUTE_CATEGORY CM_LINE_ITEM_GLOBAL_ATTR_CAT
, MTLBF.INVENTORY_ITEM_ID CM_LINE_ITEM_ITEM_ID
, MTLBF.ITEM_TYPE CM_LINE_ITEM_TYPE
, MTLBF.SALES_ACCOUNT CM_LINE_ITEM_SALES_ACCOUNT
, MTLBF.SERIAL_NUMBER_CONTROL_CODE CM_LINE_ITEM_SRL_NM_CTRL_CODE
, MTLICF.CATEGORY_ID CM_LINE_ITEM_CAT_ID
, L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, L.LANGUAGE LANGUAGE
, L.LEDGER_ID LEDGER_ID
, O.ORGANIZATION_CODE WAREHOUSE_CODE
, O.ORGANIZATION_NAME WAREHOUSE_NAME
FROM MTL_SYSTEM_ITEMS_B MTLBF
, MTL_ITEM_CATEGORIES MTLICF
, MTL_CATEGORIES_B MTLCBF
, MTL_CATEGORY_SET_VALID_CATS MTLCSF
, ORG_ORGANIZATION_DEFINITIONS O
, AR_XLA_LINES_EXTRACT L
WHERE MTLBF.ORGANIZATION_ID = NVL(L.WAREHOUSE_ID
, L.SO_ORGANIZATION_ID)
AND MTLBF.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID
AND L.INVENTORY_ITEM_ID = MTLICF.INVENTORY_ITEM_ID (+)
AND L.LEVEL_FLAG = 'L'
AND MTLICF.ORGANIZATION_ID (+) = NVL(L.WAREHOUSE_ID
, L.SO_ORGANIZATION_ID)
AND MTLICF.CATEGORY_SET_ID (+) = 1
AND MTLCBF.CATEGORY_ID (+) = MTLICF.CATEGORY_ID
AND MTLCSF.CATEGORY_ID (+) = MTLICF.CATEGORY_ID
AND MTLCSF.CATEGORY_SET_ID (+) = MTLICF.CATEGORY_SET_ID
AND O.ORGANIZATION_ID = NVL(L.WAREHOUSE_ID
, L.SO_ORGANIZATION_ID)
AND L.EVENT_TYPE_CODE IN ('CM_CREATE'
, 'CM_UPDATE') GROUP BY MTLBF.DESCRIPTION
, MTLBF.GLOBAL_ATTRIBUTE1
, MTLBF.GLOBAL_ATTRIBUTE10
, MTLBF.GLOBAL_ATTRIBUTE2
, MTLBF.GLOBAL_ATTRIBUTE3
, MTLBF.GLOBAL_ATTRIBUTE4
, MTLBF.GLOBAL_ATTRIBUTE5
, MTLBF.GLOBAL_ATTRIBUTE6
, MTLBF.GLOBAL_ATTRIBUTE7
, MTLBF.GLOBAL_ATTRIBUTE8
, MTLBF.GLOBAL_ATTRIBUTE9
, MTLBF.GLOBAL_ATTRIBUTE_CATEGORY
, MTLBF.INVENTORY_ITEM_ID
, MTLBF.ITEM_TYPE
, MTLBF.SALES_ACCOUNT
, MTLBF.SERIAL_NUMBER_CONTROL_CODE
, MTLICF.CATEGORY_ID
, L.EVENT_ID
, L.LINE_NUMBER
, L.LANGUAGE
, L.LEDGER_ID
, O.ORGANIZATION_CODE
, O.ORGANIZATION_NAME

Columns