DBA Data[Home] [Help] [Dependency Information]

VIEW: OE.SO_LINES_ALL#

Object Details
Object Name: SO_LINES_ALL#
Object Type: VIEW
Owner: OE
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

SOURCE_LINE_ID NUMBER

ORIGINAL_SYSTEM_LINE_REFERENCE VARCHAR2 (50)
HEADER_ID NUMBER
Yes
SHIPMENT_SCHEDULE_LINE_ID NUMBER

PARENT_LINE_ID NUMBER

ATO_LINE_ID NUMBER

LINK_TO_LINE_ID NUMBER

SERVICE_PARENT_LINE_ID NUMBER

LINE_TYPE_CODE VARCHAR2 (30) Yes
OPTION_FLAG VARCHAR2 (1) Yes
OPEN_FLAG VARCHAR2 (1)
CYCLE_ID NUMBER

LINE_NUMBER NUMBER

INVENTORY_ITEM_ID NUMBER
Yes
COMPONENT_SEQUENCE_ID NUMBER

ITEM_TYPE_CODE VARCHAR2 (30) Yes
ATO_FLAG VARCHAR2 (1) Yes
SHIP_MODEL_COMPLETE_FLAG VARCHAR2 (1)
COMPONENT_CODE VARCHAR2 (1000)
COMPONENT_SORT_CODE VARCHAR2 (240)
STANDARD_COMPONENT_FREEZE_DATE DATE

CONFIGURATION_EDITED_FLAG VARCHAR2 (1)
ORDERED_QUANTITY NUMBER

CANCELLED_QUANTITY NUMBER

UNIT_CODE VARCHAR2 (3)
PRICE_LIST_ID NUMBER

PRICING_METHOD_CODE VARCHAR2 (30)
LIST_PRICE NUMBER

SELLING_PRICE NUMBER

LIST_PERCENT NUMBER

SELLING_PERCENT NUMBER

PERCENT_BASE_PRICE NUMBER

WH_UPDATE_DATE DATE

RETURN_FOR_REPAIR_FLAG VARCHAR2 (1)
PRICING_CONTEXT VARCHAR2 (30)
PRICING_ATTRIBUTE1 VARCHAR2 (150)
PRICING_ATTRIBUTE2 VARCHAR2 (150)
PRICING_ATTRIBUTE3 VARCHAR2 (150)
PRICING_ATTRIBUTE4 VARCHAR2 (150)
PRICING_ATTRIBUTE5 VARCHAR2 (150)
PRICING_ATTRIBUTE6 VARCHAR2 (150)
PRICING_ATTRIBUTE7 VARCHAR2 (150)
PRICING_ATTRIBUTE8 VARCHAR2 (150)
PRICING_ATTRIBUTE9 VARCHAR2 (150)
PRICING_ATTRIBUTE10 VARCHAR2 (150)
PRICING_ATTRIBUTE11 VARCHAR2 (150)
PRICING_ATTRIBUTE12 VARCHAR2 (150)
PRICING_ATTRIBUTE13 VARCHAR2 (150)
PRICING_ATTRIBUTE14 VARCHAR2 (150)
PRICING_ATTRIBUTE15 VARCHAR2 (150)
WAREHOUSE_ID NUMBER

DEMAND_CLASS_CODE VARCHAR2 (30)
SCHEDULE_DATE DATE

SHIP_SET_NUMBER NUMBER

SHIPPED_QUANTITY NUMBER

DATE_REQUESTED_CURRENT DATE

PROMISE_DATE DATE

SHIP_TO_SITE_USE_ID NUMBER

SHIP_TO_CONTACT_ID NUMBER

SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
SHIP_METHOD_CODE VARCHAR2 (30)
AGREEMENT_ID NUMBER

COMMITMENT_ID NUMBER

TERMS_ID NUMBER

INVOICING_RULE_ID NUMBER

ACCOUNTING_RULE_ID NUMBER

INVOICE_COUNT NUMBER

INVOICED_QUANTITY NUMBER

QUANTITY_TO_INVOICE NUMBER

REVENUE_AMOUNT NUMBER

TAX_EXEMPT_NUMBER VARCHAR2 (80)
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
TRANSACTION_TYPE_CODE VARCHAR2 (30)
TRANSACTION_REASON_CODE VARCHAR2 (30)
TRANSACTION_COMMENTS VARCHAR2 (240)
RETURN_REFERENCE_TYPE_CODE VARCHAR2 (30)
RETURN_REFERENCE_ID NUMBER

