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

TABLE: PO.PO_VENDOR_SITES_OBS

Object Details
Object Name: PO_VENDOR_SITES_OBS
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_VENDOR_SITES_OBS
Subobject Name:
Status: VALID


PO_VENDOR_SITES_ALL stores information about your supplier sites. You
need a row for each supplier site you define. Each row includes the
site address, supplier reference, purchasing, payment, bank, and
general information. Oracle Purchasing uses this information to
store supplier address information.
.
This table is one of three tables that store supplier information.
PO_VENDOR_SITES_ALL corresponds to the Sites region of the
Suppliers window.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_VENDOR_SITES_OBS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_SITE_ID
PO_VENDOR_SITES_OBS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_ID
ColumnVENDOR_SITE_CODE
ColumnORG_ID
PO_VENDOR_SITES_OBS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_SITE_CODE
PO_VENDOR_SITES_OBS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTP_HEADER_ID
ColumnECE_TP_LOCATION_CODE
PO_VENDOR_SITES_OBS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnECE_TP_LOCATION_CODE
PO_VENDOR_SITES_OBS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSELLING_COMPANY_IDENTIFIER
Columns
Name Datatype Length Mandatory Comments
VENDOR_SITE_ID NUMBER
Yes Supplier site unique identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
VENDOR_ID NUMBER
Yes Supplier unique identifier
VENDOR_SITE_CODE VARCHAR2 (15) Yes Site code name
VENDOR_SITE_CODE_ALT VARCHAR2 (320)
Alternate supplier site code for Kana Value
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PURCHASING_SITE_FLAG VARCHAR2 (1)
Indicates whether you can purchase from this site
RFQ_ONLY_SITE_FLAG VARCHAR2 (1)
Indicates whether you can only send RFQs to this site
PAY_SITE_FLAG VARCHAR2 (1)
Indicates whether you can send payments to this site
ATTENTION_AR_FLAG VARCHAR2 (1)
Indicates whether the payments should be sent to the Accounts Receivable department
ADDRESS_LINE1 VARCHAR2 (240)
First line of supplier address
ADDRESS_LINES_ALT VARCHAR2 (560)
Alternate address line for Kana Value
ADDRESS_LINE2 VARCHAR2 (240)
Second line of supplier address
ADDRESS_LINE3 VARCHAR2 (240)
Third line of supplier address
CITY VARCHAR2 (25)
City name
STATE VARCHAR2 (150)
State name or abbreviation
ZIP VARCHAR2 (20)
Postal code
PROVINCE VARCHAR2 (150)
Province
COUNTRY VARCHAR2 (25)
Country name
AREA_CODE VARCHAR2 (10)
Area code
PHONE VARCHAR2 (15)
Phone number
CUSTOMER_NUM VARCHAR2 (25)
Customer number with the supplier site
SHIP_TO_LOCATION_ID NUMBER

Default ship-to location unique identifier
BILL_TO_LOCATION_ID NUMBER

Ship-to location unique identifier
SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
Default carrier type
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)
Default freight terms type
FOB_LOOKUP_CODE VARCHAR2 (25)
Default free-on-board type
INACTIVE_DATE DATE

Inactive date for record
FAX VARCHAR2 (15)
Customer site facsimile number
FAX_AREA_CODE VARCHAR2 (10)
Customer site
TELEX VARCHAR2 (15)
Telex number
PAYMENT_METHOD_LOOKUP_CODE VARCHAR2 (25)
Default payment method type
BANK_ACCOUNT_NAME VARCHAR2 (80)
Bank account name
BANK_ACCOUNT_NUM VARCHAR2 (30)
Bank account number
BANK_NUM VARCHAR2 (25)
Bank number
BANK_ACCOUNT_TYPE VARCHAR2 (25)
Bank account type
TERMS_DATE_BASIS VARCHAR2 (25)
Type of invoice payment schedule basis
CURRENT_CATALOG_NUM VARCHAR2 (20)
Not currently used
VAT_CODE VARCHAR2 (20)
Value-added tax code
DISTRIBUTION_SET_ID NUMBER

Distribution set unique identifier
ACCTS_PAY_CODE_COMBINATION_ID NUMBER

Unique identifier for the supplier liability account
PREPAY_CODE_COMBINATION_ID NUMBER

Unique identifier for the general ledger account for prepayment
PAY_GROUP_LOOKUP_CODE VARCHAR2 (25)
Payment group type
PAYMENT_PRIORITY NUMBER

Payment priority
TERMS_ID NUMBER

Payment terms unique identifier
INVOICE_AMOUNT_LIMIT NUMBER

