AR_INVENTORY_L_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

INV_ITEM_GLOBAL_ATTR1 INV_ITEM_GLOBAL_ATTR10 INV_ITEM_GLOBAL_ATTR2 INV_ITEM_GLOBAL_ATTR3 INV_ITEM_GLOBAL_ATTR4 INV_ITEM_GLOBAL_ATTR5 INV_ITEM_GLOBAL_ATTR6 INV_ITEM_GLOBAL_ATTR7 INV_ITEM_GLOBAL_ATTR8 INV_ITEM_GLOBAL_ATTR9 INV_ITEM_GLOBAL_ATTR_CAT INV_ITEM_INVENTORY_ITEM_ID ITEM INV_ITEM_TYPE INV_ITEM_SALES_ACCOUNT INV_ITEM_SERIAL_NUM_CTRL_CODE INV_ITEM_CAT_ID EVENT_ID LINE_NUMBER LANGUAGE LEDGER_ID WAREHOUSE_CODE WAREHOUSE_NAME INV_ITEM_CAT_CODE

Query

SQL_Statement

SELECT /*+ INDEX(l ar_xla_lines_extract_n1) leading(edcs l ITEMCATS) */ distinct 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_number ITEM , 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 , mtlcbf.category_code inv_item_cat_code FROM EGP_SYSTEM_ITEMS_VL mtlbf , (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 ) ) ) mtlicf , EGP_CATEGORIES_B mtlcbf , EGP_CATEGORY_SET_VALID_CATS mtlcsf , INV_ORGANIZATION_DEFINITIONS_V o , ar_xla_lines_extract l, egp_Default_category_sets edcs 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 = edcs.category_set_id (+) AND edcs.functional_area_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)