[Home] [Help] [Dependency Information]

VIEW: APPS.SO_LINES_INTERFACE

Object Details

Object Name:	SO_LINES_INTERFACE
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OE.SO_LINES_INTERFACE
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

SO_LINES_INTERFACE_ALL view for access from other products

[View Source]

Columns

Query Text

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

SELECT PERCENT_BASE_PRICE
,      OPERATION_CODE
,      COMMITMENT_ID
,      INVOICING_RULE
,      SHIP_TO_CUSTOMER
,      SHIP_TO_CUSTOMER_ID
,      PRICING_DATE
,      LATEST_ACCEPTABLE_DATE
,      SERVICE_PARENT_LINE_REF
,      SERVICE_COTERMINATE_FLAG
,      SERVICE_PERIOD_CONVERSION_RATE
,      TAX_CODE
,      DEMAND_CLASS_CODE
,      PROMISE_DATE
,      ORG_ID
,      LINK_TO_LINE_REF
,      PARENT_LINE_REF
,      SHIPMENT_SCHEDULE_LINE_REF
,      SHIP_SET_NUMBER
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CONTACT_ID
,      SHIPMENT_PRIORITY_CODE
,      SHIP_METHOD_CODE
,      PRICE_LIST_ID
,      TERMS_ID
,      WAREHOUSE_ID
,      SERVICED_SEGMENT1
,      SERVICED_SEGMENT2
,      SERVICED_SEGMENT3
,      SERVICED_SEGMENT4
,      SERVICED_SEGMENT5
,      SERVICED_SEGMENT6
,      SERVICED_SEGMENT7
,      SERVICED_SEGMENT8
,      SERVICED_SEGMENT9
,      SERVICED_SEGMENT10
,      SERVICED_SEGMENT11
,      SERVICED_SEGMENT12
,      SERVICED_SEGMENT13
,      SERVICED_SEGMENT14
,      SERVICED_SEGMENT15
,      SERVICED_SEGMENT16
,      SERVICED_SEGMENT17
,      SERVICED_SEGMENT18
,      SERVICED_SEGMENT19
,      SERVICED_SEGMENT20
,      SERVICED_ITEM_ID
,      SERVICED_LIST_PRICE
,      UNIT_CODE
,      ORDERED_QUANTITY
,      DATE_REQUESTED_CURRENT
,      LIST_PRICE
,      SELLING_PRICE
,      LIST_PERCENT
,      SELLING_PERCENT
,      INVENTORY_ITEM_SEGMENT1
,      INVENTORY_ITEM_SEGMENT2
,      INVENTORY_ITEM_SEGMENT3
,      INVENTORY_ITEM_SEGMENT4
,      INVENTORY_ITEM_SEGMENT5
,      INVENTORY_ITEM_SEGMENT6
,      INVENTORY_ITEM_SEGMENT7
,      INVENTORY_ITEM_SEGMENT8
,      INVENTORY_ITEM_SEGMENT9
,      INVENTORY_ITEM_SEGMENT10
,      INVENTORY_ITEM_SEGMENT11
,      INVENTORY_ITEM_SEGMENT12
,      INVENTORY_ITEM_SEGMENT13
,      INVENTORY_ITEM_SEGMENT14
,      INVENTORY_ITEM_SEGMENT15
,      INVENTORY_ITEM_SEGMENT16
,      INVENTORY_ITEM_SEGMENT17
,      INVENTORY_ITEM_SEGMENT18
,      INVENTORY_ITEM_SEGMENT19
,      INVENTORY_ITEM_SEGMENT20
,      INVENTORY_ITEM_ID
,      SHIPPED_QUANTITY
,      SCHEDULED_SHIPMENT_DATE
,      PRICING_ATTRIBUTE9
,      PRICING_ATTRIBUTE10
,      PRICING_ATTRIBUTE11
,      PRICING_ATTRIBUTE12
,      PRICING_ATTRIBUTE13
,      PRICING_ATTRIBUTE14
,      PRICING_ATTRIBUTE15
,      PRICING_CONTEXT
,      PRICING_METHOD_CODE
,      COMPONENT_CODE
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_SORT_CODE
,      ERROR_FLAG
,      INTERFACE_STATUS
,      ITEM_TYPE_CODE
,      LEVEL_CODE
,      OPTION_FLAG
,      ORDER_SOURCE_ID
,      SHIP_ADDRESS1
,      SHIP_ADDRESS2
,      SHIP_ADDRESS3
,      SHIP_ADDRESS4
,      SHIP_ADDRESS_ID
,      SHIP_CITY
,      SHIP_COUNTRY
,      SHIP_COUNTY
,      SHIP_POSTAL_CODE
,      SHIP_STATE
,      SHIP_TO_CONTACT_FIRST_NAME
,      SHIP_TO_CONTACT_LAST_NAME
,      TERMS_NAME
,      GROUP_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      LINE_NUMBER
,      LINE_TYPE
,      SERVICED_PRICING_ATTRIBUTE15
,      SERVICED_PRICING_CONTEXT
,      ORDER_CATEGORY
,      ENTERED_STATE
,      ENTERED_STATE_DATE
,      COMPLETE_FLAG
,      SCHEDULE_STATUS_CODE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CALCULATE_PRICE
,      PRICING_ATTRIBUTE1
,      PRICING_ATTRIBUTE2
,      PRICING_ATTRIBUTE3
,      PRICING_ATTRIBUTE4
,      PRICING_ATTRIBUTE5
,      PRICING_ATTRIBUTE6
,      PRICING_ATTRIBUTE7
,      PRICING_ATTRIBUTE8
,      SERVICE_START_DATE_ACTIVE
,      SERVICE_END_DATE_ACTIVE
,      CUSTOMER_PRODUCT_ID
,      CP_SERVICE_ID
,      TRANSACTION_TYPE_CODE
,      SERVICE_DURATION_QUANTITY
,      TRANSACTION_REASON_CODE
,      TRANSACTION_COMMENTS
,      SERVICE_MASS_TXN_TEMP_ID
,      AGREEMENT_NAME
,      AGREEMENT_ID
,      ACCOUNTING_RULE
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_ID
,      SERVICED_UNIT_CODE
,      SERVICED_PRICING_ATTRIBUTE1
,      SERVICED_PRICING_ATTRIBUTE2
,      SERVICED_PRICING_ATTRIBUTE3
,      SERVICED_PRICING_ATTRIBUTE4
,      SERVICED_PRICING_ATTRIBUTE5
,      SERVICED_PRICING_ATTRIBUTE6
,      SERVICED_PRICING_ATTRIBUTE7
,      SERVICED_PRICING_ATTRIBUTE8
,      SERVICED_PRICING_ATTRIBUTE9
,      SERVICED_PRICING_ATTRIBUTE10
,      SERVICED_PRICING_ATTRIBUTE11
,      SERVICED_PRICING_ATTRIBUTE12
,      SERVICED_PRICING_ATTRIBUTE13
,      SERVICED_PRICING_ATTRIBUTE14
,      CUSTOMER_ITEM_ID
,      CUSTOMER_JOB
,      CUSTOMER_PRODUCTION_LINE
,      CUSTOMER_MODEL_SERIAL_NUMBER
,      INTERMEDIATE_SHIP_TO_ID
,      CUSTOMER_DOCK_CODE
,      DEMAND_STREAM_ID
,      TASK_ID
,      PROJECT_ID
,      PLANNING_PROD_SEQ_NUMBER
,      SOURCE_TYPE_CODE
,      SOURCE_TYPE_NAME
,      PLANNING_PRIORITY
,      END_ITEM_UNIT_NUMBER
FROM APPS.SO_LINES_INTERFACE;

Dependencies

[top of page]

APPS

SO_LINES_INTERFACE_ALL

APPS

CS_CSXSVODS_CHECK_PKG - show dependent code

OE_DEMAND_STREAM_PROCESSOR - show dependent code