Maximum amount per invoice
PAY_DATE_BASIS_LOOKUP_CODE VARCHAR2 (25)
Type of payment date basis
ALWAYS_TAKE_DISC_FLAG VARCHAR2 (1)
Indicator of whether Oracle Payables should always take a discount for the supplier
INVOICE_CURRENCY_CODE VARCHAR2 (15)
Default currency unique identifier
PAYMENT_CURRENCY_CODE VARCHAR2 (15)
Default payment currency unique identifier
HOLD_ALL_PAYMENTS_FLAG VARCHAR2 (1)
Indicates whether Oracle Payables should place all payments for this supplier on hold
HOLD_FUTURE_PAYMENTS_FLAG VARCHAR2 (1)
Indicates whether Oracle Payables should place unapproved invoices for this supplier on hold
HOLD_REASON VARCHAR2 (240)
Reason that the Supplier Site has been placed on hold
HOLD_UNMATCHED_INVOICES_FLAG VARCHAR2 (1)
Indicates whether unmatched invoices should be put on hold
AP_TAX_ROUNDING_RULE VARCHAR2 (1)
Indicates the rounding rule for tax values
AUTO_TAX_CALC_FLAG VARCHAR2 (1)
Level for automatic tax calculation for supplier
AUTO_TAX_CALC_OVERRIDE VARCHAR2 (1)
Allows override of tax calculation at supplier site level
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (1)
Do amounts include tax from this supplier?
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 (1)
Exclusive payment flag
TAX_REPORTING_SITE_FLAG VARCHAR2 (1)
Tax reporting site Flag
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
VALIDATION_NUMBER NUMBER

Validation number
EXCLUDE_FREIGHT_FROM_DISCOUNT VARCHAR2 (1)
Indicates whether the freight amount is to be excluded from the discount
VAT_REGISTRATION_NUM VARCHAR2 (20)
VAT registration number
OFFSET_VAT_CODE VARCHAR2 (20)
Offset VAT code
ORG_ID NUMBER

Organization identifier
CHECK_DIGITS VARCHAR2 (30)
Check digits for Accounts Payable
BANK_NUMBER VARCHAR2 (30)
Bank number for Accounts Payable
ADDRESS_LINE4 VARCHAR2 (240)
Fourth line of address
COUNTY VARCHAR2 (150)
Supplier site county
ADDRESS_STYLE VARCHAR2 (30)
Style of address
LANGUAGE VARCHAR2 (30)
Site language
ALLOW_AWT_FLAG VARCHAR2 (1)
Indicator of whether Allow Withholding Tax is enabled
AWT_GROUP_ID NUMBER (15)
Unique identifier for the withholding tax group
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality
EDI_TRANSACTION_HANDLING VARCHAR2 (25)
ANSI standard code for EDI transaction type
EDI_ID_NUMBER VARCHAR2 (30)
EDI trading partner number for the supplier site
EDI_PAYMENT_METHOD VARCHAR2 (25)
How payment is to be made through EDI. Valid method are ACH and BOP.
EDI_PAYMENT_FORMAT VARCHAR2 (25)
Type of information being transmitted with the funds if using EDI_PATMENT_METHOD ACH. Valid values are CCD, CCP, CTP, CTX, PPD and PPP.
EDI_REMITTANCE_METHOD VARCHAR2 (25)
How remittance advice will be sent to the supplier
BANK_CHARGE_BEARER VARCHAR2 (1)
Indicator of whether this supplier site is a bank charge bearer site
EDI_REMITTANCE_INSTRUCTION VARCHAR2 (256)
Who will send the remittance advice. Valid values are banks or payables systems.
BANK_BRANCH_TYPE VARCHAR2 (25)
Which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT, and OTHER.
PAY_ON_CODE VARCHAR2 (25)
When to create an invoice. Currently, the code 'RECEIPT' is used. Future enhancements could include 'DELIVERY'.
DEFAULT_PAY_SITE_ID NUMBER (15)
Payment site for the site in which the receipt was entered.
PAY_ON_RECEIPT_SUMMARY_CODE VARCHAR2 (25)
If the PAY_ON_CODE is 'RECEIPT', then this column identifies how to consolidate the receipts to create invoices. Valid values are PAY_SITE, PACKING_SLIP, and RECEIPT.
TP_HEADER_ID NUMBER

EDI transaction header unique identifier
ECE_TP_LOCATION_CODE VARCHAR2 (60)
Trading partner location code for e-Commerce Gateway
PCARD_SITE_FLAG VARCHAR2 (1)
Indicator of whether the site allows use of procurement cards
MATCH_OPTION VARCHAR2 (25)
Indicator of whether to match the invoices to the purchase order or receipt
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Code for the country of manufacture
FUTURE_DATED_PAYMENT_CCID NUMBER (15)
Accounting Flexfield identifier for the future dated payment account
CREATE_DEBIT_MEMO_FLAG VARCHAR2 (25)
Indicator of whether a debit memo should be created
OFFSET_TAX_FLAG VARCHAR2 (1)
Indicator of whether offset tax is used
SUPPLIER_NOTIF_METHOD VARCHAR2 (25)
The preferred Notification Method for the supplier
EMAIL_ADDRESS VARCHAR2 (2000)
Email Address of the supplier Contact
REMITTANCE_EMAIL VARCHAR2 (2000)
The destination e-mail address for remittance information. Populating this field activates the E-mail Remittance Advice feature in Payables
PRIMARY_PAY_SITE_FLAG VARCHAR2 (1)
A value of Y indicates that this is the default pay site for the supplier
SHIPPING_CONTROL VARCHAR2 (30)
Indicator of who is responsible for arranging transportation
SELLING_COMPANY_IDENTIFIER VARCHAR2 (10)
Selling Company Identifier used in generating invoice numbers when gapless invoice numbering is enabled
GAPLESS_INV_NUM_FLAG VARCHAR2 (1)
Indicates whether gapless invoice numbering is used
DUNS_NUMBER VARCHAR2 (30)
DUNS Number
TOLERANCE_ID NUMBER (15)
Tolerance Unique Identifier
SERVICES_TOLERANCE_ID NUMBER (15)
Services Tolerance ID
Query Text

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


