VIEW: CSM.CSM_REQ_LINES_INQ#

Source

View Text - Preformatted

select CLID$$CS CLID$$CS, REQUIREMENT_LINE_ID REQUIREMENT_LINE_ID, REQUIREMENT_HEADER_ID REQUIREMENT_HEADER_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_NAME ITEM_NAME, ITEM_DESCRIPTION ITEM_DESCRIPTION, UOM_CODE UOM_CODE, REQUIRED_QUANTITY REQUIRED_QUANTITY, SHIP_COMPLETE_FLAG SHIP_COMPLETE_FLAG, REVISION REVISION, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY, ORDERED_QUANTITY ORDERED_QUANTITY, ORDER_LINE_ID ORDER_LINE_ID, RESERVATION_ID RESERVATION_ID, LOCAL_RESERVATION_ID LOCAL_RESERVATION_ID, ORDER_BY_DATE ORDER_BY_DATE, ARRIVAL_DATE ARRIVAL_DATE, SHIPPING_METHOD_CODE#1 SHIPPING_METHOD_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, ORDER_NUMBER ORDER_NUMBER, DMLTYPE$$ DMLTYPE$$, SEQNO$$ SEQNO$$, TRANID$$ TRANID$$, VERSION$$ VERSION$$, SOURCED_FROM#1 SOURCED_FROM, PO_REQUISITION_NUMBER PO_REQUISITION_NUMBER, ORDER_STATUS ORDER_STATUS, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, LIKELIHOOD LIKELIHOOD, ITEM_SCRATCHPAD ITEM_SCRATCHPAD, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE, WAYBILL_NUMBER WAYBILL_NUMBER, ACTUAL_SHIPMENT_DATE ACTUAL_SHIPMENT_DATE, SHIPPING_METHOD_MEANING SHIPPING_METHOD_MEANING, SOURCED_FROM_DISP SOURCED_FROM_DISP, SOURCE_ID SOURCE_ID, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY from "CSM"."CSM_REQ_LINES_INQ"

View Text - HTML Formatted

SELECT CLID$$CS CLID$$CS
, REQUIREMENT_LINE_ID REQUIREMENT_LINE_ID
, REQUIREMENT_HEADER_ID REQUIREMENT_HEADER_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_NAME ITEM_NAME
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, UOM_CODE UOM_CODE
, REQUIRED_QUANTITY REQUIRED_QUANTITY
, SHIP_COMPLETE_FLAG SHIP_COMPLETE_FLAG
, REVISION REVISION
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY
, ORDERED_QUANTITY ORDERED_QUANTITY
, ORDER_LINE_ID ORDER_LINE_ID
, RESERVATION_ID RESERVATION_ID
, LOCAL_RESERVATION_ID LOCAL_RESERVATION_ID
, ORDER_BY_DATE ORDER_BY_DATE
, ARRIVAL_DATE ARRIVAL_DATE
, SHIPPING_METHOD_CODE#1 SHIPPING_METHOD_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, ORDER_NUMBER ORDER_NUMBER
, DMLTYPE$$ DMLTYPE$$
, SEQNO$$ SEQNO$$
, TRANID$$ TRANID$$
, VERSION$$ VERSION$$
, SOURCED_FROM#1 SOURCED_FROM
, PO_REQUISITION_NUMBER PO_REQUISITION_NUMBER
, ORDER_STATUS ORDER_STATUS
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LIKELIHOOD LIKELIHOOD
, ITEM_SCRATCHPAD ITEM_SCRATCHPAD
, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE
, WAYBILL_NUMBER WAYBILL_NUMBER
, ACTUAL_SHIPMENT_DATE ACTUAL_SHIPMENT_DATE
, SHIPPING_METHOD_MEANING SHIPPING_METHOD_MEANING
, SOURCED_FROM_DISP SOURCED_FROM_DISP
, SOURCE_ID SOURCE_ID
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "CSM"."CSM_REQ_LINES_INQ"