VRM_INVENTORY_L_V

Details

• Schema: FUSION

• Object owner: VRM

• 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 INV_ITEM_TYPE INV_ITEM_SALES_ACCOUNT INV_ITEM_SERIAL_NUM_CTRL_CODE INV_ITEM_CAT_ID EVENT_ID LINE_NUMBER LEDGER_ID WAREHOUSE_CODE WAREHOUSE_NAME

Query

SQL_Statement

SELECT /*+ INDEX(l vrm_XLA_LINES_EXTRACT_N1) */ 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.ledger_id ledger_id , o.organization_code warehouse_code , o.organization_name warehouse_name FROM EGP_SYSTEM_ITEMS_VL mtlbf , EGP_ITEM_CATEGORIES mtlicf , EGP_CATEGORIES_B mtlcbf , EGP_CATEGORY_SET_VALID_CATS mtlcsf , INV_ORGANIZATION_DEFINITIONS_V o , vrm_xla_lines_extract_gt l WHERE mtlbf.inventory_item_id = l.inventory_item_id AND l.inventory_item_id = mtlicf.inventory_item_id (+) AND l.level_flag = 'L' 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 GROUP BY mtlbf.inventory_item_id , 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.ledger_id , o.organization_code , o.organization_name