VIEW: APPS.CSF_M_SYSTEM_ITEMS_V

Source

View Text - Preformatted

SELECT acc.access_id as access_id, acc.access_id as gen_pk, msi.inventory_item_id, msi.organization_id, msi.segment1 as inventory_name, msi_tl.description as description, msi.primary_uom_code, msi.material_billable_flag, asg_base.get_user_id as user_id, asg_base.get_user_name as client_name, cbtc.billing_category, MSI.ENABLED_FLAG , MSI.START_DATE_ACTIVE , MSI.END_DATE_ACTIVE , MSI.SERVICE_ITEM_FLAG , MSI.SERVICEABLE_PRODUCT_FLAG , MSI.RETURNABLE_FLAG , MSI.LIST_PRICE_PER_UNIT, MSI.MTL_TRANSACTIONS_ENABLED_FLAG, MSI.SERIAL_NUMBER_CONTROL_CODE, MSI.LOT_CONTROL_CODE, MSI.INVENTORY_ASSET_FLAG , MSI.PURCHASING_ENABLED_FLAG, MSI.INTERNAL_ORDER_ENABLED_FLAG , MSI.INTERNAL_ORDER_FLAG , MSI.PURCHASING_ITEM_FLAG , MSI.COMMS_NL_TRACKABLE_FLAG , MSI.SERV_REQ_ENABLED_CODE , MSI.ATTRIBUTE1, MSI.ATTRIBUTE2, MSI.ATTRIBUTE3, MSI.ATTRIBUTE4, MSI.ATTRIBUTE5, MSI.ATTRIBUTE6, MSI.ATTRIBUTE7, MSI.ATTRIBUTE8, MSI.ATTRIBUTE9, MSI.ATTRIBUTE10 , MSI.ATTRIBUTE11, MSI.ATTRIBUTE12, MSI.ATTRIBUTE13, MSI.ATTRIBUTE14, MSI.ATTRIBUTE15, MSI.ATTRIBUTE_CATEGORY, cbtc.billing_category as BILLING_CATEOGRY from csm_system_items_acc acc, mtl_system_items_b msi, mtl_system_items_tl msi_tl, CS_BILLING_TYPE_CATEGORIES cbtc WHERE acc.user_id = asg_base.get_user_id AND acc.inventory_item_id = msi.inventory_item_id AND acc.organization_id = msi.organization_id AND msi.organization_id = csm_profile_pkg.get_organization_id(asg_base.get_user_id) AND msi.material_billable_flag = cbtc.billing_type AND cbtc.billing_category in ('L', 'E') AND msi_tl.inventory_item_id = msi.inventory_item_id AND msi_tl.organization_id = msi.organization_id AND msi_tl.language = asg_base.get_language

View Text - HTML Formatted

SELECT ACC.ACCESS_ID AS ACCESS_ID
, ACC.ACCESS_ID AS GEN_PK
, MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
, MSI.SEGMENT1 AS INVENTORY_NAME
, MSI_TL.DESCRIPTION AS DESCRIPTION
, MSI.PRIMARY_UOM_CODE
, MSI.MATERIAL_BILLABLE_FLAG
, ASG_BASE.GET_USER_ID AS USER_ID
, ASG_BASE.GET_USER_NAME AS CLIENT_NAME
, CBTC.BILLING_CATEGORY
, MSI.ENABLED_FLAG
, MSI.START_DATE_ACTIVE
, MSI.END_DATE_ACTIVE
, MSI.SERVICE_ITEM_FLAG
, MSI.SERVICEABLE_PRODUCT_FLAG
, MSI.RETURNABLE_FLAG
, MSI.LIST_PRICE_PER_UNIT
, MSI.MTL_TRANSACTIONS_ENABLED_FLAG
, MSI.SERIAL_NUMBER_CONTROL_CODE
, MSI.LOT_CONTROL_CODE
, MSI.INVENTORY_ASSET_FLAG
, MSI.PURCHASING_ENABLED_FLAG
, MSI.INTERNAL_ORDER_ENABLED_FLAG
, MSI.INTERNAL_ORDER_FLAG
, MSI.PURCHASING_ITEM_FLAG
, MSI.COMMS_NL_TRACKABLE_FLAG
, MSI.SERV_REQ_ENABLED_CODE
, MSI.ATTRIBUTE1
, MSI.ATTRIBUTE2
, MSI.ATTRIBUTE3
, MSI.ATTRIBUTE4
, MSI.ATTRIBUTE5
, MSI.ATTRIBUTE6
, MSI.ATTRIBUTE7
, MSI.ATTRIBUTE8
, MSI.ATTRIBUTE9
, MSI.ATTRIBUTE10
, MSI.ATTRIBUTE11
, MSI.ATTRIBUTE12
, MSI.ATTRIBUTE13
, MSI.ATTRIBUTE14
, MSI.ATTRIBUTE15
, MSI.ATTRIBUTE_CATEGORY
, CBTC.BILLING_CATEGORY AS BILLING_CATEOGRY
FROM CSM_SYSTEM_ITEMS_ACC ACC
, MTL_SYSTEM_ITEMS_B MSI
, MTL_SYSTEM_ITEMS_TL MSI_TL
, CS_BILLING_TYPE_CATEGORIES CBTC
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND ACC.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = CSM_PROFILE_PKG.GET_ORGANIZATION_ID(ASG_BASE.GET_USER_ID)
AND MSI.MATERIAL_BILLABLE_FLAG = CBTC.BILLING_TYPE
AND CBTC.BILLING_CATEGORY IN ('L'
, 'E')
AND MSI_TL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI_TL.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI_TL.LANGUAGE = ASG_BASE.GET_LANGUAGE