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_TPARTNER_LOC_LCV

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

View Text

SELECT VNS.VENDOR_SITE_ID || '-' || ORG_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER_SITE'
, VND.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER'
, VNS.ADDRESS_LINE1
, VNS.ADDRESS_LINE2
, VNS.ADDRESS_LINE3
, NULL
, VNS.CITY
, VNS.COUNTY
, VNS.STATE
, VNS.ZIP
, VNS.PROVINCE
, VNS.COUNTRY
, 'VENDOR SITE'
, VNS.VENDOR_SITE_CODE || '(' || VND.VENDOR_NAME || ')'
, VNS.VENDOR_SITE_CODE || '(' || VND.VENDOR_NAME || ')'
, TO_DATE(NULL)
, VNS.INACTIVE_DATE
, VNS.PURCHASING_SITE_FLAG
, VNS.RFQ_ONLY_SITE_FLAG
, VNS.PAY_SITE_FLAG
, APT.NAME
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, INST.INSTANCE_CODE
, VNS.VENDOR_SITE_ID
, GREATEST(VNS.LAST_UPDATE_DATE
, VND.LAST_UPDATE_DATE)
, VNS.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'LOCATION'
, '_DF:PO:PO_VENDOR_SITES:VNS'
, '_DF:_DUMMY:AR:RA_ADDRESSES_HZ:HCAS'
, '_DF:_DUMMY:AR:RA_SITE_USES_HZ:HCSS'
FROM EDW_LOCAL_INSTANCE INST
, (SELECT TERM_ID
, NAME
FROM AP_TERMS_TL
WHERE LANGUAGE = USERENV('LANG')) APT
, PO_VENDORS VND
, PO_VENDOR_SITES_ALL VNS
WHERE VNS.VENDOR_ID = VND.VENDOR_ID
AND VNS.TERMS_ID = APT.TERM_ID (+) UNION ALL SELECT HCSS.SITE_USE_ID || '-' || INST.INSTANCE_CODE || '-' || 'CUST_SITE_USE'
, HZCA.CUST_ACCOUNT_ID || '-' || INST.INSTANCE_CODE || '-' || 'CUST_ACCT'
, PARTIES.ADDRESS1
, PARTIES.ADDRESS2
, PARTIES.ADDRESS3
, PARTIES.ADDRESS4
, PARTIES.CITY
, PARTIES.COUNTY
, PARTIES.STATE
, PARTIES.POSTAL_CODE
, PARTIES.PROVINCE
, PARTIES.COUNTRY
, 'CUSTOMER SITE USE'
, HCSS.SITE_USE_CODE || ' (' || HCSS.LOCATION || '
, ' || SUBSTRB(PARTIES.PARTY_NAME
, 1
, 150) || ')'
, HCSS.SITE_USE_CODE || ' (' || HCSS.LOCATION || '
, ' || SUBSTRB(PARTIES.PARTY_NAME
, 1
, 150) || ')'
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, NULL
, HCSS.SITE_USE_CODE
, HCSS.LOCATION
, HCSS.PRIMARY_FLAG
, HCSS.STATUS
, HCSS.ORIG_SYSTEM_REFERENCE
, HCSS.SIC_CODE
, APT.NAME
, HCSS.GSA_INDICATOR
, HCSS.SHIP_PARTIAL
, HCSS.SHIP_VIA
, HCSS.FOB_POINT
, OT.NAME
, SUBSTRB(PL.NAME
, 1
, 40)
, HCSS.FREIGHT_TERM
, TR.NAME
, HCSS.TAX_REFERENCE
, HCSS.SORT_PRIORITY
, HCSS.TAX_CODE
, HCSS.DEMAND_CLASS_CODE
, NULL
, HCSS.TAX_HEADER_LEVEL_FLAG
, HCSS.TAX_ROUNDING_RULE
, SUBSTRB(RS.NAME
, 1
, 120)
, INST.INSTANCE_CODE
, TO_NUMBER(NULL)
, GREATEST(HCSS.LAST_UPDATE_DATE
, HZCA.LAST_UPDATE_DATE
, HCAS.LAST_UPDATE_DATE
, PARTIES.LAST_UPDATE_DATE)
, HCSS.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'LOCATION'
, '_DF:_DUMMY:PO:PO_VENDOR_SITES:VNS'
, '_DF:AR:RA_ADDRESSES_HZ:HCAS'
, '_DF:AR:RA_SITE_USES_HZ:HCSS'
FROM EDW_LOCAL_INSTANCE INST
, (SELECT TERM_ID
, NAME
FROM AP_TERMS_TL
WHERE LANGUAGE = USERENV('LANG')) APT
, RA_SALESREPS_ALL RS
, RA_TERRITORIES TR
, (SELECT TRANSACTION_TYPE_ID
, NAME
FROM OE_TRANSACTION_TYPES_TL
WHERE LANGUAGE = USERENV('LANG')) OT
, (SELECT PRICE_LIST_ID
, NAME
FROM SO_PRICE_LISTS_TL
WHERE LANGUAGE = USERENV('LANG')) PL
, HZ_PARTIES PARTIES
, HZ_CUST_ACCOUNTS HZCA
, HZ_CUST_ACCT_SITES_ALL HCAS
, HZ_CUST_SITE_USES_ALL HCSS
WHERE HCSS.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
AND HCAS.CUST_ACCOUNT_ID = HZCA.CUST_ACCOUNT_ID
AND HZCA.PARTY_ID = PARTIES.PARTY_ID
AND HCSS.PRIMARY_SALESREP_ID = RS.SALESREP_ID (+)
AND HCSS.ORG_ID = RS.ORG_ID (+)
AND HCSS.TERRITORY_ID = TR.TERRITORY_ID (+)
AND HCSS.PAYMENT_TERM_ID = APT.TERM_ID (+)
AND HCSS.PRICE_LIST_ID = PL.PRICE_LIST_ID (+)
AND HZCA.ORDER_TYPE_ID = OT.TRANSACTION_TYPE_ID (+) UNION ALL SELECT VND.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER' || '-' || 'TPRT'
, VND.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER'
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'VENDOR SITE'
, VND.VENDOR_NAME
, VND.VENDOR_NAME
, VND.START_DATE_ACTIVE
, VND.END_DATE_ACTIVE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, INST.INSTANCE_CODE
, TO_NUMBER(NULL)
, VND.LAST_UPDATE_DATE
, VND.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'TRADE PARTNER'
, '_DF:_DUMMY:PO:PO_VENDOR_SITES:VNS'
, '_DF:_DUMMY:AR:RA_ADDRESSES_HZ:HCAS'
, '_DF:_DUMMY:AR:RA_SITE_USES_HZ:HCSS'
FROM EDW_LOCAL_INSTANCE INST
, PO_VENDORS VND UNION ALL SELECT HZCA.CUST_ACCOUNT_ID || '-' || INST.INSTANCE_CODE || '-' || 'CUST_ACCT' || '-' || 'TPRT'
, HZCA.CUST_ACCOUNT_ID || '-' || INST.INSTANCE_CODE || '-' || 'CUST_ACCT'
, PARTIES.ADDRESS1
, PARTIES.ADDRESS2
, PARTIES.ADDRESS3
, PARTIES.ADDRESS4
, PARTIES.CITY
, PARTIES.COUNTY
, PARTIES.STATE
, PARTIES.POSTAL_CODE
, PARTIES.PROVINCE
, PARTIES.COUNTRY
, 'CUSTOMER ACCOUNT'
, SUBSTRB(PARTIES.PARTY_NAME
, 1
, 80) || '(' || HZCA.ACCOUNT_NUMBER || ')'
, SUBSTRB(PARTIES.PARTY_NAME
, 1
, 80) || '(' || HZCA.ACCOUNT_NUMBER || ')'
, HZCA.ACCOUNT_ACTIVATION_DATE
, HZCA.ACCOUNT_TERMINATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PARTIES.GSA_INDICATOR_FLAG
, HZCA.SHIP_PARTIAL
, HZCA.SHIP_VIA
, HZCA.FOB_POINT
, NULL
, NULL
, HZCA.FREIGHT_TERM
, NULL
, NULL
, TO_NUMBER(NULL)
, HZCA.TAX_CODE
, NULL
, NULL
, HZCA.TAX_HEADER_LEVEL_FLAG
, HZCA.TAX_ROUNDING_RULE
, NULL
, INST.INSTANCE_CODE
, HZCA.CUST_ACCOUNT_ID
, GREATEST(PARTIES.LAST_UPDATE_DATE
, HZCA.LAST_UPDATE_DATE)
, HZCA.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'TRADE PARTNER'
, '_DF:_DUMMY:PO:PO_VENDOR_SITES:VNS'
, '_DF:_DUMMY:AR:RA_ADDRESSES_HZ:HCAS'
, '_DF:_DUMMY:AR:RA_SITE_USES_HZ:HCSS'
FROM EDW_LOCAL_INSTANCE INST
, HZ_CUST_ACCOUNTS HZCA
, HZ_PARTIES PARTIES
WHERE HZCA.PARTY_ID = PARTIES.PARTY_ID UNION ALL SELECT PARTIES.PARTY_ID || '-' || INST.INSTANCE_CODE || '-' || 'PARTY' || '-' || 'TPRT'
, PARTIES.PARTY_ID || '-' || INST.INSTANCE_CODE || '-' || 'PARTY'
, PARTIES.ADDRESS1
, PARTIES.ADDRESS2
, PARTIES.ADDRESS3
, PARTIES.ADDRESS4
, PARTIES.CITY
, PARTIES.COUNTY
, PARTIES.STATE
, PARTIES.POSTAL_CODE
, PARTIES.PROVINCE
, PARTIES.COUNTRY
, 'PARTY'
, SUBSTRB(PARTIES.PARTY_NAME
, 1
, 320)
, SUBSTRB(PARTIES.PARTY_NAME
, 1
, 320)
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_CHAR(NULL)
, PARTIES.GSA_INDICATOR_FLAG
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, INST.INSTANCE_CODE
, TO_NUMBER(NULL)
, PARTIES.LAST_UPDATE_DATE
, PARTIES.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'TRADE PARTNER'
, '_DF:_DUMMY:PO:PO_VENDOR_SITES:VNS'
, '_DF:_DUMMY:AR:RA_ADDRESSES_HZ:HCAS'
, '_DF:_DUMMY:AR:RA_SITE_USES_HZ:HCSS'
FROM EDW_LOCAL_INSTANCE INST
, HZ_PARTIES PARTIES

