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

TABLE: AP.AP_SUPPLIER_SITES_ALL

Object Details
Object Name: AP_SUPPLIER_SITES_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_SUPPLIER_SITES_ALL
Subobject Name:
Status: VALID


AP_SUPPLIER_SITES_ALL stores information about supplier site level attributes. A row in this table stores unique combination of supplier address, operating unit and the business relationship defined with the supplier. This table replaces the old PO_VENDOR_SITES_ALL table. A new view PO_VENDOR_SITES_ALL is created on this table.
The supplier address information is not maintained in this table and is maintained in Trading Community Architecture (TCA). The reference to the internal identifier of address in TCA will be stored in AP_SUPPLIER_SITES_ALL.LOCATION_ID, to link the address record in TCA table HZ_LOCATIONS. Each row includes the supplier reference, purchasing, invoice, and general information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_SUPPLIER_SITES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_SITE_ID
AP_SUPPLIER_SITES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_ID
ColumnVENDOR_SITE_CODE
ColumnORG_ID
AP_SUPPLIER_SITES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_SITE_CODE
AP_SUPPLIER_SITES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTP_HEADER_ID
ColumnECE_TP_LOCATION_CODE
AP_SUPPLIER_SITES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnECE_TP_LOCATION_CODE
AP_SUPPLIER_SITES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSELLING_COMPANY_IDENTIFIER
AP_SUPPLIER_SITES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_ID
AP_SUPPLIER_SITES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_SITE_ID
Columns
Name Datatype Length Mandatory Comments
VENDOR_SITE_ID NUMBER
Yes Unique internal Identifier for this record. Generated using a database sequence.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table.
VENDOR_ID NUMBER
Yes Supplier unique identifier
VENDOR_SITE_CODE VARCHAR2 (15) Yes Site code name. Unique name assigned to the supplier site.
VENDOR_SITE_CODE_ALT VARCHAR2 (320)
Indicates the alternate supplier site code used primarily for Kana values.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table.
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table.
PURCHASING_SITE_FLAG VARCHAR2 (1)
Indicates whether or not purchasing is allowed from the site.
RFQ_ONLY_SITE_FLAG VARCHAR2 (1)
Indicates whether or not purchasing is allowed from the site.
PAY_SITE_FLAG VARCHAR2 (1)
Indicates whether or not payments are allowed to the 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 site address.
ADDRESS_LINES_ALT VARCHAR2 (560)
Alternate address line for Kana Value of the supplier site address.
ADDRESS_LINE2 VARCHAR2 (240)
Second line of supplier site address.
ADDRESS_LINE3 VARCHAR2 (240)
Third line of supplier site 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 for the supplier site. Validated against PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID.
BILL_TO_LOCATION_ID NUMBER

Default unique identifier for the location for the supplier site where the supplier sends invoices for goods and services. Validated against HR_LOCATIONS_ALL.LOCATION_ID where HR_LOCATIONS_ALL.BILL_TO_SITE_FLAG = 'Y'.
SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
Default freight career for the supplier. Validated against ORG_FREIGHT.FREIGHT_CODE.
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)
Default freight terms for the supplier. Validated against FND_LOOKUP_VALUES.LOOKUP_TYPE = 'FREIGHT TERMS'.
FOB_LOOKUP_CODE VARCHAR2 (25)
Default free-on-board type for the supplier. Validated against FND_LOOKUP_VALUES.LOOKUP_TYPE = 'FOB'.
INACTIVE_DATE DATE

Inactive date for the supplier site.
FAX VARCHAR2 (15)
Supplier site facsimile number.
FAX_AREA_CODE VARCHAR2 (10)
Supplier site area code for facsimile number.
TELEX VARCHAR2 (15)
Supplier site telex number.
PAYMENT_METHOD_LOOKUP_CODE VARCHAR2 (25)
Indicates the default method of payment for the supplier site.
BANK_ACCOUNT_NAME VARCHAR2 (80)
No longer used
BANK_ACCOUNT_NUM VARCHAR2 (30)
No longer used
BANK_NUM VARCHAR2 (25)
No longer used
BANK_ACCOUNT_TYPE VARCHAR2 (25)
No longer used
TERMS_DATE_BASIS VARCHAR2 (25)
The date from which Payables calculates a scheduled payment for the supplier site. The valid values are:- Current- Goods Received- Invoice- Invoice Received
CURRENT_CATALOG_NUM VARCHAR2 (20)
Not currently used
VAT_CODE VARCHAR2 (30)
Indicates the default tax code for invoices entered for the supplier site.
DISTRIBUTION_SET_ID NUMBER

