[Home] [Help] [Dependency Information]
Object Name: | AS_IMP_SL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AS.AS_IMP_SL_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ADDR_DO_NOT_MAIL_FLAG | VARCHAR2 | (1) | ||
ADDRESS1 | VARCHAR2 | (240) | ||
ADDRESS2 | VARCHAR2 | (240) | ||
ADDRESS3 | VARCHAR2 | (240) | ||
ADDRESS4 | VARCHAR2 | (240) | ||
ADDRESS_ID | NUMBER | (15) | ||
ADDRESS_KEY | VARCHAR2 | (500) | ||
ADDRESS_STATUS | VARCHAR2 | (1) | ||
ANALYSIS_FY | VARCHAR2 | (5) | ||
AREA_CODE | VARCHAR2 | (10) | ||
BATCH_ID | NUMBER | (15) | ||
BUDGET_AMOUNT | NUMBER | |||
BUDGET_AMOUNT_1 | NUMBER | |||
BUDGET_AMOUNT_2 | NUMBER | |||
BUDGET_AMOUNT_3 | NUMBER | |||
BUDGET_AMOUNT_4 | NUMBER | |||
BUDGET_AMOUNT_5 | NUMBER | |||
BUDGET_STATUS_CODE | VARCHAR2 | (30) | ||
CHANNEL_CODE | VARCHAR2 | (30) | ||
CITY | VARCHAR2 | (60) | ||
CLOSE_REASON | VARCHAR2 | (30) | ||
COMPETITOR_FLAG | VARCHAR2 | (1) | ||
CONFIRMED_FLAG | VARCHAR2 | (1) | ||
CONTACT_KEY | VARCHAR2 | (80) | ||
CONTACT_PARTY_ID | NUMBER | |||
CONTACT_ROLE_CODE | VARCHAR2 | (30) | ||
CONT_DO_NOT_MAIL_FLAG | VARCHAR2 | (1) | ||
COUNTRY | VARCHAR2 | (60) | ||
COUNTY | VARCHAR2 | (60) | ||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CUSTOMER_CATEGORY_CODE | VARCHAR2 | (30) | ||
CUSTOMER_CLASS_CODE | VARCHAR2 | (30) | ||
CUSTOMER_GROUP_CODE | VARCHAR2 | (30) | ||
CUSTOMER_ID | NUMBER | (15) | ||
CUSTOMER_KEY | VARCHAR2 | (500) | ||
CUSTOMER_NAME | VARCHAR2 | (255) | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
CUSTOMER_PROSPECT_CODE | VARCHAR2 | (30) | ||
CUSTOMER_RANK | VARCHAR2 | (30) | ||
CUSTOMER_STATUS | VARCHAR2 | (1) | ||
CUSTOMER_SUBGROUP_CODE | VARCHAR2 | (30) | ||
CUSTOMER_TYPE | VARCHAR2 | (30) | ||
DECISION_TIMEFRAME_CODE | VARCHAR2 | (30) | ||
DESCRIPTION | VARCHAR2 | (2000) | ||
DO_NOT_EMAIL_FLAG | VARCHAR2 | (1) | ||
DO_NOT_FAX_FLAG | VARCHAR2 | (1) | ||
DO_NOT_PHONE_FLAG | VARCHAR2 | (1) | ||
EMAIL_ADDRESS | VARCHAR2 | (240) | ||
EXTENSION | VARCHAR2 | (20) | ||
FAX_AREA_CODE | VARCHAR2 | (10) | ||
FAX_NUMBER | VARCHAR2 | (25) | ||
FIRST_NAME | VARCHAR2 | (40) | ||
FISCAL_YEAREND_MONTH | VARCHAR2 | (30) | ||
IMP_LIST_HEADER_NUMBER | VARCHAR2 | (30) | ||
IMPORT_INTERFACE_ID | NUMBER | Yes | ||
INCUMBENT_PARTNER_PARTY_ID | NUMBER | |||
INCUMBENT_PARTNER_RESOURCE_ID | NUMBER | |||
INITIATING_CONTACT_ID | NUMBER | |||
INTEREST_TYPE_ID_1 | NUMBER | |||
INTEREST_TYPE_ID_2 | NUMBER | |||
INTEREST_TYPE_ID_3 | NUMBER | |||
INTEREST_TYPE_ID_4 | NUMBER | |||
INTEREST_TYPE_ID_5 | NUMBER | |||
INVENTORY_ITEM_ID_1 | NUMBER | |||
INVENTORY_ITEM_ID_2 | NUMBER | |||
INVENTORY_ITEM_ID_3 | NUMBER | |||
INVENTORY_ITEM_ID_4 | NUMBER | |||
INVENTORY_ITEM_ID_5 | NUMBER | |||
JOB_TITLE | VARCHAR2 | (100) | ||
JOB_TITLE_CODE | VARCHAR2 | (30) | ||
LAST_NAME | VARCHAR2 | (50) | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
LEAD_NOTE | VARCHAR2 | (2000) | ||
LEAD_NUMBER | VARCHAR2 | (30) | ||
LEAD_RANK_CODE | VARCHAR2 | (30) | ||
LEAD_RANK_ID | NUMBER | (15) | ||
LOAD_DATE | DATE | Yes | ||
LOAD_ERROR_MESSAGE | VARCHAR2 | (2000) | ||
LOAD_STATUS | VARCHAR2 | (20) | ||
LOAD_TYPE | VARCHAR2 | (20) | ||
LOCATION_ID | NUMBER | (15) | ||
MAIL_STOP | VARCHAR2 | (60) | ||
MIDDLE_INITIAL | VARCHAR2 | (10) | ||
NET_WORTH | NUMBER | |||
NEW_CON_FLAG | NUMBER | (1) | ||
NEW_LOC_FLAG | NUMBER | (1) | ||
NEW_PARTY_FLAG | NUMBER | (1) | ||
NEW_PS_FLAG | NUMBER | (1) | ||
NEW_REL_FLAG | NUMBER | (1) | ||
NUM_ATTENDED | NUMBER | (5) | ||
NUM_ENROLLED | NUMBER | (5) | ||
NUM_OF_EMPLOYEES | NUMBER | (15) | ||
OFFER_ID | NUMBER | |||
ORGANIZATION_ID_1 | NUMBER | |||
ORGANIZATION_ID_2 | NUMBER | |||
ORGANIZATION_ID_3 | NUMBER | |||
ORGANIZATION_ID_4 | NUMBER | |||
ORGANIZATION_ID_5 | NUMBER | |||
ORIG_SYSTEM_CODE | VARCHAR2 | (30) | ||
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | ||
PARENT_PROJECT | VARCHAR2 | (80) | ||
PARTY_ID | NUMBER | (15) | ||
PARTY_SITE_ID | NUMBER | (15) | ||
PARTY_TYPE | VARCHAR2 | (30) | ||
PAYMENT_AMOUNT | NUMBER | |||
PHONE_ID | NUMBER | |||
PHONE_NUMBER | VARCHAR2 | (25) | ||
PHONE_STATUS | VARCHAR2 | (1) | ||
PHONE_TYPE | VARCHAR2 | (30) | ||
POSTAL_CODE | VARCHAR2 | (60) | ||
POTENTIAL_REVENUE_CURR_FY | NUMBER | |||
POTENTIAL_REVENUE_NEXT_FY | NUMBER | |||
PRIMARY_INTEREST_CODE_ID_1 | NUMBER | |||
PRIMARY_INTEREST_CODE_ID_2 | NUMBER | |||
PRIMARY_INTEREST_CODE_ID_3 | NUMBER | |||
PRIMARY_INTEREST_CODE_ID_4 | NUMBER | |||
PRIMARY_INTEREST_CODE_ID_5 | NUMBER | |||
PRM_EXEC_SPONSOR_FLAG | VARCHAR2 | (1) | ||
PRM_IND_CLASSIFICATION_CODE | VARCHAR2 | (30) | ||
PRM_PRJ_LEAD_IN_PLACE_FLAG | VARCHAR2 | (1) | ||
PRM_SALES_LEAD_TYPE | VARCHAR2 | (30) | ||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
PROMOTION_CODE | VARCHAR2 | (50) | ||
PROMOTION_ID | NUMBER | |||
PROMOTION_NAME | VARCHAR2 | (240) | ||
PROVINCE | VARCHAR2 | (60) | ||
QUANTITY_1 | NUMBER | |||
QUANTITY_2 | NUMBER | |||
QUANTITY_3 | NUMBER | |||
QUANTITY_4 | NUMBER | |||
QUANTITY_5 | NUMBER | |||
REFERENCE_USE_FLAG | VARCHAR2 | (1) | ||
REL_PARTY_ID | NUMBER | (15) | ||
REQUEST_ID | NUMBER | |||
SALES_CHANNEL_CODE | VARCHAR2 | (30) | ||
SALES_LEAD_ID | NUMBER | (15) | ||
SALUTATION | VARCHAR2 | (60) | ||
SECONDARY_INTEREST_CODE_ID_1 | NUMBER | |||
SECONDARY_INTEREST_CODE_ID_2 | NUMBER | |||
SECONDARY_INTEREST_CODE_ID_3 | NUMBER | |||
SECONDARY_INTEREST_CODE_ID_4 | NUMBER | |||
SECONDARY_INTEREST_CODE_ID_5 | NUMBER | |||
SECURITY_GROUP_ID | VARCHAR2 | (0) | ||
SEX_CODE | VARCHAR2 | (30) | ||
SIC_CODE | VARCHAR2 | (30) | ||
SITE_CONTACT_ID | NUMBER | (15) | ||
SOURCE_PROMOTION_ID | NUMBER | |||
SOURCE_SYSTEM | VARCHAR2 | (30) | ||
STATE | VARCHAR2 | (60) | ||
STATUS_CHANGE_FLAG | VARCHAR2 | (1) | ||
STATUS_CODE | VARCHAR2 | (30) | ||
STATUS_CODE_1 | VARCHAR2 | (30) | ||
STATUS_CODE_2 | VARCHAR2 | (30) | ||
STATUS_CODE_3 | VARCHAR2 | (30) | ||
STATUS_CODE_4 | VARCHAR2 | (30) | ||
STATUS_CODE_5 | VARCHAR2 | (30) | ||
TAX_CODE | VARCHAR2 | (50) | ||
TAX_REFERENCE | VARCHAR2 | (50) | ||
THIRD_PARTY_FLAG | VARCHAR2 | (1) | ||
TITLE | VARCHAR2 | (40) | ||
UOM_CODE_1 | VARCHAR2 | (3) | ||
UOM_CODE_2 | VARCHAR2 | (3) | ||
UOM_CODE_3 | VARCHAR2 | (3) | ||
UOM_CODE_4 | VARCHAR2 | (3) | ||
UOM_CODE_5 | VARCHAR2 | (3) | ||
URL | VARCHAR2 | (2000) | ||
VEHICLE_RESPONSE_CODE | VARCHAR2 | (30) | ||
YEAR_ESTABLISHED | NUMBER | (4) | ||
HZ_PARTYID | NUMBER | (15) | ||
HZ_PARTY_LUD | DATE | Yes | ||
HZ_LOCID | NUMBER | (15) | ||
HZ_PSID | NUMBER | (15) | ||
URGENT_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ADDR_DO_NOT_MAIL_FLAG
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, ADDRESS_ID
, ADDRESS_KEY
, ADDRESS_STATUS
, ANALYSIS_FY
, AREA_CODE
, BATCH_ID
, BUDGET_AMOUNT
, BUDGET_AMOUNT_1
, BUDGET_AMOUNT_2
, BUDGET_AMOUNT_3
, BUDGET_AMOUNT_4
, BUDGET_AMOUNT_5
, BUDGET_STATUS_CODE
, CHANNEL_CODE
, CITY
, CLOSE_REASON
, COMPETITOR_FLAG
, CONFIRMED_FLAG
, CONTACT_KEY
, CONTACT_PARTY_ID
, CONTACT_ROLE_CODE
, CONT_DO_NOT_MAIL_FLAG
, COUNTRY
, COUNTY
, CREATED_BY
, CREATION_DATE
, CURRENCY_CODE
, CUSTOMER_CATEGORY_CODE
, CUSTOMER_CLASS_CODE
, CUSTOMER_GROUP_CODE
, CUSTOMER_ID
, CUSTOMER_KEY
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, CUSTOMER_PROSPECT_CODE
, CUSTOMER_RANK
, CUSTOMER_STATUS
, CUSTOMER_SUBGROUP_CODE
, CUSTOMER_TYPE
, DECISION_TIMEFRAME_CODE
, DESCRIPTION
, DO_NOT_EMAIL_FLAG
, DO_NOT_FAX_FLAG
, DO_NOT_PHONE_FLAG
, EMAIL_ADDRESS
, EXTENSION
, FAX_AREA_CODE
, FAX_NUMBER
, FIRST_NAME
, FISCAL_YEAREND_MONTH
, IMP_LIST_HEADER_NUMBER
, IMPORT_INTERFACE_ID
, INCUMBENT_PARTNER_PARTY_ID
, INCUMBENT_PARTNER_RESOURCE_ID
, INITIATING_CONTACT_ID
, INTEREST_TYPE_ID_1
, INTEREST_TYPE_ID_2
, INTEREST_TYPE_ID_3
, INTEREST_TYPE_ID_4
, INTEREST_TYPE_ID_5
, INVENTORY_ITEM_ID_1
, INVENTORY_ITEM_ID_2
, INVENTORY_ITEM_ID_3
, INVENTORY_ITEM_ID_4
, INVENTORY_ITEM_ID_5
, JOB_TITLE
, JOB_TITLE_CODE
, LAST_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LEAD_NOTE
, LEAD_NUMBER
, LEAD_RANK_CODE
, LEAD_RANK_ID
, LOAD_DATE
, LOAD_ERROR_MESSAGE
, LOAD_STATUS
, LOAD_TYPE
, LOCATION_ID
, MAIL_STOP
, MIDDLE_INITIAL
, NET_WORTH
, NEW_CON_FLAG
, NEW_LOC_FLAG
, NEW_PARTY_FLAG
, NEW_PS_FLAG
, NEW_REL_FLAG
, NUM_ATTENDED
, NUM_ENROLLED
, NUM_OF_EMPLOYEES
, OFFER_ID
, ORGANIZATION_ID_1
, ORGANIZATION_ID_2
, ORGANIZATION_ID_3
, ORGANIZATION_ID_4
, ORGANIZATION_ID_5
, ORIG_SYSTEM_CODE
, ORIG_SYSTEM_REFERENCE
, PARENT_PROJECT
, PARTY_ID
, PARTY_SITE_ID
, PARTY_TYPE
, PAYMENT_AMOUNT
, PHONE_ID
, PHONE_NUMBER
, PHONE_STATUS
, PHONE_TYPE
, POSTAL_CODE
, POTENTIAL_REVENUE_CURR_FY
, POTENTIAL_REVENUE_NEXT_FY
, PRIMARY_INTEREST_CODE_ID_1
, PRIMARY_INTEREST_CODE_ID_2
, PRIMARY_INTEREST_CODE_ID_3
, PRIMARY_INTEREST_CODE_ID_4
, PRIMARY_INTEREST_CODE_ID_5
, PRM_EXEC_SPONSOR_FLAG
, PRM_IND_CLASSIFICATION_CODE
, PRM_PRJ_LEAD_IN_PLACE_FLAG
, PRM_SALES_LEAD_TYPE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROMOTION_CODE
, PROMOTION_ID
, PROMOTION_NAME
, PROVINCE
, QUANTITY_1
, QUANTITY_2
, QUANTITY_3
, QUANTITY_4
, QUANTITY_5
, REFERENCE_USE_FLAG
, REL_PARTY_ID
, REQUEST_ID
, SALES_CHANNEL_CODE
, SALES_LEAD_ID
, SALUTATION
, SECONDARY_INTEREST_CODE_ID_1
, SECONDARY_INTEREST_CODE_ID_2
, SECONDARY_INTEREST_CODE_ID_3
, SECONDARY_INTEREST_CODE_ID_4
, SECONDARY_INTEREST_CODE_ID_5
, SECURITY_GROUP_ID
, SEX_CODE
, SIC_CODE
, SITE_CONTACT_ID
, SOURCE_PROMOTION_ID
, SOURCE_SYSTEM
, STATE
, STATUS_CHANGE_FLAG
, STATUS_CODE
, STATUS_CODE_1
, STATUS_CODE_2
, STATUS_CODE_3
, STATUS_CODE_4
, STATUS_CODE_5
, TAX_CODE
, TAX_REFERENCE
, THIRD_PARTY_FLAG
, TITLE
, UOM_CODE_1
, UOM_CODE_2
, UOM_CODE_3
, UOM_CODE_4
, UOM_CODE_5
, URL
, VEHICLE_RESPONSE_CODE
, YEAR_ESTABLISHED
, HZ_PARTYID
, HZ_PARTY_LUD
, HZ_LOCID
, HZ_PSID
, URGENT_FLAG
FROM APPS.AS_IMP_SL_V;
APPS.AS_IMP_SL_V is not referenced by any database object
|
|
|