VIEW: APPS.MTL_RELATED_ITEMS_CUST_REF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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