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

VIEW: APPS.SO_HEADERS

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


[View Source]

Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

SHIP_TO_SVRID NUMBER


SHIP_TO_CONTACT_SVRID NUMBER


INVOICE_TO_SVRID NUMBER


INVOICE_TO_CONTACT_SVRID NUMBER


AGREEMENT_SVRID NUMBER


PO_NUMBER_SVRID NUMBER


REQUEST_DATE_SVRID NUMBER


SALESPERSON_SVRID NUMBER


SALES_CHANNEL_SVRID NUMBER


PRICE_LIST_SVRID NUMBER


CURRENCY_SVRID NUMBER


CONVERSION_TYPE_SVRID NUMBER


CONVERSION_DATE_SVRID NUMBER


CONVERSION_RATE_SVRID NUMBER


INVOICING_RULE_SVRID NUMBER


ACCOUNTING_RULE_SVRID NUMBER


PAYMENT_TERMS_SVRID NUMBER


TAX_EXEMPT_NUMBER_SVRID NUMBER


TAX_EXEMPT_REASON_SVRID NUMBER


SHIPMENT_PRIORITY_SVRID NUMBER


FREIGHT_CARRIER_SVRID NUMBER


FREIGHT_TERMS_SVRID NUMBER


FOB_SVRID NUMBER


SHIP_PARTIAL_SVRID NUMBER


WAREHOUSE_SVRID NUMBER


DEMAND_CLASS_SVRID NUMBER


PACKING_INSTRUCTIONS_SVRID NUMBER


SHIPPING_INSTRUCTIONS_SVRID NUMBER


PAYMENT_TYPE_SVRID NUMBER


PAYMENT_AMOUNT_SVRID NUMBER


CHECK_NUMBER_SVRID NUMBER


CREDIT_CARD_SVRID 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)

SHIP_PARTIAL_FLAG VARCHAR2 (1)

WAREHOUSE_ID NUMBER


DEMAND_CLASS_CODE VARCHAR2 (30)

SHIPPING_INSTRUCTIONS VARCHAR2 (240)

PACKING_INSTRUCTIONS VARCHAR2 (240)

AGREEMENT_ID NUMBER


SALESREP_ID NUMBER


SALES_CHANNEL_CODE VARCHAR2 (30)

PRICE_LIST_ID NUMBER


CURRENCY_CODE VARCHAR2 (15) Yes
CONVERSION_TYPE_CODE VARCHAR2 (30)

CONVERSION_RATE NUMBER


CONVERSION_DATE DATE


TERMS_ID NUMBER


INVOICING_RULE_ID NUMBER


ACCOUNTING_RULE_ID NUMBER


TAX_EXEMPT_FLAG VARCHAR2 (1)

TAX_EXEMPT_NUM VARCHAR2 (80)

TAX_EXEMPT_REASON_CODE VARCHAR2 (30)

PAYMENT_TYPE_CODE VARCHAR2 (30)

PAYMENT_AMOUNT NUMBER


CHECK_NUMBER VARCHAR2 (50)

CREDIT_CARD_CODE VARCHAR2 (30)

CREDIT_CARD_HOLDER_NAME VARCHAR2 (50)

CREDIT_CARD_NUMBER VARCHAR2 (50)

CREDIT_CARD_EXPIRATION_DATE DATE


CREDIT_CARD_APPROVAL_CODE VARCHAR2 (50)

ORG_ID NUMBER


DATE_SVRID NUMBER


ENTRY_STATUS_SVRID NUMBER


TYPE_SVRID NUMBER


CUSTOMER_SVRID NUMBER


CONTACT_SVRID NUMBER


S18 NUMBER


HEADER_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


ORDER_NUMBER NUMBER
Yes
ORDER_CATEGORY VARCHAR2 (30) Yes
ORIGINAL_SYSTEM_SOURCE_CODE VARCHAR2 (30)

ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)

SOURCE_HEADER_ID NUMBER


ORDER_TYPE_ID NUMBER
Yes
CYCLE_ID NUMBER
Yes
DATE_ORDERED DATE


OPEN_FLAG VARCHAR2 (1)

CANCELLED_FLAG VARCHAR2 (1)

CUSTOMER_ID NUMBER


ORDERED_BY_CONTACT_ID NUMBER


SHIP_TO_SITE_USE_ID NUMBER


SHIP_TO_CONTACT_ID NUMBER


INVOICE_TO_SITE_USE_ID NUMBER


INVOICE_TO_CONTACT_ID NUMBER


PURCHASE_ORDER_NUM VARCHAR2 (50)

DATE_REQUESTED_CURRENT DATE


SHIPMENT_PRIORITY_CODE VARCHAR2 (30)

SHIP_METHOD_CODE VARCHAR2 (30)

FREIGHT_TERMS_CODE VARCHAR2 (30)

FOB_CODE VARCHAR2 (30)

CREDIT_CARD_HOLDER_SVRID NUMBER


CREDIT_CARD_NUMBER_SVRID NUMBER


CREDIT_CARD_EXP_DATE_SVRID NUMBER


CREDIT_CARD_APP_CODE_SVRID NUMBER


