VIEW: APPS.CLN_ITEMMST_ITEMHEADER_V

Source

View Text - Preformatted

SELECT msib.inventory_item_id, msib.start_date_active, msib.unit_height, msib.dimension_uom_code, msib.unit_length, msib.unit_volume, msib.volume_uom_code, msib.unit_weight, msib.weight_uom_code, msib.unit_width, msib.concatenated_segments, msib.item_type, msib.primary_uom_code, msib.bom_item_type, msib.inventory_item_status_code, msib.organization_id, msib.cost_of_sales_account, msib.safety_stock_bucket_days, msib.cumulative_total_lead_time, msib.planning_time_fence_days, msib.minimum_order_quantity, msib.attribute_category, msib.attribute1, msib.attribute2, msib.attribute3, msib.attribute4, msib.attribute5, msib.attribute6, msib.attribute7, msib.attribute8, msib.attribute9, msib.attribute10, msib.attribute11, msib.attribute12, msib.attribute13, msib.attribute14, msib.attribute15, msib.description item_description, mir.revision, mir.effectivity_date, msib.item_catalog_group_id, mci.customer_item_number, mci.customer_id, phct.hazard_class FROM mtl_system_items_vl msib, mtl_customer_item_xrefs_v mci, mtl_item_revisions mir, po_hazard_classes_tl phct WHERE msib.inventory_item_id = mci.inventory_item_id(+) AND mci.customer_id(+) = cln_syncitem_pkg.get_cust_acct_id () AND msib.inventory_item_id = mir.inventory_item_id(+) AND msib.organization_id = mir.organization_id(+) AND msib.service_item_flag = 'N' AND msib.inventory_item_flag = 'Y' AND msib.customer_order_enabled_flag = 'Y' AND msib.hazard_class_id = phct.hazard_class_id(+) AND mir.revision = (SELECT MAX (revision) FROM mtl_item_revisions WHERE inventory_item_id = mir.inventory_item_id AND organization_id = mir.organization_id) AND phct.LANGUAGE(+) = USERENV ('lang') AND ( ( NVL (fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY'),'N') = 'Y' AND mci.customer_item_number IS NOT NULL ) OR NVL (fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY'), 'N') ='N' )

View Text - HTML Formatted

SELECT MSIB.INVENTORY_ITEM_ID
, MSIB.START_DATE_ACTIVE
, MSIB.UNIT_HEIGHT
, MSIB.DIMENSION_UOM_CODE
, MSIB.UNIT_LENGTH
, MSIB.UNIT_VOLUME
, MSIB.VOLUME_UOM_CODE
, MSIB.UNIT_WEIGHT
, MSIB.WEIGHT_UOM_CODE
, MSIB.UNIT_WIDTH
, MSIB.CONCATENATED_SEGMENTS
, MSIB.ITEM_TYPE
, MSIB.PRIMARY_UOM_CODE
, MSIB.BOM_ITEM_TYPE
, MSIB.INVENTORY_ITEM_STATUS_CODE
, MSIB.ORGANIZATION_ID
, MSIB.COST_OF_SALES_ACCOUNT
, MSIB.SAFETY_STOCK_BUCKET_DAYS
, MSIB.CUMULATIVE_TOTAL_LEAD_TIME
, MSIB.PLANNING_TIME_FENCE_DAYS
, MSIB.MINIMUM_ORDER_QUANTITY
, MSIB.ATTRIBUTE_CATEGORY
, MSIB.ATTRIBUTE1
, MSIB.ATTRIBUTE2
, MSIB.ATTRIBUTE3
, MSIB.ATTRIBUTE4
, MSIB.ATTRIBUTE5
, MSIB.ATTRIBUTE6
, MSIB.ATTRIBUTE7
, MSIB.ATTRIBUTE8
, MSIB.ATTRIBUTE9
, MSIB.ATTRIBUTE10
, MSIB.ATTRIBUTE11
, MSIB.ATTRIBUTE12
, MSIB.ATTRIBUTE13
, MSIB.ATTRIBUTE14
, MSIB.ATTRIBUTE15
, MSIB.DESCRIPTION ITEM_DESCRIPTION
, MIR.REVISION
, MIR.EFFECTIVITY_DATE
, MSIB.ITEM_CATALOG_GROUP_ID
, MCI.CUSTOMER_ITEM_NUMBER
, MCI.CUSTOMER_ID
, PHCT.HAZARD_CLASS
FROM MTL_SYSTEM_ITEMS_VL MSIB
, MTL_CUSTOMER_ITEM_XREFS_V MCI
, MTL_ITEM_REVISIONS MIR
, PO_HAZARD_CLASSES_TL PHCT
WHERE MSIB.INVENTORY_ITEM_ID = MCI.INVENTORY_ITEM_ID(+)
AND MCI.CUSTOMER_ID(+) = CLN_SYNCITEM_PKG.GET_CUST_ACCT_ID ()
AND MSIB.INVENTORY_ITEM_ID = MIR.INVENTORY_ITEM_ID(+)
AND MSIB.ORGANIZATION_ID = MIR.ORGANIZATION_ID(+)
AND MSIB.SERVICE_ITEM_FLAG = 'N'
AND MSIB.INVENTORY_ITEM_FLAG = 'Y'
AND MSIB.CUSTOMER_ORDER_ENABLED_FLAG = 'Y'
AND MSIB.HAZARD_CLASS_ID = PHCT.HAZARD_CLASS_ID(+)
AND MIR.REVISION = (SELECT MAX (REVISION)
FROM MTL_ITEM_REVISIONS
WHERE INVENTORY_ITEM_ID = MIR.INVENTORY_ITEM_ID
AND ORGANIZATION_ID = MIR.ORGANIZATION_ID)
AND PHCT.LANGUAGE(+) = USERENV ('LANG')
AND ( ( NVL (FND_PROFILE.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY')
, 'N') = 'Y'
AND MCI.CUSTOMER_ITEM_NUMBER IS NOT NULL ) OR NVL (FND_PROFILE.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY')
, 'N') ='N' )