View: MTL_RELATED_ITEMS_CUST_REF_V

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_RELATED_ITEMS_CUST_REF_V

View Text

SELECT A.ROWID ROW_ID
, A.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, A.RELATED_ITEM_ID RELATED_ITEM_ID
, A.RELATIONSHIP_TYPE_ID RELATIONSHIP_TYPE_ID
, A.ORGANIZATION_ID ORGANIZATION_ID
, A.PLN_INFO_ID PLN_INFO_ID
, A.CUSTOMER_ID CUSTOMER_ID
, PARTY.PARTY_NAME CUSTOMER_NAME
, A.SITE_USE_ID SITE_USE_ID
, MTL_RELATED_ITEMS_PKG1.SITE_TO_ADDRESS(A.SITE_USE_ID) ADDRESS
, A.START_DATE START_DATE
, A.END_DATE END_DATE
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.CREATION_DATE CREATION_DATE
, A.CREATED_BY CREATED_BY
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM MTL_RELATED_ITEMS_CUST_REF A
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE A.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID

Columns