[Home] [Help]
View: AXFV_TRADING_PARTNER_SITES
Product: | AX - Global Accounting Engine |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SUB.APPLICATION_ID
, TP.THIRD_PARTY_ID
, SUB.SUB_ID
, SUB.SUB_NAME
, TP.THIRD_PARTY_NAME
, APP.APPLICATION_NAME
FROM AX_SUBS_V SUB
, FND_APPLICATION_VL APP
, AX_THIRD_PARTIES_V TP
WHERE SUB.APPLICATION_ID = APP.APPLICATION_ID
AND SUB.THIRD_PARTY_ID = TP.THIRD_PARTY_ID
AND SUB.APPLICATION_ID = TP.APPLICATION_ID WITH READ ONLY
Columns
Name |
APPLICATION_ID |
TRADING_PARTNER_ID |
TRADING_PARTNER_SITE_ID |
TRADING_PARTNER_SITE_NAME |
TRADING_PARTNER_NAME |
APPLICATION_NAME |