[Home] [Help]
View: XNC_PARTY_ACCT_INSTANCE_H
| Product: | XNC - Sales for Communications (Obsolete) |
|---|
| Description: | This view gives expired instances for a given party and account. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT UNIQUE CP.INSTANCE_ID
, CP.PARTY_ID
, HCA.ACCOUNT_NUMBER ACCOUNT
, CI.SYSTEM_ID SYSTEM_ID
, DECODE(CST.NAME
, NULL
, 'NO SYSTEM'
, CST.NAME) SYSTEM_NAME
, CI.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, NVL(CI.INV_ORGANIZATION_ID
, CI.INV_MASTER_ORGANIZATION_ID) ORGANIZATION_ID
, MSI.DESCRIPTION
, MSI.PADDED_CONCATENATED_SEGMENTS
FROM CSI_I_PARTIES CP
, CSI_IP_ACCOUNTS CIA
, CSI_ITEM_INSTANCES_H CII
, CSI_ITEM_INSTANCES CI
, CSI_SYSTEMS_TL CST
, CSI_SYSTEMS_B CSB
, MTL_SYSTEM_ITEMS_VL MSI
, HZ_CUST_ACCOUNTS HCA
WHERE CP.INSTANCE_PARTY_ID = CIA.INSTANCE_PARTY_ID
AND CIA.RELATIONSHIP_TYPE_CODE = 'OWNER'
AND CIA.ACTIVE_END_DATE IS NULL
AND CP.INSTANCE_ID =CII.INSTANCE_ID
AND CI.SYSTEM_ID = CSB.SYSTEM_ID(+)
AND CSB.SYSTEM_ID = CST.SYSTEM_ID(+)
AND CI.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND CI.INV_MASTER_ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND CII.NEW_ACTIVE_END_DATE IS NOT NULL
AND CI.INSTANCE_ID =CII.INSTANCE_ID
AND HCA.CUST_ACCOUNT_ID = CIA.PARTY_ACCOUNT_ID
AND CST.LANGUAGE (+)= USERENV('LANG')
Columns
| Name |
| INSTANCE_ID |
| PARTY_ID |
| ACCOUNT |
| SYSTEM_ID |
| SYSTEM_NAME |
| INVENTORY_ITEM_ID |
| ORGANIZATION_ID |
| DESCRIPTION |
| PADDED_CONCATENATED_SEGMENTS |