VIEW: APPS.AR_INVENTORY_L_V

Source

View Text - Preformatted

SELECT /*+ INDEX(l AR_XLA_LINES_EXTRACT_N1) */ mtlbf.description inv_item_description ,mtlbf.global_attribute1 inv_item_global_attr1 ,mtlbf.global_attribute10 inv_item_global_attr10 ,mtlbf.global_attribute2 inv_item_global_attr2 ,mtlbf.global_attribute3 inv_item_global_attr3 ,mtlbf.global_attribute4 inv_item_global_attr4 ,mtlbf.global_attribute5 inv_item_global_attr5 ,mtlbf.global_attribute6 inv_item_global_attr6 ,mtlbf.global_attribute7 inv_item_global_attr7 ,mtlbf.global_attribute8 inv_item_global_attr8 ,mtlbf.global_attribute9 inv_item_global_attr9 ,mtlbf.global_attribute_category inv_item_global_attr_cat ,mtlbf.inventory_item_id inv_item_inventory_item_id ,mtlbf.item_type inv_item_type ,mtlbf.sales_account inv_item_sales_account ,mtlbf.serial_number_control_code inv_item_serial_num_ctrl_code ,mtlicf.category_id inv_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) 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

View Text - HTML Formatted

SELECT /*+ INDEX(L AR_XLA_LINES_EXTRACT_N1) */ MTLBF.DESCRIPTION INV_ITEM_DESCRIPTION
, MTLBF.GLOBAL_ATTRIBUTE1 INV_ITEM_GLOBAL_ATTR1
, MTLBF.GLOBAL_ATTRIBUTE10 INV_ITEM_GLOBAL_ATTR10
, MTLBF.GLOBAL_ATTRIBUTE2 INV_ITEM_GLOBAL_ATTR2
, MTLBF.GLOBAL_ATTRIBUTE3 INV_ITEM_GLOBAL_ATTR3
, MTLBF.GLOBAL_ATTRIBUTE4 INV_ITEM_GLOBAL_ATTR4
, MTLBF.GLOBAL_ATTRIBUTE5 INV_ITEM_GLOBAL_ATTR5
, MTLBF.GLOBAL_ATTRIBUTE6 INV_ITEM_GLOBAL_ATTR6
, MTLBF.GLOBAL_ATTRIBUTE7 INV_ITEM_GLOBAL_ATTR7
, MTLBF.GLOBAL_ATTRIBUTE8 INV_ITEM_GLOBAL_ATTR8
, MTLBF.GLOBAL_ATTRIBUTE9 INV_ITEM_GLOBAL_ATTR9
, MTLBF.GLOBAL_ATTRIBUTE_CATEGORY INV_ITEM_GLOBAL_ATTR_CAT
, MTLBF.INVENTORY_ITEM_ID INV_ITEM_INVENTORY_ITEM_ID
, MTLBF.ITEM_TYPE INV_ITEM_TYPE
, MTLBF.SALES_ACCOUNT INV_ITEM_SALES_ACCOUNT
, MTLBF.SERIAL_NUMBER_CONTROL_CODE INV_ITEM_SERIAL_NUM_CTRL_CODE
, MTLICF.CATEGORY_ID INV_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) 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