Product: | IGI - Public Sector Financials International |
---|---|
Description: | This view displays single third party customers information |
Implementation/DBA Data: | APPS.IGI_AR_CUSTOMERS_V |
SELECT CUST.CUSTOMER_ID
, CUST.LAST_UPDATE_DATE
, CUST.LAST_UPDATED_BY
, CUST.CREATION_DATE
, CUST.CREATED_BY
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, CUST.ORIG_SYSTEM_REFERENCE
, CUST.STATUS
, CUST.LAST_UPDATE_LOGIN
, CUST.CUSTOMER_PROSPECT_CODE
, CUST.JGZZ_FISCAL_CODE
, CUST.CUSTOMER_NAME_PHONETIC
, CUST.TAX_REFERENCE
, IGI.STP_TYPE
, L_TYPE.MEANING STP_TYPE_MEANING
, CUST.WAREHOUSE_ID
, CUST.CUSTOMER_KEY
, CUST_ACCOUNT.ROWID ROW_ID
, IGI.STP_ENFORCE_THRESHOLD
FROM HZ_CUST_ACCOUNTS CUST_ACCOUNT
, IGI_LOOKUPS L_TYPE
, IGI_RA_CUSTOMERS IGI
, RA_HCUSTOMERS CUST
WHERE CUST.CUSTOMER_ID = CUST_ACCOUNT.CUST_ACCOUNT_ID
AND CUST.CUSTOMER_ID = IGI.CUSTOMER_ID(+)
AND IGI.STP_TYPE = L_TYPE.LOOKUP_CODE(+)
AND L_TYPE.LOOKUP_TYPE(+) = 'IGI_STP_TYPE'