View: OEFV_LINE_END_CUSTOMER

Product:	ONT - Order Management
Description:	Full BIS Business View for End Customer Information
Implementation/DBA Data:	APPS.OEFV_LINE_END_CUSTOMER

View Text

SELECT L.ROWID
, L.LINE_ID
, L.HEADER_ID
, L.END_CUSTOMER_ID
, L.END_CUSTOMER_CONTACT_ID
, L.END_CUSTOMER_SITE_USE_ID
, END_PARTY.PARTY_NAME END_CUSTOMER_NAME
, END_PARTY.PARTY_NUMBER END_CUSTOMER_NUMBER
, ENDCONT2.PERSON_LAST_NAME || DECODE(ENDCONT2.PERSON_FIRST_NAME
, NULL
, NULL
, '
, '|| ENDCONT2.PERSON_FIRST_NAME) || DECODE(END_ARL.MEANING
, NULL
, NULL
, ' '|| END_ARL.MEANING) END_CUSTOMER_CONTACT
, END_CUSTOMER_ORG.LOCATION END_CUSTOMER_LOCATION
, END_CUSTOMER_ADDR2.ADDRESS1 END_CUSTOMER_ADDRESS1
, END_CUSTOMER_ADDR2.ADDRESS2 END_CUSTOMER_ADDRESS2
, END_CUSTOMER_ADDR2.ADDRESS3 END_CUSTOMER_ADDRESS3
, END_CUSTOMER_ADDR2.ADDRESS4 END_CUSTOMER_ADDRESS4
, DECODE(END_CUSTOMER_ADDR2.CITY
, NULL
, NULL
, END_CUSTOMER_ADDR2.CITY || '
, ') || DECODE(END_CUSTOMER_ADDR2.STATE
, NULL
, NULL
, END_CUSTOMER_ADDR2.STATE || '
, ') || DECODE(END_CUSTOMER_ADDR2.POSTAL_CODE
, NULL
, NULL
, END_CUSTOMER_ADDR2.POSTAL_CODE || '
, ') || DECODE(END_CUSTOMER_ADDR2.COUNTRY
, NULL
, NULL
, END_CUSTOMER_ADDR2.COUNTRY) END_CUSTOMER_ADDRESS5
, '_LA:L.IB_OWNER:OE_LOOKUPS:ITEM_OWNER:MEANING'
, '_LA:L.IB_CURRENT_LOCATION:OE_LOOKUPS:ITEM_CURRENT_LOCATION:MEANING'
, '_LA:L.IB_INSTALLED_AT_LOCATION:OE_LOOKUPS:ITEM_INSTALL_LOCATION:MEANING'
FROM OE_ORDER_LINES_ALL L
, HZ_CUST_SITE_USES_ALL END_CUSTOMER_ORG
, HZ_PARTY_SITES END_CUSTOMER_ADDR1
, HZ_LOCATIONS END_CUSTOMER_ADDR2
, HZ_CUST_ACCT_SITES_ALL END_CUSTOMER_ADDR3
, HZ_PARTIES END_PARTY
, HZ_CUST_ACCOUNTS END_CUST_ACCT
, HZ_CUST_ACCOUNT_ROLES ENDCONT1
, HZ_PARTIES ENDCONT2
, AR_LOOKUPS END_ARL
, HZ_RELATIONSHIPS ENDCONT4
, HZ_CUST_ACCOUNTS ENDACCT
WHERE L.END_CUSTOMER_SITE_USE_ID = END_CUSTOMER_ORG.SITE_USE_ID(+)
AND END_CUSTOMER_ORG.CUST_ACCT_SITE_ID = END_CUSTOMER_ADDR3.CUST_ACCT_SITE_ID(+)
AND END_CUSTOMER_ADDR3.PARTY_SITE_ID = END_CUSTOMER_ADDR1.PARTY_SITE_ID(+)
AND END_CUSTOMER_ADDR2.LOCATION_ID(+) = END_CUSTOMER_ADDR1.LOCATION_ID
AND L.END_CUSTOMER_CONTACT_ID = ENDCONT1.CUST_ACCOUNT_ROLE_ID(+)
AND ENDCONT1.PARTY_ID = ENDCONT4.PARTY_ID(+)
AND ENDCONT1.ROLE_TYPE(+) = 'CONTACT'
AND END_ARL.LOOKUP_TYPE(+) = 'CONTACT_TITLE'
AND END_ARL.LOOKUP_CODE(+) = ENDCONT2.PERSON_PRE_NAME_ADJUNCT
AND ENDCONT1.CUST_ACCOUNT_ID = ENDACCT.CUST_ACCOUNT_ID(+)
AND NVL(ENDCONT4.OBJECT_ID
, -1) = NVL(ENDACCT.PARTY_ID
, -1)
AND ENDCONT4.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND ENDCONT4.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND ENDCONT4.SUBJECT_ID = ENDCONT2.PARTY_ID(+)
AND END_CUSTOMER_ADDR3.CUST_ACCOUNT_ID = END_CUST_ACCT.CUST_ACCOUNT_ID(+)
AND END_PARTY.PARTY_ID(+)= END_CUST_ACCT.PARTY_ID
AND '_SEC:L.ORG_ID' IS NOT NULL WITH READ ONLY

Columns