View: POFV_SUPPLIERS

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

View Text

SELECT VE.VENDOR_ID
, VE.VENDOR_NAME
, VE.VENDOR_NAME_ALT
, VE.SEGMENT1
, VE.START_DATE_ACTIVE
, VE.END_DATE_ACTIVE
, VE.VAT_REGISTRATION_NUM
, VE.NUM_1099
, '_LA:VE.VENDOR_TYPE_LOOKUP_CODE:PO_LOOKUP_CODES:VENDOR TYPE:DISPLAYED_FIELD'
, VE.STANDARD_INDUSTRY_CLASS
, '_LA:VE.ONE_TIME_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VE.MINORITY_GROUP_LOOKUP_CODE:PO_LOOKUP_CODES:MINORITY GROUP:DISPLAYED_FIELD'
, '_LA:VE.SMALL_BUSINESS_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VE.WOMEN_OWNED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VE.CUSTOMER_NUM
, VE.AUTO_TAX_CALC_FLAG
, '_LA:VE.AUTO_TAX_CALC_OVERRIDE:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VE.AP_TAX_ROUNDING_RULE
, '_LA:VE.AMOUNT_INCLUDES_TAX_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VE.FEDERAL_REPORTABLE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VE.TYPE_1099
, '_LA:VE.STATE_REPORTABLE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VE.TAX_REPORTING_NAME
, VE.NAME_CONTROL
, VE.TAX_VERIFICATION_DATE
, VE.VALIDATION_NUMBER
, '_LA:VE.ORGANIZATION_TYPE_LOOKUP_CODE:PO_LOOKUP_CODES:ORGANIZATION TYPE:DISPLAYED_FIELD'
, VE.INVOICE_AMOUNT_LIMIT
, '_LA:VE.HOLD_ALL_PAYMENTS_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VE.HOLD_FUTURE_PAYMENTS_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VE.HOLD_UNMATCHED_INVOICES_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, VE.HOLD_REASON
, '_LA:VE.PAY_GROUP_LOOKUP_CODE:PO_LOOKUP_CODES:PAY GROUP:DISPLAYED_FIELD'
, VE.PAYMENT_PRIORITY
, '_LA:VE.TERMS_DATE_BASIS:AP_LOOKUP_CODES:TERMS DATE BASIS:DISPLAYED_FIELD'
, '_LA:VE.PAY_DATE_BASIS_LOOKUP_CODE:PO_LOOKUP_CODES:PAY DATE BASIS:DISPLAYED_FIELD'
, '_LA:VE.PAYMENT_METHOD_LOOKUP_CODE:AP_LOOKUP_CODES:PAYMENT METHOD:DISPLAYED_FIELD'
, '_LA:VE.ALWAYS_TAKE_DISC_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VE.EXCLUDE_FREIGHT_FROM_DISCOUNT:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VE.AUTO_CALCULATE_INTEREST_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VE.EXCLUSIVE_PAYMENT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VE.FREIGHT_TERMS_LOOKUP_CODE:PO_LOOKUP_CODES:FREIGHT TERMS:DISPLAYED_FIELD'
, '_LA:VE.FOB_LOOKUP_CODE:AR_LOOKUPS:FOB:MEANING'
, VE.HOLD_DATE
, VE.PURCHASING_HOLD_REASON
, '_LA:VE.ENFORCE_SHIP_TO_LOCATION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DISPLAYED_FIELD'
, '_LA:DECODE( NVL(VE.RECEIPT_REQUIRED_FLAG
, ''N'') || NVL(VE.INSPECTION_REQUIRED_FLAG
, ''N'')
, ''NN''
, ''2-WAY''
, ''YN''
, ''3-WAY''
, ''YY''
, ''4-WAY''
, NULL):PO_LOOKUP_CODES:MATCHING TYPE:DISPLAYED_FIELD'
, VE.QTY_RCV_TOLERANCE
, '_LA:VE.QTY_RCV_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DISPLAYED_FIELD'
, VE.DAYS_EARLY_RECEIPT_ALLOWED
, VE.DAYS_LATE_RECEIPT_ALLOWED
, '_LA:VE.ALLOW_SUBSTITUTE_RECEIPTS_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VE.ALLOW_UNORDERED_RECEIPTS_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VE.RECEIPT_DAYS_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DISPLAYED_FIELD'
, '_LA:VE.ALLOW_AWT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VE.WITHHOLDING_STATUS_LOOKUP_CODE:PO_LOOKUP_CODES:WITHHOLDING STATUS:DISPLAYED_FIELD'
, VE.WITHHOLDING_START_DATE
, VE.EDI_PAYMENT_METHOD
, VE.EDI_PAYMENT_FORMAT
, VE.EDI_REMITTANCE_METHOD
, VE.EDI_REMITTANCE_INSTRUCTION
, VE.EDI_TRANSACTION_HANDLING
, '_DF:PO:PO_VENDORS:VE'
, VE.EMPLOYEE_ID
, SE.EMPLOYEE_NUMBER
, SE.FULL_NAME
, VE.PARENT_VENDOR_ID
, PV.VENDOR_NAME
, VE.INVOICE_CURRENCY_CODE
, IC.NAME
, VE.PAYMENT_CURRENCY_CODE
, PC.NAME
, VE.HOLD_BY
, HB.EMPLOYEE_NUMBER
, HB.FULL_NAME
, VE.TERMS_ID
, PT.NAME
, VE.RECEIVING_ROUTING_ID
, RU.ROUTING_NAME
, VE.CREATION_DATE
, VE.CREATED_BY
, VE.LAST_UPDATE_DATE
, VE.LAST_UPDATED_BY
, VE.BANK_CHARGE_BEARER
, VE.BANK_BRANCH_TYPE
, VE.MATCH_OPTION
, VE.FUTURE_DATED_PAYMENT_CCID
, '_LA:VE.CREATE_DEBIT_MEMO_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:VE.OFFSET_TAX_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
FROM PO_VENDORS VE
, PER_PEOPLE_F SE
, PO_VENDORS PV
, FND_CURRENCIES_VL IC
, FND_CURRENCIES_VL PC
, PER_PEOPLE_F HB
, AP_TERMS PT
, RCV_ROUTING_HEADERS RU
WHERE VE.EMPLOYEE_ID = SE.PERSON_ID(+)
AND SE.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND SE.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND VE.PARENT_VENDOR_ID = PV.VENDOR_ID(+)
AND VE.INVOICE_CURRENCY_CODE = IC.CURRENCY_CODE(+)
AND VE.PAYMENT_CURRENCY_CODE = PC.CURRENCY_CODE(+)
AND VE.HOLD_BY = HB.PERSON_ID(+)
AND HB.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND HB.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND VE.TERMS_ID = PT.TERM_ID(+)
AND VE.RECEIVING_ROUTING_ID = RU.ROUTING_HEADER_ID(+) WITH READ ONLY

Columns