[Home] [Help] [Dependency Information]
Object Name: | JTY_TERR_1001_OPPOR_TRANS_GT |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | JTF.JTY_TERR_1001_OPPOR_TRANS_GT |
Subobject Name: | |
Status: | VALID |
APPS.JTY_TERR_1001_OPPOR_TRANS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANS_OBJECT_ID | NUMBER | |||
TRANS_DETAIL_OBJECT_ID | NUMBER | |||
LEAD_ID | NUMBER | |||
LEAD_LINE_ID | NUMBER | |||
CITY | VARCHAR2 | (360) | ||
POSTAL_CODE | VARCHAR2 | (360) | ||
STATE | VARCHAR2 | (360) | ||
PROVINCE | VARCHAR2 | (360) | ||
COUNTY | VARCHAR2 | (360) | ||
COUNTRY | VARCHAR2 | (360) | ||
INTEREST_TYPE_ID | NUMBER | |||
PRIMARY_INTEREST_ID | NUMBER | |||
SECONDARY_INTEREST_ID | NUMBER | |||
PARTY_ID | NUMBER | |||
PARTY_SITE_ID | NUMBER | |||
AREA_CODE | VARCHAR2 | (360) | ||
COMP_NAME_RANGE | VARCHAR2 | (360) | ||
PARTNER_ID | NUMBER | |||
NUM_OF_EMPLOYEES | NUMBER | |||
CATEGORY_CODE | VARCHAR2 | (360) | ||
PARTY_RELATIONSHIP_ID | NUMBER | |||
SIC_CODE | VARCHAR2 | (360) | ||
TARGET_SEGMENT_CURRENT | VARCHAR2 | (360) | ||
TOTAL_AMOUNT | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (360) | ||
PRICING_DATE | DATE | |||
CHANNEL_CODE | VARCHAR2 | (360) | ||
INVENTORY_ITEM_ID | NUMBER | |||
OPP_INTEREST_TYPE_ID | NUMBER | |||
OPP_PRIMARY_INTEREST_ID | NUMBER | |||
OPP_SECONDARY_INTEREST_ID | NUMBER | |||
OPCLSS_INTEREST_TYPE_ID | NUMBER | |||
OPCLSS_PRIMARY_INTEREST_ID | NUMBER | |||
OPCLSS_SECONDARY_INTEREST_ID | NUMBER | |||
ATTRIBUTE1 | VARCHAR2 | (360) | ||
ATTRIBUTE2 | VARCHAR2 | (360) | ||
ATTRIBUTE3 | VARCHAR2 | (360) | ||
ATTRIBUTE4 | VARCHAR2 | (360) | ||
ATTRIBUTE5 | VARCHAR2 | (360) | ||
ATTRIBUTE6 | VARCHAR2 | (360) | ||
ATTRIBUTE7 | VARCHAR2 | (360) | ||
ATTRIBUTE8 | VARCHAR2 | (360) | ||
ATTRIBUTE9 | VARCHAR2 | (360) | ||
ATTRIBUTE10 | VARCHAR2 | (360) | ||
ATTRIBUTE11 | VARCHAR2 | (360) | ||
ATTRIBUTE12 | VARCHAR2 | (360) | ||
ATTRIBUTE13 | VARCHAR2 | (360) | ||
ATTRIBUTE14 | VARCHAR2 | (360) | ||
ATTRIBUTE15 | VARCHAR2 | (360) | ||
ORG_ID | NUMBER | |||
SQUAL_NUM06 | NUMBER | |||
CAR_CURRENCY_CODE | VARCHAR2 | (360) | ||
SQUAL_CHAR40 | VARCHAR2 | (360) | ||
SQUAL_CHAR41 | VARCHAR2 | (360) | ||
SQUAL_NUM40 | NUMBER | |||
SQUAL_NUM01 | NUMBER | |||
SQUAL_CHAR01 | VARCHAR2 | (360) | ||
SQUAL_CHAR02 | VARCHAR2 | (360) | ||
SQUAL_CHAR11 | VARCHAR2 | (360) | ||
TXN_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT TRANS_OBJECT_ID
, TRANS_DETAIL_OBJECT_ID
, LEAD_ID
, LEAD_LINE_ID
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
, COUNTRY
, INTEREST_TYPE_ID
, PRIMARY_INTEREST_ID
, SECONDARY_INTEREST_ID
, PARTY_ID
, PARTY_SITE_ID
, AREA_CODE
, COMP_NAME_RANGE
, PARTNER_ID
, NUM_OF_EMPLOYEES
, CATEGORY_CODE
, PARTY_RELATIONSHIP_ID
, SIC_CODE
, TARGET_SEGMENT_CURRENT
, TOTAL_AMOUNT
, CURRENCY_CODE
, PRICING_DATE
, CHANNEL_CODE
, INVENTORY_ITEM_ID
, OPP_INTEREST_TYPE_ID
, OPP_PRIMARY_INTEREST_ID
, OPP_SECONDARY_INTEREST_ID
, OPCLSS_INTEREST_TYPE_ID
, OPCLSS_PRIMARY_INTEREST_ID
, OPCLSS_SECONDARY_INTEREST_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, SQUAL_NUM06
, CAR_CURRENCY_CODE
, SQUAL_CHAR40
, SQUAL_CHAR41
, SQUAL_NUM40
, SQUAL_NUM01
, SQUAL_CHAR01
, SQUAL_CHAR02
, SQUAL_CHAR11
, TXN_DATE
FROM APPS.JTY_TERR_1001_OPPOR_TRANS_GT;
APPS.JTY_TERR_1001_OPPOR_TRANS_GT does not reference any database object
APPS.JTY_TERR_1001_OPPOR_TRANS_GT is not referenced by any database object
|
|
|