Indicates unique identifier for the distribution set that is applied to invoices from the supplier site.
ACCTS_PAY_CODE_COMBINATION_ID NUMBER

Indicates the default liability account for invoices from the supplier site.
PREPAY_CODE_COMBINATION_ID NUMBER

Indicates unique identifier for the general ledger account for prepayment.
PAY_GROUP_LOOKUP_CODE VARCHAR2 (25)
Indicates pay group for the supplier site. It can be used in payment batch processing for grouping category of supplier sites. Possible values for this column are derived from FND_LOOKUP_VALUES for lookup_type 'PAY GROUP'.
PAYMENT_PRIORITY NUMBER

Indicates payment priority for the supplier site.
TERMS_ID NUMBER

Indicates the unique identifier for the terms on invoices from the supplier site.
INVOICE_AMOUNT_LIMIT NUMBER

Indicates the maximum amount allowed on invoices from the supplier site.
PAY_DATE_BASIS_LOOKUP_CODE VARCHAR2 (25)
Indicates the Pay Date Basis determines the pay date for the supplier site invoices: Discount or Due.
ALWAYS_TAKE_DISC_FLAG VARCHAR2 (1)
Indicator of whether Oracle Payables should always take a discount for the supplier site.
INVOICE_CURRENCY_CODE VARCHAR2 (15)
Indicates the default currency for Purchasing documents and Payables transactions from the supplier site.
PAYMENT_CURRENCY_CODE VARCHAR2 (15)
Indicates the default currency for Payments to this supplier site.
HOLD_ALL_PAYMENTS_FLAG VARCHAR2 (1)
Indicates whether Oracle Payables should place all payments for this supplier site on hold.
HOLD_FUTURE_PAYMENTS_FLAG VARCHAR2 (1)
Indicates whether Oracle Payables should place unapproved invoices for this supplier site 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 for the supplier site.
AP_TAX_ROUNDING_RULE VARCHAR2 (1)
Indicates the rounding rule for tax values on invoices from the supplier site.
AUTO_TAX_CALC_FLAG VARCHAR2 (1)
Indicates the level for automatic tax calculation for the supplier site.
AUTO_TAX_CALC_OVERRIDE VARCHAR2 (1)
Indicates if override of tax calculation is allowed at supplier site level.
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (1)
Indicates if amounts on invoices from the supplier include tax.
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 (1)
Indicates whether or not separate payments should be created for each invoice for the supplier site.
TAX_REPORTING_SITE_FLAG VARCHAR2 (1)
Indicates whether or not the site is the 1099-reporting site for the supplier.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segment
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 the APPLICATION_ID column of the FND_APPLICATION table.
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row. Foreign key to the CONCURRENT_PROGRAM_ID column of the FND_CONCURRENT_PROGRAM table.
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 if the freight amount is to be excluded from the discount on invoices issued by the supplier site.
VAT_REGISTRATION_NUM VARCHAR2 (20)
Tax registration number for the supplier site.
OFFSET_VAT_CODE VARCHAR2 (20)
Offset VAT code
ORG_ID NUMBER

