[Home] [Help] [Dependency Information]
Object Name: | CS_CONT_BILL_IFACE_ALL |
---|---|
Object Type: | TABLE |
Owner: | CS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACTS_INTERFACE_ID | NUMBER | Yes | ||
CP_SERVICE_TRANSACTION_ID | NUMBER | Yes | ||
CP_SERVICE_ID | NUMBER | Yes | ||
CONTRACT_ID | NUMBER | Yes | ||
AR_TRX_TYPE | VARCHAR2 | (15) | Yes | |
TRX_START_DATE | DATE | Yes | ||
TRX_END_DATE | DATE | Yes | ||
TRX_DATE | DATE | Yes | ||
TRX_AMOUNT | NUMBER | Yes | ||
REASON_CODE | VARCHAR2 | (30) | ||
REASON_COMMENTS | VARCHAR2 | (240) | ||
CP_QUANTITY | NUMBER | |||
CONCURRENT_PROCESS_ID | NUMBER | |||
ORG_ID | NUMBER | |||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CONTRACT_BILLING_ID | NUMBER | Yes | ||
OBJECT_VERSION_NUMBER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CONTRACTS_INTERFACE_ID
, CP_SERVICE_TRANSACTION_ID
, CP_SERVICE_ID
, CONTRACT_ID
, AR_TRX_TYPE
, TRX_START_DATE
, TRX_END_DATE
, TRX_DATE
, TRX_AMOUNT
, REASON_CODE
, REASON_COMMENTS
, CP_QUANTITY
, CONCURRENT_PROCESS_ID
, ORG_ID
, CREATED_BY
, CREATION_DATE
, CONTRACT_BILLING_ID
, OBJECT_VERSION_NUMBER
FROM CS.CS_CONT_BILL_IFACE_ALL;
CS.CS_CONT_BILL_IFACE_ALL does not reference any database object
CS.CS_CONT_BILL_IFACE_ALL is referenced by following:
|
|
|