VIEW: APPS.MTL_INTERCOMPANY_PARAMETERS_V

Source

View Text - Preformatted

SELECT DISTINCT MIP.ROWID ROW_ID , MIP.SHIP_ORGANIZATION_ID , MIP.SELL_ORGANIZATION_ID , HOU1.NAME SHIP_ORGANIZATION_NAME , HOU2.NAME SELL_ORGANIZATION_NAME , MIP.FLOW_TYPE , MIP.LAST_UPDATE_DATE , MIP.LAST_UPDATED_BY , MIP.CREATION_DATE , MIP.CREATED_BY , MIP.LAST_UPDATE_LOGIN , MIP.VENDOR_ID , PV.VENDOR_NAME SUPPLIER_NAME , MIP.VENDOR_SITE_ID , PVS.VENDOR_SITE_CODE VENDOR_SITE , MIP.CUSTOMER_ID , RC.CUSTOMER_NUMBER CUSTOMER_NUMBER , RC.CUSTOMER_NAME CUSTOMER_NAME , MIP.ADDRESS_ID , MIP.CUSTOMER_SITE_ID , RSUA.LOCATION , MIP.CUST_TRX_TYPE_ID , RCTTA.NAME TRANSACTION_NAME , MIP.ATTRIBUTE_CATEGORY , MIP.ATTRIBUTE1 , MIP.ATTRIBUTE2 , MIP.ATTRIBUTE3 , MIP.ATTRIBUTE4 , MIP.ATTRIBUTE5 , MIP.ATTRIBUTE6 , MIP.ATTRIBUTE7 , MIP.ATTRIBUTE8 , MIP.ATTRIBUTE9 , MIP.ATTRIBUTE10 , MIP.ATTRIBUTE11 , MIP.ATTRIBUTE12 , MIP.ATTRIBUTE13 , MIP.ATTRIBUTE14 , MIP.ATTRIBUTE15 , MIP.REVALUE_AVERAGE_FLAG , MIP.FREIGHT_CODE_COMBINATION_ID , MIP.INVENTORY_ACCRUAL_ACCOUNT_ID , MIP.EXPENSE_ACCRUAL_ACCOUNT_ID , MIP.INTERCOMPANY_COGS_ACCOUNT_ID , MIP.INV_CURRENCY_CODE FROM HR_ORGANIZATION_UNITS HOU1 , HR_ORGANIZATION_UNITS HOU2 , MTL_INTERCOMPANY_PARAMETERS MIP , PO_VENDORS PV , PO_VENDOR_SITES_ALL PVS , (SELECT cust_account_id customer_id , party.party_name customer_name , cust_acct.account_number customer_number FROM hz_parties party, hz_cust_accounts cust_acct WHERE cust_acct.party_id = party.party_id) RC , RA_CUST_TRX_TYPES_ALL RCTTA , HZ_CUST_SITE_USES_ALL RSUA WHERE HOU1.ORGANIZATION_ID = MIP.SHIP_ORGANIZATION_ID AND HOU2.ORGANIZATION_ID = MIP.SELL_ORGANIZATION_ID AND PV.VENDOR_ID(+) = MIP.VENDOR_ID AND PVS.VENDOR_SITE_ID(+) = MIP.VENDOR_SITE_ID AND PVS.ORG_ID(+) = MIP.SELL_ORGANIZATION_ID AND RC.CUSTOMER_ID = MIP.CUSTOMER_ID AND RSUA.CUST_ACCT_SITE_ID = MIP.ADDRESS_ID AND RSUA.SITE_USE_ID = MIP.CUSTOMER_SITE_ID AND RCTTA.CUST_TRX_TYPE_ID = MIP.CUST_TRX_TYPE_ID AND RCTTA.ORG_ID = MIP.SHIP_ORGANIZATION_ID

View Text - HTML Formatted

SELECT DISTINCT MIP.ROWID ROW_ID
, MIP.SHIP_ORGANIZATION_ID
, MIP.SELL_ORGANIZATION_ID
, HOU1.NAME SHIP_ORGANIZATION_NAME
, HOU2.NAME SELL_ORGANIZATION_NAME
, MIP.FLOW_TYPE
, MIP.LAST_UPDATE_DATE
, MIP.LAST_UPDATED_BY
, MIP.CREATION_DATE
, MIP.CREATED_BY
, MIP.LAST_UPDATE_LOGIN
, MIP.VENDOR_ID
, PV.VENDOR_NAME SUPPLIER_NAME
, MIP.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE VENDOR_SITE
, MIP.CUSTOMER_ID
, RC.CUSTOMER_NUMBER CUSTOMER_NUMBER
, RC.CUSTOMER_NAME CUSTOMER_NAME
, MIP.ADDRESS_ID
, MIP.CUSTOMER_SITE_ID
, RSUA.LOCATION
, MIP.CUST_TRX_TYPE_ID
, RCTTA.NAME TRANSACTION_NAME
, MIP.ATTRIBUTE_CATEGORY
, MIP.ATTRIBUTE1
, MIP.ATTRIBUTE2
, MIP.ATTRIBUTE3
, MIP.ATTRIBUTE4
, MIP.ATTRIBUTE5
, MIP.ATTRIBUTE6
, MIP.ATTRIBUTE7
, MIP.ATTRIBUTE8
, MIP.ATTRIBUTE9
, MIP.ATTRIBUTE10
, MIP.ATTRIBUTE11
, MIP.ATTRIBUTE12
, MIP.ATTRIBUTE13
, MIP.ATTRIBUTE14
, MIP.ATTRIBUTE15
, MIP.REVALUE_AVERAGE_FLAG
, MIP.FREIGHT_CODE_COMBINATION_ID
, MIP.INVENTORY_ACCRUAL_ACCOUNT_ID
, MIP.EXPENSE_ACCRUAL_ACCOUNT_ID
, MIP.INTERCOMPANY_COGS_ACCOUNT_ID
, MIP.INV_CURRENCY_CODE
FROM HR_ORGANIZATION_UNITS HOU1
, HR_ORGANIZATION_UNITS HOU2
, MTL_INTERCOMPANY_PARAMETERS MIP
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, (SELECT CUST_ACCOUNT_ID CUSTOMER_ID
, PARTY.PARTY_NAME CUSTOMER_NAME
, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID) RC
, RA_CUST_TRX_TYPES_ALL RCTTA
, HZ_CUST_SITE_USES_ALL RSUA
WHERE HOU1.ORGANIZATION_ID = MIP.SHIP_ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID = MIP.SELL_ORGANIZATION_ID
AND PV.VENDOR_ID(+) = MIP.VENDOR_ID
AND PVS.VENDOR_SITE_ID(+) = MIP.VENDOR_SITE_ID
AND PVS.ORG_ID(+) = MIP.SELL_ORGANIZATION_ID
AND RC.CUSTOMER_ID = MIP.CUSTOMER_ID
AND RSUA.CUST_ACCT_SITE_ID = MIP.ADDRESS_ID
AND RSUA.SITE_USE_ID = MIP.CUSTOMER_SITE_ID
AND RCTTA.CUST_TRX_TYPE_ID = MIP.CUST_TRX_TYPE_ID
AND RCTTA.ORG_ID = MIP.SHIP_ORGANIZATION_ID