[Home] [Help]
View: XNC_SYSTEMS_PO_RG_V
| Product: | XNC - Sales for Communications (Obsolete) |
|---|
| Description: | This View Retrieves the System Name and other Details of Pending Orders for a Given Party and Customer Account |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT CSTTS.TRANSACTION_SYSTEM_ID SYSTEM_ID
, CSTTS.SYSTEM_NAME SYSTEM_NAME
, CSTTS.SYSTEM_NUMBER SERIAL_NUMBER
, HP.PARTY_NAME
, HCA.ACCOUNT_NUMBER ACCOUNT_NUMBER
, CSTTS.DESCRIPTION SYSTEM_DESCRIPTION
, CLK.MEANING SYSTEM_TYPE
, CSTTS.CUSTOMER_ID CUSTOMER_ID
, HCA.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, HCA.PARTY_ID PARTY_ID
FROM CSI_T_TXN_SYSTEMS CSTTS
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP
, FND_LOOKUP_VALUES CLK
WHERE CLK.LOOKUP_TYPE(+) = 'CSI_SYSTEM_TYPE'
AND CSTTS.SYSTEM_TYPE_CODE = CLK.LOOKUP_CODE(+)
AND CLK.LANGUAGE = USERENV('LANG')
AND CLK.VIEW_APPLICATION_ID = 542
AND CSTTS.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID
AND HCA.PARTY_ID = HP.PARTY_ID
Columns
| Name |
| SYSTEM_ID |
| SYSTEM_NAME |
| SERIAL_NUMBER |
| PARTY_NAME |
| ACCOUNT_NUMBER |
| SYSTEM_DESCRIPTION |
| SYSTEM_TYPE |
| CUSTOMER_ID |
| CUST_ACCOUNT_ID |
| PARTY_ID |