View: POFV_SUPPLIER_SITES

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.POFV_SUPPLIER_SITES

View Text

SELECT VS.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, VS.VENDOR_ID
, VE.VENDOR_NAME
, VS.ORG_ID
, OP.NAME
, VS.VENDOR_SITE_CODE_ALT
, VS.COUNTRY
, VS.ADDRESS_LINE1
, VS.ADDRESS_LINE2
, VS.ADDRESS_LINE3
, VS.ADDRESS_LINE4
, VS.CITY
, VS.STATE
, VS.ZIP
, VS.PROVINCE
, VS.COUNTY
, VS.ADDRESS_LINES_ALT
, VS.LANGUAGE
, VS.INACTIVE_DATE
, '_LA:VS.PAY_SITE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.PURCHASING_SITE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.RFQ_ONLY_SITE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.AREA_CODE
, VS.PHONE
, VS.TELEX
, VS.FAX_AREA_CODE
, VS.FAX
, VS.VAT_CODE
, VS.OFFSET_VAT_CODE
, VS.AUTO_TAX_CALC_FLAG
, '_LA:VS.AUTO_TAX_CALC_OVERRIDE:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.AP_TAX_ROUNDING_RULE
, '_LA:VS.AMOUNT_INCLUDES_TAX_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.VAT_REGISTRATION_NUM
, '_LA:VS.TAX_REPORTING_SITE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.INVOICE_AMOUNT_LIMIT
, '_LA:VS.HOLD_ALL_PAYMENTS_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.HOLD_FUTURE_PAYMENTS_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.HOLD_UNMATCHED_INVOICES_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.HOLD_REASON
, '_LA:VS.PAY_GROUP_LOOKUP_CODE:PO_LOOKUP_CODES:PAY GROUP:DISPLAYED_FIELD'
, VS.PAYMENT_PRIORITY
, '_LA:VS.TERMS_DATE_BASIS:AP_LOOKUP_CODES:TERMS DATE BASIS:DISPLAYED_FIELD'
, '_LA:VS.PAY_DATE_BASIS_LOOKUP_CODE:PO_LOOKUP_CODES:PAY DATE BASIS:DISPLAYED_FIELD'
, '_LA:VS.PAYMENT_METHOD_LOOKUP_CODE:AP_LOOKUP_CODES:PAYMENT METHOD:DISPLAYED_FIELD'
, '_LA:VS.ALWAYS_TAKE_DISC_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.EXCLUDE_FREIGHT_FROM_DISCOUNT:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.EXCLUSIVE_PAYMENT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.ATTENTION_AR_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.FREIGHT_TERMS_LOOKUP_CODE:PO_LOOKUP_CODES:FREIGHT TERMS:DISPLAYED_FIELD'
, '_LA:VS.FOB_LOOKUP_CODE:AR_LOOKUPS:FOB:MEANING'
, '_LA:VS.PAY_ON_CODE:PO_LOOKUP_CODES:ERS PAY_ON_CODE:DISPLAYED_FIELD'
, '_LA:VS.PAY_ON_RECEIPT_SUMMARY_CODE:PO_LOOKUP_CODES:ERS INVOICE_SUMMARY:DISPLAYED_FIELD'
, '_LA:VS.ALLOW_AWT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.EDI_ID_NUMBER
, VS.EDI_PAYMENT_METHOD
, VS.EDI_PAYMENT_FORMAT
, VS.EDI_REMITTANCE_METHOD
, VS.EDI_REMITTANCE_INSTRUCTION
, VS.EDI_TRANSACTION_HANDLING
, '_DF:PO:PO_VENDOR_SITES:VS'
, VS.ACCTS_PAY_CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:LA'
, VS.PREPAY_CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:PA'
, VS.INVOICE_CURRENCY_CODE
, IC.NAME
, VS.PAYMENT_CURRENCY_CODE
, PC.NAME
, VS.TERMS_ID
, PT.NAME
, VS.SHIP_TO_LOCATION_ID
, SL.LOCATION_CODE
, VS.BILL_TO_LOCATION_ID
, BL.LOCATION_CODE
, VS.SHIP_VIA_LOOKUP_CODE
, FR.DESCRIPTION
, FR.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, VS.DEFAULT_PAY_SITE_ID
, AV.VENDOR_SITE_CODE
, VS.CREATION_DATE
, VS.CREATED_BY
, VS.LAST_UPDATE_DATE
, VS.LAST_UPDATED_BY
, VS.BANK_BRANCH_TYPE
, VS.MATCH_OPTION
, VS.FUTURE_DATED_PAYMENT_CCID
, '_LA:VS.CREATE_DEBIT_MEMO_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.OFFSET_TAX_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.SUPPLIER_NOTIF_METHOD
, VS.EMAIL_ADDRESS
, VS.REMITTANCE_EMAIL
, '_LA:VS.PRIMARY_PAY_SITE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VS.PCARD_SITE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VS.COUNTRY_OF_ORIGIN_CODE
FROM PO_VENDOR_SITES_ALL VS
, PO_VENDORS VE
, HR_ALL_ORGANIZATION_UNITS OP
, GL_CODE_COMBINATIONS LA
, GL_CODE_COMBINATIONS PA
, FND_CURRENCIES_VL IC
, FND_CURRENCIES_VL PC
, AP_TERMS PT
, HR_LOCATIONS SL
, HR_LOCATIONS BL
, ORG_FREIGHT FR
, FINANCIALS_SYSTEM_PARAMS_ALL FP
, MTL_PARAMETERS MP
, PO_VENDOR_SITES_ALL AV
WHERE VS.VENDOR_ID = VE.VENDOR_ID
AND VS.ORG_ID = OP.ORGANIZATION_ID
AND VS.ORG_ID = FP.ORG_ID
AND FP.INVENTORY_ORGANIZATION_ID = MP.ORGANIZATION_ID
AND VS.ACCTS_PAY_CODE_COMBINATION_ID = LA.CODE_COMBINATION_ID(+)
AND VS.PREPAY_CODE_COMBINATION_ID = PA.CODE_COMBINATION_ID(+)
AND VS.INVOICE_CURRENCY_CODE = IC.CURRENCY_CODE(+)
AND VS.PAYMENT_CURRENCY_CODE = PC.CURRENCY_CODE(+)
AND VS.TERMS_ID = PT.TERM_ID(+)
AND VS.SHIP_TO_LOCATION_ID = SL.LOCATION_ID(+)
AND VS.BILL_TO_LOCATION_ID = BL.LOCATION_ID(+)
AND VS.SHIP_VIA_LOOKUP_CODE = FR.FREIGHT_CODE(+)
AND NVL(FR.ORGANIZATION_ID
, FP.INVENTORY_ORGANIZATION_ID) = FP.INVENTORY_ORGANIZATION_ID
AND VS.DEFAULT_PAY_SITE_ID = AV.VENDOR_SITE_ID(+)
AND '_SEC:VS.ORG_ID' IS NOT NULL WITH READ ONLY

Columns