View: MTL_INTERCOMPANY_PARAMETERS_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_INTERCOMPANY_PARAMETERS_V

View Text

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
, PARTY.PARTY_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

Columns