VIEW: APPS.IGI_AR_CUSTOMERS_V

Source

View Text - Preformatted

SELECT CUST_ACCT.CUST_ACCOUNT_ID "CUSTOMER_ID" , CUST_ACCT.LAST_UPDATE_DATE , CUST_ACCT.LAST_UPDATED_BY , CUST_ACCT.CREATION_DATE , CUST_ACCT.CREATED_BY , SUBSTRB(PS.PARTY_NAME, 1, 50) "CUSTOMER_NAME" , CUST_ACCT.ACCOUNT_NUMBER "CUSTOMER_NUMBER" , CUST_ACCT.ORIG_SYSTEM_REFERENCE , CUST_ACCT.STATUS , CUST_ACCT.LAST_UPDATE_LOGIN , CUST_ACCT.CUSTOMER_CLASS_CODE "CUSTOMER_PROSPECT_CODE" , PS. JGZZ_FISCAL_CODE , DECODE(PS.PARTY_TYPE, 'ORGANIZATION', PS.ORGANIZATION_NAME_PHONETIC, NULL) "CUSTOMER_NAME_PHONETIC" , PS.TAX_REFERENCE , IGI.STP_TYPE , L_TYPE.MEANING "STP_TYPE_MEANING" , CUST_ACCT.WAREHOUSE_ID , PS.CUSTOMER_KEY , CUST_ACCT.ROWID "ROW_ID" , IGI.STP_ENFORCE_THRESHOLD FROM HZ_CUST_ACCOUNTS CUST_ACCT , IGI_LOOKUPS L_TYPE , IGI_RA_CUSTOMERS IGI , HZ_PARTIES PS WHERE PS.PARTY_ID = CUST_ACCT.PARTY_ID AND CUST_ACCT.CUST_ACCOUNT_ID = IGI.CUSTOMER_ID(+) AND IGI.STP_TYPE = L_TYPE.LOOKUP_CODE(+) AND L_TYPE.LOOKUP_TYPE(+) = 'IGI_STP_TYPE'

View Text - HTML Formatted

SELECT CUST_ACCT.CUST_ACCOUNT_ID "CUSTOMER_ID"
, CUST_ACCT.LAST_UPDATE_DATE
, CUST_ACCT.LAST_UPDATED_BY
, CUST_ACCT.CREATION_DATE
, CUST_ACCT.CREATED_BY
, SUBSTRB(PS.PARTY_NAME
, 1
, 50) "CUSTOMER_NAME"
, CUST_ACCT.ACCOUNT_NUMBER "CUSTOMER_NUMBER"
, CUST_ACCT.ORIG_SYSTEM_REFERENCE
, CUST_ACCT.STATUS
, CUST_ACCT.LAST_UPDATE_LOGIN
, CUST_ACCT.CUSTOMER_CLASS_CODE "CUSTOMER_PROSPECT_CODE"
, PS. JGZZ_FISCAL_CODE
, DECODE(PS.PARTY_TYPE
, 'ORGANIZATION'
, PS.ORGANIZATION_NAME_PHONETIC
, NULL) "CUSTOMER_NAME_PHONETIC"
, PS.TAX_REFERENCE
, IGI.STP_TYPE
, L_TYPE.MEANING "STP_TYPE_MEANING"
, CUST_ACCT.WAREHOUSE_ID
, PS.CUSTOMER_KEY
, CUST_ACCT.ROWID "ROW_ID"
, IGI.STP_ENFORCE_THRESHOLD
FROM HZ_CUST_ACCOUNTS CUST_ACCT
, IGI_LOOKUPS L_TYPE
, IGI_RA_CUSTOMERS IGI
, HZ_PARTIES PS
WHERE PS.PARTY_ID = CUST_ACCT.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = IGI.CUSTOMER_ID(+)
AND IGI.STP_TYPE = L_TYPE.LOOKUP_CODE(+)
AND L_TYPE.LOOKUP_TYPE(+) = 'IGI_STP_TYPE'