CREDIT_INVOICE_LINE_ID NUMBER

INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
CUSTOMER_PRODUCT_ID NUMBER

CP_SERVICE_ID NUMBER

SERVICED_QUANTITY NUMBER

SERVICE_DURATION NUMBER

SERVICE_START_DATE DATE

SERVICE_END_DATE DATE

SERVICE_COTERMINATE_FLAG VARCHAR2 (1)
SERVICE_PERIOD_CONVERSION_RATE NUMBER

SERVICE_MASS_TXN_TEMP_ID NUMBER

LATEST_ACCEPTABLE_DATE DATE

LATEST_ACCEPTABLE_DATE_SVRID NUMBER

TAX_CODE VARCHAR2 (50)
ORG_ID NUMBER

NUMBER_SVRID NUMBER

ITEM_SVRID NUMBER

ORDERED_QUANTITY_SVRID NUMBER

UNIT_SVRID NUMBER

PRICING_ATTRIBUTES_SVRID NUMBER

LIST_PRICE_SVRID NUMBER

SELLING_PRICE_SVRID NUMBER

LIST_PERCENT_SVRID NUMBER

SELLING_PERCENT_SVRID NUMBER

WAREHOUSE_SVRID NUMBER

DEMAND_CLASS_SVRID NUMBER

SHIP_SET_NUMBER_SVRID NUMBER

REQUEST_DATE_SVRID NUMBER

PROMISE_DATE_SVRID NUMBER

SCHEDULE_DATE_SVRID NUMBER

SHIP_TO_SVRID NUMBER

SHIP_TO_CONTACT_SVRID NUMBER

SHIPMENT_PRIORITY_SVRID NUMBER

FREIGHT_CARRIER_SVRID NUMBER

AGREEMENT_SVRID NUMBER

COMMITMENT_SVRID NUMBER

PAYMENT_TERMS_SVRID NUMBER

INVOICING_RULE_SVRID NUMBER

ACCOUNTING_RULE_SVRID NUMBER

TAX_EXEMPT_NUMBER_SVRID NUMBER

TAX_EXEMPT_REASON_SVRID NUMBER

TRANSACTION_TYPE_SVRID NUMBER

TRANSACTION_REASON_SVRID NUMBER

TRANSACTION_COMMENTS_SVRID NUMBER

RETURN_REFERENCE_TYPE_SVRID NUMBER

RETURN_REFERENCE_SVRID NUMBER

CREDIT_INVOICE_LINE_SVRID NUMBER

INSPECTION_REQUIRED_SVRID NUMBER

CUSTOMER_PRODUCT_SVRID NUMBER

CUSTOMER_PRODUCT_SERVICE_SVRID NUMBER

SERVICE_DURATION_SVRID NUMBER

SERVICE_START_DATE_SVRID NUMBER

SERVICE_END_DATE_SVRID NUMBER

SERVICE_PER_CONV_RATE_SVRID NUMBER

SERVICE_COTERMINATE_SVRID NUMBER

DF_SVRID NUMBER

TAX_CODE_SVRID NUMBER

S1 NUMBER

S1_DATE DATE

S2 NUMBER

S2_DATE DATE

S3 NUMBER

S3_DATE DATE

S4 NUMBER

S4_DATE DATE

S5 NUMBER

S5_DATE DATE

S6 NUMBER

S6_DATE DATE

S7 NUMBER

S7_DATE DATE

S8 NUMBER

S8_DATE DATE

S9 NUMBER

S9_DATE DATE

S10 NUMBER

S10_DATE DATE

S11 NUMBER

S11_DATE DATE

S12 NUMBER

S12_DATE DATE

S13 NUMBER

S13_DATE DATE

S14 NUMBER

S14_DATE DATE

S15 NUMBER

S15_DATE DATE

S16 NUMBER

S16_DATE DATE

S17 NUMBER

S17_DATE DATE

S18 NUMBER

S18_DATE DATE

S19 NUMBER

S19_DATE DATE

S20 NUMBER

S20_DATE DATE

S21 NUMBER

S21_DATE DATE

S22 NUMBER

S22_DATE DATE

S23 NUMBER

S23_DATE DATE

S24 NUMBER

S24_DATE DATE

S25 NUMBER

S25_DATE DATE

S26 NUMBER

S26_DATE DATE

S27 NUMBER

S27_DATE DATE

S28 NUMBER

S28_DATE DATE

S29 NUMBER

S29_DATE DATE

S30 NUMBER

S30_DATE DATE

CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
PRICING_DATE DATE