DF_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


WH_UPDATE_DATE DATE

Query Text

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


SELECT ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SHIP_TO_SVRID
,      SHIP_TO_CONTACT_SVRID
,      INVOICE_TO_SVRID
,      INVOICE_TO_CONTACT_SVRID
,      AGREEMENT_SVRID
,      PO_NUMBER_SVRID
,      REQUEST_DATE_SVRID
,      SALESPERSON_SVRID
,      SALES_CHANNEL_SVRID
,      PRICE_LIST_SVRID
,      CURRENCY_SVRID
,      CONVERSION_TYPE_SVRID
,      CONVERSION_DATE_SVRID
,      CONVERSION_RATE_SVRID
,      INVOICING_RULE_SVRID
,      ACCOUNTING_RULE_SVRID
,      PAYMENT_TERMS_SVRID
,      TAX_EXEMPT_NUMBER_SVRID
,      TAX_EXEMPT_REASON_SVRID
,      SHIPMENT_PRIORITY_SVRID
,      FREIGHT_CARRIER_SVRID
,      FREIGHT_TERMS_SVRID
,      FOB_SVRID
,      SHIP_PARTIAL_SVRID
,      WAREHOUSE_SVRID
,      DEMAND_CLASS_SVRID
,      PACKING_INSTRUCTIONS_SVRID
,      SHIPPING_INSTRUCTIONS_SVRID
,      PAYMENT_TYPE_SVRID
,      PAYMENT_AMOUNT_SVRID
,      CHECK_NUMBER_SVRID
,      CREDIT_CARD_SVRID
,      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
,      SHIP_PARTIAL_FLAG
,      WAREHOUSE_ID
,      DEMAND_CLASS_CODE
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      AGREEMENT_ID
,      SALESREP_ID
,      SALES_CHANNEL_CODE
,      PRICE_LIST_ID
,      CURRENCY_CODE
,      CONVERSION_TYPE_CODE
,      CONVERSION_RATE
,      CONVERSION_DATE
,      TERMS_ID
,      INVOICING_RULE_ID
,      ACCOUNTING_RULE_ID
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUM
,      TAX_EXEMPT_REASON_CODE
,      PAYMENT_TYPE_CODE
,      PAYMENT_AMOUNT
,      CHECK_NUMBER
,      CREDIT_CARD_CODE
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_EXPIRATION_DATE
,      CREDIT_CARD_APPROVAL_CODE
,      ORG_ID
,      DATE_SVRID
,      ENTRY_STATUS_SVRID
,      TYPE_SVRID
,      CUSTOMER_SVRID
,      CONTACT_SVRID
,      S18
,      HEADER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORDER_NUMBER
,      ORDER_CATEGORY
,      ORIGINAL_SYSTEM_SOURCE_CODE
,      ORIGINAL_SYSTEM_REFERENCE
,      SOURCE_HEADER_ID
,      ORDER_TYPE_ID
,      CYCLE_ID
,      DATE_ORDERED
,      OPEN_FLAG
,      CANCELLED_FLAG
,      CUSTOMER_ID
,      ORDERED_BY_CONTACT_ID
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CONTACT_ID
,      INVOICE_TO_SITE_USE_ID
,      INVOICE_TO_CONTACT_ID
,      PURCHASE_ORDER_NUM
,      DATE_REQUESTED_CURRENT
,      SHIPMENT_PRIORITY_CODE
,      SHIP_METHOD_CODE
,      FREIGHT_TERMS_CODE
,      FOB_CODE
,      CREDIT_CARD_HOLDER_SVRID
,      CREDIT_CARD_NUMBER_SVRID
,      CREDIT_CARD_EXP_DATE_SVRID
,      CREDIT_CARD_APP_CODE_SVRID
,      DF_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
,      WH_UPDATE_DATE
FROM APPS.SO_HEADERS;

Dependencies

[top of page]

APPS.SO_HEADERS references the following:

SchemaAPPS
SynonymSO_HEADERS_ALL
APPS.SO_HEADERS is referenced by following:

SchemaAPPS
Package BodyCS_CSXSVODS_CHECK_PKG - show dependent code
ViewICX_EDM_CUSTOMER_TASK_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 BodyOE_CANCEL - show dependent code
Package BodyOE_DEMAND_STREAM_PROCESSOR - show dependent code
Package BodyOE_ORDER_IMPORT_INTEROP_PUB - show dependent code
Package BodyOE_QUERY - show dependent code
Package BodySHPLEFT - show dependent code
Package BodySO_ATT - show dependent code
ViewSO_LINES_CURRENT_DEMAND_V
ViewSO_LINES_RETURN_LINES_V
ViewSO_LINES_RMA_V
ViewSO_LINES_VIEW_RETURNS_V
ViewSO_LINE_SALES_CREDITS
ViewSO_ORDER_CANCELLATIONS_V
ViewSO_ORDER_HEADER_STATUS
ViewSO_ORDER_STATUS_V
Package BodySO_PRICE_LIST_LINES_PKG - show dependent code
Package BodyWSH_DEL_OI_CORE - show dependent code