VIEW: OE.SO_LINE_DETAILS#

Source

View Text - Preformatted

select LINE_DETAIL_ID LINE_DETAIL_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LINE_ID LINE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INCLUDED_ITEM_FLAG INCLUDED_ITEM_FLAG, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, COMPONENT_CODE COMPONENT_CODE, COMPONENT_RATIO COMPONENT_RATIO, SHIPPABLE_FLAG SHIPPABLE_FLAG, TRANSACTABLE_FLAG TRANSACTABLE_FLAG, RESERVABLE_FLAG RESERVABLE_FLAG, UNIT_CODE UNIT_CODE, RELEASED_FLAG RELEASED_FLAG, REQUIRED_FOR_REVENUE_FLAG REQUIRED_FOR_REVENUE_FLAG, QUANTITY QUANTITY, WAREHOUSE_ID WAREHOUSE_ID, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, SCHEDULE_DATE SCHEDULE_DATE, REVISION REVISION, LOT_NUMBER LOT_NUMBER, SUBINVENTORY SUBINVENTORY, CUSTOMER_REQUESTED_LOT_FLAG CUSTOMER_REQUESTED_LOT_FLAG, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE, RECEIPT_STATUS_CODE RECEIPT_STATUS_CODE, SCHEDULE_LEVEL_CODE SCHEDULE_LEVEL_CODE, QUANTITY_SVRID QUANTITY_SVRID, WAREHOUSE_SVRID WAREHOUSE_SVRID, DEMAND_CLASS_SVRID DEMAND_CLASS_SVRID, DATE_SVRID DATE_SVRID, REVISION_SVRID REVISION_SVRID, LOT_SVRID LOT_SVRID, SUBINVENTORY_SVRID SUBINVENTORY_SVRID, CUSTOMER_REQUESTED_SVRID CUSTOMER_REQUESTED_SVRID, DF_SVRID DF_SVRID, CONTEXT CONTEXT, 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, DELIVERY DELIVERY, WIP_RESERVED_QUANTITY WIP_RESERVED_QUANTITY, WIP_COMPLETED_QUANTITY WIP_COMPLETED_QUANTITY, SUPPLY_SOURCE_TYPE SUPPLY_SOURCE_TYPE, SUPPLY_SOURCE_HEADER_ID SUPPLY_SOURCE_HEADER_ID, UPDATE_FLAG UPDATE_FLAG, INVENTORY_LOCATION_ID INVENTORY_LOCATION_ID, CONFIGURATION_ITEM_FLAG CONFIGURATION_ITEM_FLAG, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE, LATEST_ACCEPTABLE_DATE_SVRID LATEST_ACCEPTABLE_DATE_SVRID, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG, DPW_ASSIGNED_FLAG DPW_ASSIGNED_FLAG, DELIVERY_ID DELIVERY_ID, DEPARTURE_ID DEPARTURE_ID, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID, LOAD_SEQ_NUMBER LOAD_SEQ_NUMBER, MASTER_CONTAINER_ITEM_ID MASTER_CONTAINER_ITEM_ID, DETAIL_CONTAINER_ITEM_ID DETAIL_CONTAINER_ITEM_ID, SO_LINE_DETAILS_DEPARTURE_ID SO_LINE_DETAILS_DEPARTURE_ID from "OE"."SO_LINE_DETAILS"

View Text - HTML Formatted

SELECT LINE_DETAIL_ID LINE_DETAIL_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LINE_ID LINE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INCLUDED_ITEM_FLAG INCLUDED_ITEM_FLAG
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, COMPONENT_CODE COMPONENT_CODE
, COMPONENT_RATIO COMPONENT_RATIO
, SHIPPABLE_FLAG SHIPPABLE_FLAG
, TRANSACTABLE_FLAG TRANSACTABLE_FLAG
, RESERVABLE_FLAG RESERVABLE_FLAG
, UNIT_CODE UNIT_CODE
, RELEASED_FLAG RELEASED_FLAG
, REQUIRED_FOR_REVENUE_FLAG REQUIRED_FOR_REVENUE_FLAG
, QUANTITY QUANTITY
, WAREHOUSE_ID WAREHOUSE_ID
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, SCHEDULE_DATE SCHEDULE_DATE
, REVISION REVISION
, LOT_NUMBER LOT_NUMBER
, SUBINVENTORY SUBINVENTORY
, CUSTOMER_REQUESTED_LOT_FLAG CUSTOMER_REQUESTED_LOT_FLAG
, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE
, RECEIPT_STATUS_CODE RECEIPT_STATUS_CODE
, SCHEDULE_LEVEL_CODE SCHEDULE_LEVEL_CODE
, QUANTITY_SVRID QUANTITY_SVRID
, WAREHOUSE_SVRID WAREHOUSE_SVRID
, DEMAND_CLASS_SVRID DEMAND_CLASS_SVRID
, DATE_SVRID DATE_SVRID
, REVISION_SVRID REVISION_SVRID
, LOT_SVRID LOT_SVRID
, SUBINVENTORY_SVRID SUBINVENTORY_SVRID
, CUSTOMER_REQUESTED_SVRID CUSTOMER_REQUESTED_SVRID
, DF_SVRID DF_SVRID
, CONTEXT CONTEXT
, 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
, DELIVERY DELIVERY
, WIP_RESERVED_QUANTITY WIP_RESERVED_QUANTITY
, WIP_COMPLETED_QUANTITY WIP_COMPLETED_QUANTITY
, SUPPLY_SOURCE_TYPE SUPPLY_SOURCE_TYPE
, SUPPLY_SOURCE_HEADER_ID SUPPLY_SOURCE_HEADER_ID
, UPDATE_FLAG UPDATE_FLAG
, INVENTORY_LOCATION_ID INVENTORY_LOCATION_ID
, CONFIGURATION_ITEM_FLAG CONFIGURATION_ITEM_FLAG
, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, LATEST_ACCEPTABLE_DATE_SVRID LATEST_ACCEPTABLE_DATE_SVRID
, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG
, DPW_ASSIGNED_FLAG DPW_ASSIGNED_FLAG
, DELIVERY_ID DELIVERY_ID
, DEPARTURE_ID DEPARTURE_ID
, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, LOAD_SEQ_NUMBER LOAD_SEQ_NUMBER
, MASTER_CONTAINER_ITEM_ID MASTER_CONTAINER_ITEM_ID
, DETAIL_CONTAINER_ITEM_ID DETAIL_CONTAINER_ITEM_ID
, SO_LINE_DETAILS_DEPARTURE_ID SO_LINE_DETAILS_DEPARTURE_ID
FROM "OE"."SO_LINE_DETAILS"