[Home] [Help] [Dependency Information]

VIEW: APPS.AP_VENDOR_SITES_V

Object Details

Object Name:	AP_VENDOR_SITES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.AP_VENDOR_SITES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      VENDOR_SITE_ID
,      VENDOR_ID
,      VENDOR_SITE_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION_CODE
,      BILL_TO_LOCATION_ID
,      BILL_TO_LOCATION_CODE
,      SHIP_VIA_LOOKUP_CODE
,      SHIP_VIA_DISP
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      CITY
,      COUNTY
,      STATE
,      ZIP
,      COUNTRY
,      PROVINCE
,      TERRITORY_SHORT_NAME
,      CONCATENATED_ADDRESS
,      AREA_CODE
,      PHONE
,      TELEX
,      FAX_AREA_CODE
,      FAX
,      LANGUAGE
,      LANGUAGE_DESCRIPTION
,      INACTIVE_DATE
,      PURCHASING_SITE_FLAG
,      PAY_SITE_FLAG
,      RFQ_ONLY_SITE_FLAG
,      FOB_LOOKUP_CODE
,      FOB_DISP
,      FREIGHT_TERMS_LOOKUP_CODE
,      FREIGHT_TERMS_DISP
,      DISTRIBUTION_SET_ID
,      DISTRIBUTION_SET_NAME
,      ACCTS_PAY_CCID
,      PREPAY_CCID
,      ALWAYS_TAKE_DISC_FLAG
,      ATTENTION_AR_FLAG
,      PAY_DATE_BASIS_LOOKUP_CODE
,      PAY_GROUP_LOOKUP_CODE
,      PAY_GROUP_DISP
,      HOLD_FUTURE_PAYMENTS_FLAG
,      HOLD_ALL_PAYMENTS_FLAG
,      HOLD_REASON
,      TERMS_DATE_BASIS
,      TAX_REPORTING_SITE_FLAG
,      TERMS_ID
,      TERMS_NAME
,      EXCLUDE_FREIGHT_FROM_DISC
,      HOLD_UNMATCHED_INV_FLAG
,      INVOICE_AMOUNT_LIMIT
,      CUSTOMER_NUM
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_PRIORITY
,      INVOICE_CURRENCY_CODE
,      AWT_GROUP_ID
,      AWT_GROUP_NAME
,      ALLOW_AWT_FLAG
,      VALIDATION_NUMBER
,      CHECK_DIGITS
,      ADDRESS_STYLE
,      TERMS_EXP_DATE
,      DIST_SET_EXP_DATE
,      SHIP_TO_EXP_DATE
,      BILL_TO_EXP_DATE
,      PAY_GROUP_EXP_DATE
,      FOB_EXP_DATE
,      FREIGHT_TERMS_EXP_DATE
,      PAY_ON_CODE
,      PAY_ON_CODE_DISP
,      DEFAULT_PAY_SITE_ID
,      DEFAULT_PAY_SITE_DISP
,      PAY_ON_RECEIPT_SUMMARY_CODE
,      PAY_ON_RECEIPT_SUMMARY_CODE_DI
,      VENDOR_SITE_CODE_ALT
,      ADDRESS_LINES_ALT
,      BANK_CHARGE_BEARER
,      TP_HEADER_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      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
,      ECE_TP_LOCATION_CODE
,      PCARD_SITE_FLAG
,      MATCH_OPTION
,      FUTURE_DATED_PAYMENT_CCID
,      CREATE_DEBIT_MEMO_FLAG
,      COUNTRY_OF_ORIGIN_CODE
,      COUNTRY_OF_ORIGIN_SHORT_NAME
,      SHIPPING_LOCATION_ID
,      SUPPLIER_NOTIF_METHOD
,      EMAIL_ADDRESS
,      PRIMARY_PAY_SITE_FLAG
,      ORG_ID
FROM APPS.AP_VENDOR_SITES_V;

Dependencies

[top of page]

APPS

AP_AWT_GROUPS

AP_DISTRIBUTION_SETS_ALL

AP_TERMS

AP_UTILITIES_PKG - show dependent code

AP_VENDOR_SITES_PKG - show dependent code

FINANCIALS_SYSTEM_PARAMS_ALL

FND_GLOBAL - show dependent code

FND_LANGUAGES_VL

FND_TERRITORIES_VL

HR_LOCATIONS_ALL

ORG_FREIGHT

PO_LOCATION_ASSOCIATIONS_ALL

PO_LOOKUP_CODES

PO_VENDOR_SITES

PO_VENDOR_SITES_ALL

APPS

AP_VENDOR_PUB_PKG - show dependent code

ITG_SYNCSUPPLIERINBOUND_PVT - show dependent code

JL_ZZ_GLOBE_VAL_PKG - show dependent code