[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | POFV_SUPPLIER_SITES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PO.POFV_SUPPLIER_SITES
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SUPPLIER_SITE_ID | NUMBER | Yes | ||
| SUPPLIER_SITE_NAME | VARCHAR2 | (15) | ||
| SUPPLIER_ID | NUMBER | Yes | ||
| SUPPLIER_NAME | VARCHAR2 | (240) | ||
| OPERATING_UNIT_ID | NUMBER | |||
| OPERATING_UNIT_NAME | VARCHAR2 | (240) | Yes | |
| ALTERNATE_SUPPLIER_SITE_NAME | VARCHAR2 | (320) | ||
| COUNTRY | VARCHAR2 | (25) | ||
| ADDRESS_LINE_1 | VARCHAR2 | (240) | ||
| ADDRESS_LINE_2 | VARCHAR2 | (240) | ||
| ADDRESS_LINE_3 | VARCHAR2 | (240) | ||
| ADDRESS_LINE_4 | VARCHAR2 | (240) | ||
| CITY | VARCHAR2 | (60) | ||
| STATE | VARCHAR2 | (60) | ||
| POSTAL_CODE | VARCHAR2 | (20) | ||
| PROVINCE | VARCHAR2 | (60) | ||
| COUNTY | VARCHAR2 | (60) | ||
| ALTERNATE_ADDRESS | VARCHAR2 | (560) | ||
| LANGUAGE | VARCHAR2 | (30) | ||
| INACTIVE_DATE | DATE | |||
| _LA:PAY_SITE_FLAG | CHAR | (59) | ||
| _LA:PURCHASING_SITE_FLAG | CHAR | (66) | ||
| _LA:RFQ_ONLY_SITE_FLAG | CHAR | (64) | ||
| AREA_CODE | VARCHAR2 | (10) | ||
| PHONE_NUMBER | VARCHAR2 | (15) | ||
| TELEX_NUMBER | VARCHAR2 | (15) | ||
| FAX_AREA_CODE | VARCHAR2 | (10) | ||
| FAX_NUMBER | VARCHAR2 | (15) | ||
| INVOICE_TAX_NAME | VARCHAR2 | (0) | ||
| OFFSET_TAX_NAME | VARCHAR2 | (0) | ||
| TAX_CALCULATION_LEVEL | VARCHAR2 | (0) | ||
| _LA:ALLOW_TAX_CALC_OVERRIDE | CHAR | (68) | ||
| TAX_ROUNDING_RULE | VARCHAR2 | (0) | ||
| _LA:AMOUNTS_INCLUDE_TAX_FLAG | CHAR | (70) | ||
| VAT_REGISTRATION_NUMBER | VARCHAR2 | (0) | ||
| _LA:TAX_REPORTING_SITE_FLAG | CHAR | (69) | ||
| INVOICE_AMOUNT_LIMIT | NUMBER | |||
| _LA:HOLD_ALL_PAYMENTS | CHAR | (68) | ||
| _LA:HOLD_FUTURE_PAYMENTS | CHAR | (71) | ||
| _LA:HOLD_UNMATCHED_INVOICES | CHAR | (74) | ||
| HOLD_REASON | VARCHAR2 | (240) | ||
| _LA:PAY_GROUP | CHAR | (70) | ||
| PAYMENT_PRIORITY | NUMBER | |||
| _LA:TERMS_DATE_BASIS | CHAR | (72) | ||
| _LA:PAY_DATE_BASIS | CHAR | (80) | ||
| _LA:PAYMENT_METHOD | CHAR | (80) | ||
| _LA:ALWAYS_TAKE_DISCOUNT | CHAR | (67) | ||
| _LA:EXCL_FREIGHT_FROM_DISC | CHAR | (75) | ||
| _LA:PAY_ALONE_FLAG | CHAR | (68) | ||
| _LA:ATTENTION_AR_FLAG | CHAR | (63) | ||
| _LA:FREIGHT_TERMS | CHAR | (78) | ||
| _LA:FREE_ON_BOARD_POINT | CHAR | (45) | ||
| _LA:PAY_ON | CHAR | (66) | ||
| _LA:INVOICE_SUMMARY_LEVEL | CHAR | (86) | ||
| _LA:ALLOW_WITHHOLDING_FLAG | CHAR | (60) | ||
| EDI_ID_NUMBER | VARCHAR2 | (0) | ||
| EDI_PAYMENT_METHOD | VARCHAR2 | (0) | ||
| EDI_PAYMENT_FORMAT | VARCHAR2 | (0) | ||
| EDI_REMITTANCE_METHOD | VARCHAR2 | (0) | ||
| EDI_REMITTANCE_INSTRUCTION | VARCHAR2 | (0) | ||
| EDI_TRANSACTION_HANLDING | VARCHAR2 | (0) | ||
| _DF | CHAR | (25) | ||
| LIABILITY_ACCOUNT_ID | NUMBER | |||
| _KF:ACCOUNT_NUM:LIABTY:_CO | CHAR | (16) | ||
| PREPAYMENT_ACCOUNT_ID | NUMBER | |||
| _KF:ACCOUNT_NUM:PREPAY:_CO | CHAR | (16) | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | ||
| INVOICE_CURRENCY | VARCHAR2 | (80) | ||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | ||
| PAYMENT_CURRENCY | VARCHAR2 | (80) | ||
| PAYMENT_TERMS_ID | NUMBER | |||
| PAYMENT_TERMS_NAME | VARCHAR2 | (50) | ||
| SHIP_TO_LOCATION_ID | NUMBER | |||
| SHIP_TO_LOCATION | VARCHAR2 | (60) | ||
| BILL_TO_LOCATION_ID | NUMBER | |||
| BILL_TO_LOCATION | VARCHAR2 | (60) | ||
| CARRIER | VARCHAR2 | (25) | ||
| CARRIER_DESCRIPTION | VARCHAR2 | (80) | ||
| CARRIER_ORGANIZATION_ID | NUMBER | |||
| CARRIER_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
| ALTERNATE_PAY_SITE_ID | NUMBER | (15) | ||
| ALTERNATE_PAY_SITE | VARCHAR2 | (15) | ||
| CREATED_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATED_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| BANK_BRANCH_TYPE | VARCHAR2 | (0) | ||
| MATCH_OPTION | VARCHAR2 | (25) | ||
| FUTURE_DATED_PAYMENT_CCID | NUMBER | (15) | ||
| _LA:CREATE_DEBIT_MEMO_FLAG | CHAR | (68) | ||
| _LA:OFFSET_TAX_FLAG | CHAR | (61) | ||
| SUPPLIER_NOTIF_METHOD | VARCHAR2 | (25) | ||
| EMAIL_ADDRESS | VARCHAR2 | (2000) | ||
| REMITTANCE_EMAIL | VARCHAR2 | (0) | ||
| _LA:PRIMARY_PAY_SITE_FLAG | CHAR | (67) | ||
| _LA:PCARD_SITE_FLAG | CHAR | (61) | ||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (2) |
Cut, paste (and edit) the following text to query this object:
SELECT SUPPLIER_SITE_ID
, SUPPLIER_SITE_NAME
, SUPPLIER_ID
, SUPPLIER_NAME
, OPERATING_UNIT_ID
, OPERATING_UNIT_NAME
, ALTERNATE_SUPPLIER_SITE_NAME
, COUNTRY
, ADDRESS_LINE_1
, ADDRESS_LINE_2
, ADDRESS_LINE_3
, ADDRESS_LINE_4
, CITY
, STATE
, POSTAL_CODE
, PROVINCE
, COUNTY
, ALTERNATE_ADDRESS
, LANGUAGE
, INACTIVE_DATE
, _LA:PAY_SITE_FLAG
, _LA:PURCHASING_SITE_FLAG
, _LA:RFQ_ONLY_SITE_FLAG
, AREA_CODE
, PHONE_NUMBER
, TELEX_NUMBER
, FAX_AREA_CODE
, FAX_NUMBER
, INVOICE_TAX_NAME
, OFFSET_TAX_NAME
, TAX_CALCULATION_LEVEL
, _LA:ALLOW_TAX_CALC_OVERRIDE
, TAX_ROUNDING_RULE
, _LA:AMOUNTS_INCLUDE_TAX_FLAG
, VAT_REGISTRATION_NUMBER
, _LA:TAX_REPORTING_SITE_FLAG
, INVOICE_AMOUNT_LIMIT
, _LA:HOLD_ALL_PAYMENTS
, _LA:HOLD_FUTURE_PAYMENTS
, _LA:HOLD_UNMATCHED_INVOICES
, HOLD_REASON
, _LA:PAY_GROUP
, PAYMENT_PRIORITY
, _LA:TERMS_DATE_BASIS
, _LA:PAY_DATE_BASIS
, _LA:PAYMENT_METHOD
, _LA:ALWAYS_TAKE_DISCOUNT
, _LA:EXCL_FREIGHT_FROM_DISC
, _LA:PAY_ALONE_FLAG
, _LA:ATTENTION_AR_FLAG
, _LA:FREIGHT_TERMS
, _LA:FREE_ON_BOARD_POINT
, _LA:PAY_ON
, _LA:INVOICE_SUMMARY_LEVEL
, _LA:ALLOW_WITHHOLDING_FLAG
, EDI_ID_NUMBER
, EDI_PAYMENT_METHOD
, EDI_PAYMENT_FORMAT
, EDI_REMITTANCE_METHOD
, EDI_REMITTANCE_INSTRUCTION
, EDI_TRANSACTION_HANLDING
, _DF
, LIABILITY_ACCOUNT_ID
, _KF:ACCOUNT_NUM:LIABTY:_CO
, PREPAYMENT_ACCOUNT_ID
, _KF:ACCOUNT_NUM:PREPAY:_CO
, INVOICE_CURRENCY_CODE
, INVOICE_CURRENCY
, PAYMENT_CURRENCY_CODE
, PAYMENT_CURRENCY
, PAYMENT_TERMS_ID
, PAYMENT_TERMS_NAME
, SHIP_TO_LOCATION_ID
, SHIP_TO_LOCATION
, BILL_TO_LOCATION_ID
, BILL_TO_LOCATION
, CARRIER
, CARRIER_DESCRIPTION
, CARRIER_ORGANIZATION_ID
, CARRIER_ORGANIZATION_CODE
, ALTERNATE_PAY_SITE_ID
, ALTERNATE_PAY_SITE
, CREATED_DATE
, CREATED_BY
, LAST_UPDATED_DATE
, LAST_UPDATED_BY
, BANK_BRANCH_TYPE
, MATCH_OPTION
, FUTURE_DATED_PAYMENT_CCID
, _LA:CREATE_DEBIT_MEMO_FLAG
, _LA:OFFSET_TAX_FLAG
, SUPPLIER_NOTIF_METHOD
, EMAIL_ADDRESS
, REMITTANCE_EMAIL
, _LA:PRIMARY_PAY_SITE_FLAG
, _LA:PCARD_SITE_FLAG
, COUNTRY_OF_ORIGIN_CODE
FROM APPS.POFV_SUPPLIER_SITES;
APPS
AP_TERMS
FINANCIALS_SYSTEM_PARAMS_ALL
FND_CURRENCIES_VL
FND_GLOBAL
- show dependent code
GL_CODE_COMBINATIONS
HR_ALL_ORGANIZATION_UNITS
HR_GENERAL
- show dependent code
HR_LOCATIONS
MTL_PARAMETERS
ORG_FREIGHT
PO_VENDORS
PO_VENDOR_SITES_ALL
APPS.POFV_SUPPLIER_SITES is not referenced by any database object
|
|
|
|