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

VIEW: APPS.SO_LINES

Object Details
Object Name: SO_LINES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOE.SO_LINES
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_ALL view for access from other products


[View Source]

Columns
Name Datatype Length Mandatory Comments
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


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


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


DATE_REQUESTED_CURRENT DATE


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


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


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


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


WH_UPDATE_DATE DATE

CUSTOMER_ITEM_ID NUMBER

CUSTOMER_JOB VARCHAR2 (50)
CUSTOMER_PRODUCTION_LINE VARCHAR2 (50)
CUSTOMER_MODEL_SERIAL_NUMBER VARCHAR2 (50)
INTERMEDIATE_SHIP_TO_ID NUMBER

CUSTOMER_DOCK_CODE VARCHAR2 (50)
PLANNING_PROD_SEQ_NUMBER VARCHAR2 (50)
DEMAND_STREAM_ID NUMBER

TASK_ID NUMBER

PROJECT_ID NUMBER

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


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


RETURN_FOR_REPAIR_FLAG VARCHAR2 (1)
SOURCE_TYPE_CODE VARCHAR2 (30)
SOURCE_TYPE_CODE_SVRID NUMBER

PLANNING_PRIORITY NUMBER

PLANNING_PRIORITY_SVRID NUMBER

END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Query Text

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


SELECT S30_DATE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRICING_DATE
,      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
,      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
,      DATE_REQUESTED_CURRENT
,      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
,      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
,      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
,      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
,      WH_UPDATE_DATE
,      CUSTOMER_ITEM_ID
,      CUSTOMER_JOB
,      CUSTOMER_PRODUCTION_LINE
,      CUSTOMER_MODEL_SERIAL_NUMBER
,      INTERMEDIATE_SHIP_TO_ID
,      CUSTOMER_DOCK_CODE
,      PLANNING_PROD_SEQ_NUMBER
,      DEMAND_STREAM_ID
,      TASK_ID
,      PROJECT_ID
,      S5
,      S5_DATE
,      S6
,      S6_DATE
,      S7
,      S7_DATE
,      S8
,      S8_DATE
,      S9
,      S9_DATE
,      S10
,      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
,      RETURN_FOR_REPAIR_FLAG
,      SOURCE_TYPE_CODE
,      SOURCE_TYPE_CODE_SVRID
,      PLANNING_PRIORITY
,      PLANNING_PRIORITY_SVRID
,      END_ITEM_UNIT_NUMBER
FROM APPS.SO_LINES;

Dependencies

[top of page]

APPS.SO_LINES references the following:

SchemaAPPS
SynonymSO_LINES_ALL
APPS.SO_LINES is referenced by following:

SchemaAPPS
Package BodyCS_CSXSVODS_CHECK_PKG - show dependent code
ViewICX_EDM_CUSTOMER_TASK_V
ViewICX_ENG_WEB_SCHEDULE_SO_V
ViewICX_SO_LINES_VIEW_LINES_V
ViewICX_SO_LINES_VIEW_RETURNS_V
Package BodyOEP_CMERGE_OEORD - show dependent code
Package BodyOEXPURGE - show dependent code
Package BodyOEXVWCAN - show dependent code
Package BodyOEXVWLIN - show dependent code
Package BodyOE_ACCOUNTING - show dependent code
Package BodyOE_CANCEL - show dependent code
Package BodyOE_CANSRV - show dependent code
Package BodyOE_DEMAND_STREAM_PROCESSOR - show dependent code
Package BodyOE_LIN - show dependent code
Package BodyOE_LINE_DETAILS_PKG - show dependent code
Package BodyOE_LINE_UTILITY - show dependent code
Package BodyOE_LIN_SCH - show dependent code
Package BodyOE_OPT_PROCESS - show dependent code
Package BodyOE_ORDER_IMPORT_INTEROP_PUB - show dependent code
Package BodyOE_PAYMENTS_UTIL - show dependent code
Package BodyOE_QUERY - show dependent code
Package BodyOE_RMA_LINE_VALIDATE - show dependent code
Package BodyOE_RMA_QUERY_PRICE - show dependent code
Package BodyOE_RMA_TOTAL - show dependent code
Package BodyOE_SERVICES_PROCESS - show dependent code
Package BodyOE_SHP_PROCESS - show dependent code
Package BodyOE_SO_ATO - show dependent code
Package BodyOE_SO_LIN_VALIDATE - show dependent code
Package BodyQA_PLAN_ELEMENT_API - show dependent code
Package BodySHPBKLOG - show dependent code
Package BodySHPLEFT - show dependent code
ViewSO_DROP_SHIP_LINKS_V
ViewSO_LINES_CANCEL_V
ViewSO_LINES_CURRENT_DEMAND_V
ViewSO_LINES_RETURN_LINES_V
ViewSO_LINES_RMA_V
ViewSO_LINES_SUMMARY_V
ViewSO_LINES_VIEW_RETURNS_V
ViewSO_LINE_SALES_CREDITS
ViewSO_MFG_STATUS_VIEW
ViewSO_MODEL_LINE_COGS_ACCOUNT
ViewSO_OPEN_ORDER_INVOICE_REFS_V
ViewSO_ORDER_CANCELLATIONS_V
ViewSO_ORDER_LINE_STATUS
ViewSO_ORDER_STATUS_V
Package BodySO_PRICE_LIST_LINES_PKG - show dependent code
ViewSO_SCHEDULE_DETAILS
ViewSO_SERVICE_DETAILS
Package BodyWSH_FLEX_PKG_COGS - show dependent code