VIEW: APPS.CSF_M_INVENTORY_V

Source

View Text - Preformatted

SELECT acc.access_id as access_id, acc.access_id as gen_pk, acc.inventory_item_id, acc.subinventory_code, acc.quantity, msik.concatenated_segments as inventory_name, msik.serial_number_control_code as serial_number_control_code, tl.description as description, msik.primary_uom_code as uom_code, acc.locator_id, acc.revision, acc.lot_number, acc.organization_id, msik.comms_nl_trackable_flag as comms_nl_trackable_flag, msik.material_billable_flag, CSM_UTIL_PKG.get_varchar('M') as BILLING_CATEGORY, msik.RESTRICT_LOCATORS_CODE, msik.LOCATION_CONTROL_CODE, msik.restrict_subinventories_code, msik.RECOVERED_PART_DISP_CODE FROM csm_mtl_onhand_qty_acc acc, mtl_system_items_kfv msik, mtl_system_items_tl tl WHERE acc.user_id = asg_base.get_user_id AND msik.inventory_item_id = acc.inventory_item_id AND msik.organization_id = acc.organization_id AND msik.mtl_transactions_enabled_flag = 'Y' AND tl.inventory_item_id = msik.inventory_item_id AND tl.organization_id = msik.organization_id AND tl.LANGUAGE = asg_base.get_language

View Text - HTML Formatted

SELECT ACC.ACCESS_ID AS ACCESS_ID
, ACC.ACCESS_ID AS GEN_PK
, ACC.INVENTORY_ITEM_ID
, ACC.SUBINVENTORY_CODE
, ACC.QUANTITY
, MSIK.CONCATENATED_SEGMENTS AS INVENTORY_NAME
, MSIK.SERIAL_NUMBER_CONTROL_CODE AS SERIAL_NUMBER_CONTROL_CODE
, TL.DESCRIPTION AS DESCRIPTION
, MSIK.PRIMARY_UOM_CODE AS UOM_CODE
, ACC.LOCATOR_ID
, ACC.REVISION
, ACC.LOT_NUMBER
, ACC.ORGANIZATION_ID
, MSIK.COMMS_NL_TRACKABLE_FLAG AS COMMS_NL_TRACKABLE_FLAG
, MSIK.MATERIAL_BILLABLE_FLAG
, CSM_UTIL_PKG.GET_VARCHAR('M') AS BILLING_CATEGORY
, MSIK.RESTRICT_LOCATORS_CODE
, MSIK.LOCATION_CONTROL_CODE
, MSIK.RESTRICT_SUBINVENTORIES_CODE
, MSIK.RECOVERED_PART_DISP_CODE
FROM CSM_MTL_ONHAND_QTY_ACC ACC
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_SYSTEM_ITEMS_TL TL
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND MSIK.INVENTORY_ITEM_ID = ACC.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = ACC.ORGANIZATION_ID
AND MSIK.MTL_TRANSACTIONS_ENABLED_FLAG = 'Y'
AND TL.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND TL.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE