VIEW: APPS.ICX_PO_VENDOR_SITES_V

Source

View Text - Preformatted

SELECT "VENDOR_SITE_ID" , "LAST_UPDATE_DATE" , "LAST_UPDATED_BY" , "VENDOR_ID" , "VENDOR_SITE_CODE" , "LAST_UPDATE_LOGIN" , "CREATION_DATE" , "CREATED_BY" , "PURCHASING_SITE_FLAG" , "RFQ_ONLY_SITE_FLAG" , "PAY_SITE_FLAG" , "ATTENTION_AR_FLAG" , "ADDRESS_LINE1" , "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" , "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" FROM PO_VENDOR_SITES

View Text - HTML Formatted

SELECT "VENDOR_SITE_ID"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "VENDOR_ID"
, "VENDOR_SITE_CODE"
, "LAST_UPDATE_LOGIN"
, "CREATION_DATE"
, "CREATED_BY"
, "PURCHASING_SITE_FLAG"
, "RFQ_ONLY_SITE_FLAG"
, "PAY_SITE_FLAG"
, "ATTENTION_AR_FLAG"
, "ADDRESS_LINE1"
, "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"
, "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"
FROM PO_VENDOR_SITES