Columns

Name
TPARTNER_LOC_PK
TRADE_PARTNER_FK
ADDRESS_LINE1
ADDRESS_LINE2
ADDRESS_LINE3
ADDRESS_LINE4
CITY
COUNTY
STATE
POSTAL_CODE
PROVINCE
COUNTRY
BUSINESS_TYPE
TPARTNER_LOC_DP
NAME
DATE_FROM
DATE_TO
VNDR_PURCH_SITE
VNDR_RFQ_ONLY
VNDR_PAY_SITE
VNDR_PAY_TERMS
CUST_SITE_USE
CUST_LOCATION
CUST_PRIMARY_FLAG
CUST_STATUS
CUST_ORIG_SYS_REF
CUST_SIC_CODE
CUST_PAY_TERMS
CUST_GSA_IND
CUST_SHIP_PARTIAL
CUST_SHIP_VIA
CUST_FOB_POINT
CUST_ORDER_TYPE
CUST_PRICE_LIST
CUST_FREIGHT
CUST_TERRITORY
CUST_TAX_REF
CUST_SORT_PRTY
CUST_TAX_CODE
CUST_DEMAND_CLASS
CUST_TAX_CLASSFN
CUST_TAX_HDR_FLAG
CUST_TAX_ROUND
CUST_SALES_REP
INSTANCE
TPARTNER_LOC_ID
LAST_UPDATE_DATE
CREATION_DATE
USER_ATTRIBUTE1
USER_ATTRIBUTE2
USER_ATTRIBUTE3
USER_ATTRIBUTE4
USER_ATTRIBUTE5
OPERATION_CODE
LEVEL_NAME
"_DF:VNDR_SITE:_EDW"
"_DF:ACCT_SITE:_EDW"
"_DF:SITE_USES:_EDW"