PROJECT_ID NUMBER

TASK_ID NUMBER

DEMAND_STREAM_ID NUMBER

INTERMEDIATE_SHIP_TO_ID NUMBER

CUSTOMER_DOCK_CODE VARCHAR2 (50)
PLANNING_PROD_SEQ_NUMBER VARCHAR2 (50)
CUSTOMER_ITEM_ID NUMBER

CUSTOMER_JOB VARCHAR2 (50)
CUSTOMER_PRODUCTION_LINE VARCHAR2 (50)
CUSTOMER_MODEL_SERIAL_NUMBER VARCHAR2 (50)
SOURCE_TYPE_CODE VARCHAR2 (30)
SOURCE_TYPE_CODE_SVRID NUMBER

PLANNING_PRIORITY NUMBER

PLANNING_PRIORITY_SVRID NUMBER

END_ITEM_UNIT_NUMBER VARCHAR2 (30)
CONFIG_ITEM_ID NUMBER

AUTO_SELECTED_QUANTITY NUMBER

SELECTED_LINE_ID NUMBER

CONFIG_HEADER_ID NUMBER

CONFIG_REV_NBR NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SOURCE_LINE_ID
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      HEADER_ID
,      SHIPMENT_SCHEDULE_LINE_ID
,      PARENT_LINE_ID
,      ATO_LINE_ID
,      LINK_TO_LINE_ID
,      SERVICE_PARENT_LINE_ID
,      LINE_TYPE_CODE
,      OPTION_FLAG
,      OPEN_FLAG
,      CYCLE_ID
,      LINE_NUMBER
,      INVENTORY_ITEM_ID
,      COMPONENT_SEQUENCE_ID
,      ITEM_TYPE_CODE
,      ATO_FLAG
,      SHIP_MODEL_COMPLETE_FLAG
,      COMPONENT_CODE
,      COMPONENT_SORT_CODE
,      STANDARD_COMPONENT_FREEZE_DATE
,      CONFIGURATION_EDITED_FLAG
,      ORDERED_QUANTITY
,      CANCELLED_QUANTITY
,      UNIT_CODE
,      PRICE_LIST_ID
,      PRICING_METHOD_CODE
,      LIST_PRICE
,      SELLING_PRICE
,      LIST_PERCENT
,      SELLING_PERCENT
,      PERCENT_BASE_PRICE
,      WH_UPDATE_DATE
,      RETURN_FOR_REPAIR_FLAG
,      PRICING_CONTEXT
,      PRICING_ATTRIBUTE1
,      PRICING_ATTRIBUTE2
,      PRICING_ATTRIBUTE3
,      PRICING_ATTRIBUTE4
,      PRICING_ATTRIBUTE5
,      PRICING_ATTRIBUTE6
,      PRICING_ATTRIBUTE7
,      PRICING_ATTRIBUTE8
,      PRICING_ATTRIBUTE9
,      PRICING_ATTRIBUTE10
,      PRICING_ATTRIBUTE11
,      PRICING_ATTRIBUTE12
,      PRICING_ATTRIBUTE13
,      PRICING_ATTRIBUTE14
,      PRICING_ATTRIBUTE15
,      WAREHOUSE_ID
,      DEMAND_CLASS_CODE
,      SCHEDULE_DATE
,      SHIP_SET_NUMBER
,      SHIPPED_QUANTITY
,      DATE_REQUESTED_CURRENT
,      PROMISE_DATE
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CONTACT_ID
,      SHIPMENT_PRIORITY_CODE
,      SHIP_METHOD_CODE
,      AGREEMENT_ID
,      COMMITMENT_ID
,      TERMS_ID
,      INVOICING_RULE_ID
,      ACCOUNTING_RULE_ID
,      INVOICE_COUNT
,      INVOICED_QUANTITY
,      QUANTITY_TO_INVOICE
,      REVENUE_AMOUNT
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      TRANSACTION_TYPE_CODE
,      TRANSACTION_REASON_CODE
,      TRANSACTION_COMMENTS
,      RETURN_REFERENCE_TYPE_CODE
,      RETURN_REFERENCE_ID
,      CREDIT_INVOICE_LINE_ID
,      INSPECTION_REQUIRED_FLAG
,      CUSTOMER_PRODUCT_ID
,      CP_SERVICE_ID
,      SERVICED_QUANTITY
,      SERVICE_DURATION
,      SERVICE_START_DATE
,      SERVICE_END_DATE
,      SERVICE_COTERMINATE_FLAG
,      SERVICE_PERIOD_CONVERSION_RATE
,      SERVICE_MASS_TXN_TEMP_ID
,      LATEST_ACCEPTABLE_DATE
,      LATEST_ACCEPTABLE_DATE_SVRID
,      TAX_CODE
,      ORG_ID
,      NUMBER_SVRID
,      ITEM_SVRID
,      ORDERED_QUANTITY_SVRID
,      UNIT_SVRID
,      PRICING_ATTRIBUTES_SVRID
,      LIST_PRICE_SVRID
,      SELLING_PRICE_SVRID
,      LIST_PERCENT_SVRID
,      SELLING_PERCENT_SVRID
,      WAREHOUSE_SVRID
,      DEMAND_CLASS_SVRID
,      SHIP_SET_NUMBER_SVRID
,      REQUEST_DATE_SVRID
,      PROMISE_DATE_SVRID
,      SCHEDULE_DATE_SVRID
,      SHIP_TO_SVRID
,      SHIP_TO_CONTACT_SVRID
,      SHIPMENT_PRIORITY_SVRID
,      FREIGHT_CARRIER_SVRID
,      AGREEMENT_SVRID
,      COMMITMENT_SVRID
,      PAYMENT_TERMS_SVRID
,      INVOICING_RULE_SVRID
,      ACCOUNTING_RULE_SVRID
,      TAX_EXEMPT_NUMBER_SVRID
,      TAX_EXEMPT_REASON_SVRID
,      TRANSACTION_TYPE_SVRID
,      TRANSACTION_REASON_SVRID
,      TRANSACTION_COMMENTS_SVRID
,      RETURN_REFERENCE_TYPE_SVRID
,      RETURN_REFERENCE_SVRID
,      CREDIT_INVOICE_LINE_SVRID
,      INSPECTION_REQUIRED_SVRID
,      CUSTOMER_PRODUCT_SVRID
,      CUSTOMER_PRODUCT_SERVICE_SVRID
,      SERVICE_DURATION_SVRID
,      SERVICE_START_DATE_SVRID
,      SERVICE_END_DATE_SVRID
,      SERVICE_PER_CONV_RATE_SVRID
,      SERVICE_COTERMINATE_SVRID
,      DF_SVRID
,      TAX_CODE_SVRID
,      S1
,      S1_DATE
,      S2
,      S2_DATE
,      S3
,      S3_DATE
,      S4
,      S4_DATE
,      S5
,      S5_DATE
,      S6
,      S6_DATE
,      S7
,      S7_DATE
,      S8
,      S8_DATE
,      S9
,      S9_DATE
,      S10
,      S10_DATE
,      S11
,      S11_DATE
,      S12
,      S12_DATE
,      S13
,      S13_DATE
,      S14
,      S14_DATE
,      S15
,      S15_DATE
,      S16
,      S16_DATE
,      S17
,      S17_DATE
,      S18
,      S18_DATE
,      S19
,      S19_DATE
,      S20
,      S20_DATE
,      S21
,      S21_DATE
,      S22
,      S22_DATE
,      S23
,      S23_DATE
,      S24
,      S24_DATE
,      S25
,      S25_DATE
,      S26
,      S26_DATE
,      S27
,      S27_DATE
,      S28
,      S28_DATE
,      S29
,      S29_DATE
,      S30
,      S30_DATE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRICING_DATE
,      PROJECT_ID
,      TASK_ID
,      DEMAND_STREAM_ID
,      INTERMEDIATE_SHIP_TO_ID
,      CUSTOMER_DOCK_CODE
,      PLANNING_PROD_SEQ_NUMBER
,      CUSTOMER_ITEM_ID
,      CUSTOMER_JOB
,      CUSTOMER_PRODUCTION_LINE
,      CUSTOMER_MODEL_SERIAL_NUMBER
,      SOURCE_TYPE_CODE
,      SOURCE_TYPE_CODE_SVRID
,      PLANNING_PRIORITY
,      PLANNING_PRIORITY_SVRID
,      END_ITEM_UNIT_NUMBER
,      CONFIG_ITEM_ID
,      AUTO_SELECTED_QUANTITY
,      SELECTED_LINE_ID
,      CONFIG_HEADER_ID
,      CONFIG_REV_NBR
FROM OE.SO_LINES_ALL#;

Dependencies

[top of page]

OE.SO_LINES_ALL# references the following:

SchemaOE
TableSO_LINES_ALL
OE.SO_LINES_ALL# is referenced by following:

SchemaAPPS
SynonymSO_LINES_ALL