VIEW: APPS.POFV_SUPPLIER_SITES

Source

View Text - Preformatted

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, NULL, NULL, NULL, '_LA:VS.AUTO_TAX_CALC_OVERRIDE:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', NULL, '_LA:vs.AMOUNT_INCLUDES_TAX_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', NULL, '_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', NULL, NULL, NULL, NULL, NULL, NULL, '_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, NULL, 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, NULL, '_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, NVL(FP.INVENTORY_ORGANIZATION_ID,-99)) = NVL(FP.INVENTORY_ORGANIZATION_ID,-99) AND VS.DEFAULT_PAY_SITE_ID = AV.VENDOR_SITE_ID(+) WITH READ ONLY

View Text - HTML Formatted

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
, NULL
, NULL
, NULL
, '_LA:VS.AUTO_TAX_CALC_OVERRIDE:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, NULL
, '_LA:VS.AMOUNT_INCLUDES_TAX_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, NULL
, '_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'
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, '_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
, NULL
, 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
, NULL
, '_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
, NVL(FP.INVENTORY_ORGANIZATION_ID
, -99)) = NVL(FP.INVENTORY_ORGANIZATION_ID
, -99)
AND VS.DEFAULT_PAY_SITE_ID = AV.VENDOR_SITE_ID(+) WITH READ ONLY