VIEW: APPS.MSC_CUST_ITEM_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT mria.rowid, mria.Simulation_set_id, mria.Plan_id, mria.Sr_instance_id, mria.Organization_Id, mria.Inventory_item_id, msi.item_name, mria.customer_id, mtp.partner_name, mria.customer_instance_id, mria.customer_site_id, mtps.location, mria.Region_id, mria.Region_instance_id, mria.Region, mic.Sr_Category_Id, mic.Category_Set_Id, mic.Category_Name, msi.buyer_name, mic.Description, mria.min_rem_shelf_life_days, mria.max_usage_factor, null , null , null , null , null , null , null , null , null , null , null , null , null , null , mria.updated_columns_count , 'Yes' , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , to_number(null) , null , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , null , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , null , null , null , null , null , null , to_number(null) , null , null , null , null , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , null , null , null , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , null , null , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , to_number(null) , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , null , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , null , null , null , null , null , null , null , null , null , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , null , null , to_number(null) , null , NULL , to_number(null) , to_number(null) , to_number(null) , null , null , null , to_number(null) , to_number(null), null, null, to_number(null), to_number(null), to_number(null), null, null, to_number(null), to_number(null), to_number(null), null, null, to_number(null), to_number(null), to_number(null), null, null, to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null) from msc_item_attributes mria, msc_item_categories mic, msc_system_items msi, msc_trading_partners mtp, msc_trading_partner_sites mtps WHERE mria.customer_id is not null and mria.plan_id = msi.plan_id and mria.sr_instance_id = msi.sr_instance_id and mria.inventory_item_id = msi.inventory_item_id and mria.organization_id = msi.organization_id and mria.sr_instance_id = mic.sr_instance_id and mria.inventory_item_id = mic.inventory_item_id and mria.organization_id = mic.organization_id and mtp.partner_id = mria.customer_id and mtps.partner_site_id (+) = mria.customer_site_id

View Text - HTML Formatted

SELECT MRIA.ROWID
, MRIA.SIMULATION_SET_ID
, MRIA.PLAN_ID
, MRIA.SR_INSTANCE_ID
, MRIA.ORGANIZATION_ID
, MRIA.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MRIA.CUSTOMER_ID
, MTP.PARTNER_NAME
, MRIA.CUSTOMER_INSTANCE_ID
, MRIA.CUSTOMER_SITE_ID
, MTPS.LOCATION
, MRIA.REGION_ID
, MRIA.REGION_INSTANCE_ID
, MRIA.REGION
, MIC.SR_CATEGORY_ID
, MIC.CATEGORY_SET_ID
, MIC.CATEGORY_NAME
, MSI.BUYER_NAME
, MIC.DESCRIPTION
, MRIA.MIN_REM_SHELF_LIFE_DAYS
, MRIA.MAX_USAGE_FACTOR
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, MRIA.UPDATED_COLUMNS_COUNT
, 'YES'
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM MSC_ITEM_ATTRIBUTES MRIA
, MSC_ITEM_CATEGORIES MIC
, MSC_SYSTEM_ITEMS MSI
, MSC_TRADING_PARTNERS MTP
, MSC_TRADING_PARTNER_SITES MTPS
WHERE MRIA.CUSTOMER_ID IS NOT NULL
AND MRIA.PLAN_ID = MSI.PLAN_ID
AND MRIA.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MRIA.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MRIA.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MRIA.SR_INSTANCE_ID = MIC.SR_INSTANCE_ID
AND MRIA.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MRIA.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MTP.PARTNER_ID = MRIA.CUSTOMER_ID
AND MTPS.PARTNER_SITE_ID (+) = MRIA.CUSTOMER_SITE_ID