[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 |