VIEW: CSM.CSF_M_INVENTORY_INQ#

Source

View Text - Preformatted

select CLID$$CS CLID$$CS, GEN_PK GEN_PK, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, QUANTITY QUANTITY, INVENTORY_NAME INVENTORY_NAME, SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE, DESCRIPTION DESCRIPTION, UOM_CODE UOM_CODE, LOCATOR_ID LOCATOR_ID, REVISION REVISION, LOT_NUMBER LOT_NUMBER, ORGANIZATION_ID ORGANIZATION_ID, COMMS_NL_TRACKABLE_FLAG COMMS_NL_TRACKABLE_FLAG, MATERIAL_BILLABLE_FLAG MATERIAL_BILLABLE_FLAG, BILLING_CATEGORY BILLING_CATEGORY, DMLTYPE$$ DMLTYPE$$, SEQNO$$ SEQNO$$, TRANID$$ TRANID$$, VERSION$$ VERSION$$, RESTRICT_LOCATORS_CODE RESTRICT_LOCATORS_CODE, LOCATION_CONTROL_CODE LOCATION_CONTROL_CODE, RESTRICT_SUBINVENTORIES_CODE RESTRICT_SUBINVENTORIES_CODE, RECOVERED_PART_DISP_CODE RECOVERED_PART_DISP_CODE from "CSM"."CSF_M_INVENTORY_INQ"

View Text - HTML Formatted

SELECT CLID$$CS CLID$$CS
, GEN_PK GEN_PK
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, QUANTITY QUANTITY
, INVENTORY_NAME INVENTORY_NAME
, SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE
, DESCRIPTION DESCRIPTION
, UOM_CODE UOM_CODE
, LOCATOR_ID LOCATOR_ID
, REVISION REVISION
, LOT_NUMBER LOT_NUMBER
, ORGANIZATION_ID ORGANIZATION_ID
, COMMS_NL_TRACKABLE_FLAG COMMS_NL_TRACKABLE_FLAG
, MATERIAL_BILLABLE_FLAG MATERIAL_BILLABLE_FLAG
, BILLING_CATEGORY BILLING_CATEGORY
, DMLTYPE$$ DMLTYPE$$
, SEQNO$$ SEQNO$$
, TRANID$$ TRANID$$
, VERSION$$ VERSION$$
, RESTRICT_LOCATORS_CODE RESTRICT_LOCATORS_CODE
, LOCATION_CONTROL_CODE LOCATION_CONTROL_CODE
, RESTRICT_SUBINVENTORIES_CODE RESTRICT_SUBINVENTORIES_CODE
, RECOVERED_PART_DISP_CODE RECOVERED_PART_DISP_CODE
FROM "CSM"."CSF_M_INVENTORY_INQ"