eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: EDWBV_TPRT_P1_TPARTNER_LCV

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT VND.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER'
, DECODE(ELE.HIERARCHY_LEVEL
, 3
, ELE.PARENT_VENDOR_ID ||'-'|| INST.INSTANCE_CODE ||'-'|| 'SUPPLIER'
, VND.VENDOR_ID ||'-'|| INST.INSTANCE_CODE ||'-'|| 'SUPPLIER')
, VND.LAST_UPDATE_DATE
, VND.CREATION_DATE
, VND.VENDOR_NAME
, VND.VENDOR_NAME
, VND.VENDOR_NAME_ALT
, VND.START_DATE_ACTIVE
, VND.END_DATE_ACTIVE
, VND.STANDARD_INDUSTRY_CLASS
, VND.VAT_REGISTRATION_NUM
, VND.NUM_1099
, VND.TERMS_ID
, VND.SEGMENT1
, VND.VENDOR_TYPE_LOOKUP_CODE
, VND.ONE_TIME_FLAG
, VND.MINORITY_GROUP_LOOKUP_CODE
, VND.WOMEN_OWNED_FLAG
, VND.SMALL_BUSINESS_FLAG
, VND.HOLD_FLAG
, VND.INSPECTION_REQUIRED_FLAG
, VND.RECEIPT_REQUIRED_FLAG
, VND.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, VND.ALLOW_UNORDERED_RECEIPTS_FLAG
, INST.INSTANCE_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, VND.VENDOR_ID
, TO_CHAR(NULL)
FROM EDW_LOCAL_INSTANCE INST
, EDW_PO_VENDOR_HIERARCHIES_V ELE
, PO_VENDORS VND
WHERE ELE.HIERARCHY_LEVEL IN (1
, 2
, 3)
AND ELE.VENDOR_ID = VND.VENDOR_ID UNION ALL /* PUSH DOWN VENDORS WITH NO PARENT */ SELECT VND.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER'
, VND.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER'
, VND.LAST_UPDATE_DATE
, VND.CREATION_DATE
, VND.VENDOR_NAME
, VND.VENDOR_NAME
, VND.VENDOR_NAME_ALT
, VND.START_DATE_ACTIVE
, VND.END_DATE_ACTIVE
, VND.STANDARD_INDUSTRY_CLASS
, VND.VAT_REGISTRATION_NUM
, VND.NUM_1099
, VND.TERMS_ID
, VND.SEGMENT1
, VND.VENDOR_TYPE_LOOKUP_CODE
, VND.ONE_TIME_FLAG
, VND.MINORITY_GROUP_LOOKUP_CODE
, VND.WOMEN_OWNED_FLAG
, VND.SMALL_BUSINESS_FLAG
, VND.HOLD_FLAG
, VND.INSPECTION_REQUIRED_FLAG
, VND.RECEIPT_REQUIRED_FLAG
, VND.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, VND.ALLOW_UNORDERED_RECEIPTS_FLAG
, INST.INSTANCE_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, VND.VENDOR_ID
, TO_CHAR(NULL)
FROM EDW_LOCAL_INSTANCE INST
, PO_VENDORS VND
WHERE VND.PARENT_VENDOR_ID IS NULL

Columns

Name
TPARTNER_PK
PARENT_TPARTNER_FK
LAST_UPDATE_DATE
CREATION_DATE
TPARTNER_DP
NAME
ALTERNATE_NAME
START_ACTIVE_DATE
END_ACTIVE_DATE
SIC_CODE
TAX_REG_NUM
TAXPAYER_ID
PAYMENT_TERMS
VENDOR_NUMBER
VENDOR_TYPE
ONE_TIME_FLAG
MINORITY_GROUP
WOMEN_OWNED
SMALL_BUSINESS
HOLD_FLAG
INSPECT_REQUIRED
RECEIPT_REQUIRED
ALLOW_SUB_RECEIPT
ALLOW_UNORDER_RCV
INSTANCE
USER_ATTRIBUTE1
USER_ATTRIBUTE2
USER_ATTRIBUTE3
USER_ATTRIBUTE4
USER_ATTRIBUTE5
VENDOR_ID
OPERATION_CODE