Operating unit unique identifier
CHECK_DIGITS VARCHAR2 (30)
Check digits for Accounts Payable
BANK_NUMBER VARCHAR2 (30)
No longer used
ADDRESS_LINE4 VARCHAR2 (240)
Fourth line of the supplier site address.
COUNTY VARCHAR2 (150)
Supplier site county.
ADDRESS_STYLE VARCHAR2 (30)
Address style for the supplier site.
LANGUAGE VARCHAR2 (30)
Language for the supplier site.
ALLOW_AWT_FLAG VARCHAR2 (1)
Indicates whether automatic withholding is allowed for the supplier site.
AWT_GROUP_ID NUMBER (15)
Indicates the unique identifier for the withholding tax group for supplier site invoices.
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)
No longer used
EDI_ID_NUMBER VARCHAR2 (30)
EDI Trading Partner Number for the Supplier Site
EDI_PAYMENT_METHOD VARCHAR2 (25)
No longer used
EDI_PAYMENT_FORMAT VARCHAR2 (25)
No longer used
EDI_REMITTANCE_METHOD VARCHAR2 (25)
No longer used
BANK_CHARGE_BEARER VARCHAR2 (1)
Indicates who pays the bank charges assessed on payments to this supplier. Validated against FND_LOOKUP_VALUES where LOOKUP_TYPE = 'BANK CHARGE BEARER'. Valid values are: 'I', 'N', 'S'.
EDI_REMITTANCE_INSTRUCTION VARCHAR2 (256)
No longer used
BANK_BRANCH_TYPE VARCHAR2 (25)
No longer used
PAY_ON_CODE VARCHAR2 (25)
This column indicates when to create an invoice, if 'Self Billing' feature used in Oracle Purchasing. Valid values are 'RECEIPT', 'USE', or 'RECEIPT_AND_USE'. Value in this column is valid only if PURCHASING_SITE_FLAG is set to 'Y' for this supplier site.
DEFAULT_PAY_SITE_ID NUMBER (15)
Indicates the supplier site from which payments are made for invoices created by the 'Payment on Receipt' process.
PAY_ON_RECEIPT_SUMMARY_CODE VARCHAR2 (25)
Indicates the level at which invoices are consolidated for the supplier site by the 'Payment on Receipt' process. The default value is PAY_SITE. The valid values are PACKING_SLIP, PAY_SITE, 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)
Indicates the country in which goods are manufactured.
FUTURE_DATED_PAYMENT_CCID NUMBER (15)
Accounting Flexfield identifier for the future dated payment account for the supplier site.
CREATE_DEBIT_MEMO_FLAG VARCHAR2 (25)
Indicates whether debit memos are to be created automatically when a Return to Supplier transaction is entered in Oracle Purchasing.
OFFSET_TAX_FLAG VARCHAR2 (1)
Indicates whether offset taxes are allowed on invoices from the supplier site.
SUPPLIER_NOTIF_METHOD VARCHAR2 (25)
Indicates the primary method for sending purchase orders to the supplier site. This value defaults to 'EMAIL'. The valid values are EMAIL, PRINT, FAX.
EMAIL_ADDRESS VARCHAR2 (2000)
Email address of the supplier site 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)
Indicates the default pay site for the supplier site.
SHIPPING_CONTROL VARCHAR2 (30)
Indicator of who is responsible for arranging transportation. The valid values are SUPPLIER, BUYER.
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)
A unique 9-digit identification number assigned to all business entities in Dun & Bradstreet's database.
TOLERANCE_ID NUMBER (15)
Tolerance Idetifier
LOCATION_ID NUMBER (15)
Location Identifier
PARTY_SITE_ID NUMBER (15)
Party Site Identifier
SERVICES_TOLERANCE_ID NUMBER (15)
Services Tolerance Identifier
RETAINAGE_RATE NUMBER

Maximum percentage that can be withheld from an invoice as Retainage
TCA_SYNC_STATE VARCHAR2 (150)
For internal use only
TCA_SYNC_PROVINCE VARCHAR2 (150)
For internal use only
TCA_SYNC_COUNTY VARCHAR2 (150)
For internal use only
TCA_SYNC_CITY VARCHAR2 (60)
For internal use only
TCA_SYNC_ZIP VARCHAR2 (60)
For internal use only
TCA_SYNC_COUNTRY VARCHAR2 (60)
For internal use only
PAY_AWT_GROUP_ID NUMBER (15)
Withholding tax group identifier at Payment time. Validated against AP_AWT_GROUPS.AWT_GROUP_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
,      LOCATION_ID
,      PARTY_SITE_ID
,      SERVICES_TOLERANCE_ID
,      RETAINAGE_RATE
,      TCA_SYNC_STATE
,      TCA_SYNC_PROVINCE
,      TCA_SYNC_COUNTY
,      TCA_SYNC_CITY
,      TCA_SYNC_ZIP
,      TCA_SYNC_COUNTRY
,      PAY_AWT_GROUP_ID
FROM AP.AP_SUPPLIER_SITES_ALL;

Dependencies

[top of page]

AP.AP_SUPPLIER_SITES_ALL does not reference any database object

AP.AP_SUPPLIER_SITES_ALL is referenced by following:

SchemaAPPS
SynonymAP_SUPPLIER_SITES
SynonymAP_SUPPLIER_SITES_ALL
TriggerJAI_PO_VSA_ARIUD_T1
Materialized ViewPOA_IDL_BS_J_MV