SELECT VENDOR_SITE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      VENDOR_ID
,      VENDOR_SITE_CODE
,      VENDOR_SITE_CODE_ALT
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PURCHASING_SITE_FLAG
,      RFQ_ONLY_SITE_FLAG
,      PAY_SITE_FLAG
,      ATTENTION_AR_FLAG
,      ADDRESS_LINE1
,      ADDRESS_LINES_ALT
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY
,      STATE
,      ZIP
,      PROVINCE
,      COUNTRY
,      AREA_CODE
,      PHONE
,      CUSTOMER_NUM
,      SHIP_TO_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      SHIP_VIA_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      FOB_LOOKUP_CODE
,      INACTIVE_DATE
,      FAX
,      FAX_AREA_CODE
,      TELEX
,      PAYMENT_METHOD_LOOKUP_CODE
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      BANK_NUM
,      BANK_ACCOUNT_TYPE
,      TERMS_DATE_BASIS
,      CURRENT_CATALOG_NUM
,      VAT_CODE
,      DISTRIBUTION_SET_ID
,      ACCTS_PAY_CODE_COMBINATION_ID
,      PREPAY_CODE_COMBINATION_ID
,      PAY_GROUP_LOOKUP_CODE
,      PAYMENT_PRIORITY
,      TERMS_ID
,      INVOICE_AMOUNT_LIMIT
,      PAY_DATE_BASIS_LOOKUP_CODE
,      ALWAYS_TAKE_DISC_FLAG
,      INVOICE_CURRENCY_CODE
,      PAYMENT_CURRENCY_CODE
,      HOLD_ALL_PAYMENTS_FLAG
,      HOLD_FUTURE_PAYMENTS_FLAG
,      HOLD_REASON
,      HOLD_UNMATCHED_INVOICES_FLAG
,      AP_TAX_ROUNDING_RULE
,      AUTO_TAX_CALC_FLAG
,      AUTO_TAX_CALC_OVERRIDE
,      AMOUNT_INCLUDES_TAX_FLAG
,      EXCLUSIVE_PAYMENT_FLAG
,      TAX_REPORTING_SITE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      VALIDATION_NUMBER
,      EXCLUDE_FREIGHT_FROM_DISCOUNT
,      VAT_REGISTRATION_NUM
,      OFFSET_VAT_CODE
,      ORG_ID
,      CHECK_DIGITS
,      BANK_NUMBER
,      ADDRESS_LINE4
,      COUNTY
,      ADDRESS_STYLE
,      LANGUAGE
,      ALLOW_AWT_FLAG
,      AWT_GROUP_ID
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      EDI_TRANSACTION_HANDLING
,      EDI_ID_NUMBER
,      EDI_PAYMENT_METHOD
,      EDI_PAYMENT_FORMAT
,      EDI_REMITTANCE_METHOD
,      BANK_CHARGE_BEARER
,      EDI_REMITTANCE_INSTRUCTION
,      BANK_BRANCH_TYPE
,      PAY_ON_CODE
,      DEFAULT_PAY_SITE_ID
,      PAY_ON_RECEIPT_SUMMARY_CODE
,      TP_HEADER_ID
,      ECE_TP_LOCATION_CODE
,      PCARD_SITE_FLAG
,      MATCH_OPTION
,      COUNTRY_OF_ORIGIN_CODE
,      FUTURE_DATED_PAYMENT_CCID
,      CREATE_DEBIT_MEMO_FLAG
,      OFFSET_TAX_FLAG
,      SUPPLIER_NOTIF_METHOD
,      EMAIL_ADDRESS
,      REMITTANCE_EMAIL
,      PRIMARY_PAY_SITE_FLAG
,      SHIPPING_CONTROL
,      SELLING_COMPANY_IDENTIFIER
,      GAPLESS_INV_NUM_FLAG
,      DUNS_NUMBER
,      TOLERANCE_ID
,      SERVICES_TOLERANCE_ID
FROM PO.PO_VENDOR_SITES_OBS;

Dependencies

[top of page]

PO.PO_VENDOR_SITES_OBS does not reference any database object

PO.PO_VENDOR_SITES_OBS is referenced by following:

SchemaPO
ViewPO_VENDOR_SITES_OBS#