[Home] [Help] [Dependency Information]
Object Name: | AS_TRANSFER_QUES |
---|---|
Object Type: | TABLE |
Owner: | OSM |
FND Design Data: | AS.AS_TRANSFER_QUES |
Subobject Name: | |
Status: | VALID |
For Lead Sharing use
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AS_TRANSFER_QUES_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | PARTNER_TRANSACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTNER_TRANSACTION_ID | NUMBER | Yes | Transaction ID for the Lead Header | |
SOURCE_LEAD_ID | NUMBER | Yes | Lead ID from the source partner | |
DESTINATION_LEAD_ID | NUMBER | Lead id created in the destination site. | ||
SOURCE_PARTNER_ID | NUMBER | Yes | Source partner id | |
DESTINATION_PARTNER_ID | NUMBER | Yes | destination partner id | |
TRANSACTION_STATUS | VARCHAR2 | (1) | Yes | Status of the request, open, completed or error |
CREATE_TIMESTAMP | DATE | Yes | Time Column | |
API_TIMESTAMP | DATE | Time Column | ||
LEAD_CR_TIMESTAMP | DATE | Time Column |
Cut, paste (and edit) the following text to query this object:
SELECT PARTNER_TRANSACTION_ID
, SOURCE_LEAD_ID
, DESTINATION_LEAD_ID
, SOURCE_PARTNER_ID
, DESTINATION_PARTNER_ID
, TRANSACTION_STATUS
, CREATE_TIMESTAMP
, API_TIMESTAMP
, LEAD_CR_TIMESTAMP
FROM OSM.AS_TRANSFER_QUES;
OSM.AS_TRANSFER_QUES does not reference any database object
OSM.AS_TRANSFER_QUES is referenced by following:
|
|
|