[Home] [Help] [Dependency Information]
Object Name: | AS_OPPORTUNITY_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AS.AS_OPPORTUNITY_LINES_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
LEAD_LINE_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
LEAD_ID | NUMBER | Yes | ||
PRODUCT_CATEGORY_ID | NUMBER | |||
PRODUCT_CAT_SET_ID | NUMBER | |||
CONCATENATED_CAT_DESC | VARCHAR2 | (4000) | ||
INTEREST_STATUS_CODE | VARCHAR2 | (30) | ||
INVENTORY_ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
UOM_CODE | VARCHAR2 | (3) | ||
QUANTITY | NUMBER | |||
TOTAL_AMOUNT | NUMBER | |||
SHIP_DATE | DATE | |||
ORIGINAL_LEAD_LINE_ID | NUMBER | |||
QUOTED_LINE_FLAG | VARCHAR2 | (1) | ||
ORG_ID | NUMBER | |||
FORECAST_DATE | DATE | |||
ROLLING_FORECAST_FLAG | VARCHAR2 | (1) | Flag to indicate that the forecast date is defaulted from close date in as_leads_all | |
PRICE | NUMBER | |||
PRICE_VOLUME_MARGIN | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
OFFER_ID | NUMBER | |||
OFFER_NAME | VARCHAR2 | (2000) | ||
OFFER_CODE | VARCHAR2 | (30) | Unique code given for the offer. | |
SOURCE_PROMOTION_ID | NUMBER | |||
CAMPAIGN_NAME | VARCHAR2 | (2000) | ||
CAMPAIGN_ID | NUMBER | |||
CAMPAIGN_CODE | VARCHAR2 | (30) | ||
SOURCE_CODE | VARCHAR2 | (30) | ||
UNIT_OF_MEASURE_TL | VARCHAR2 | (25) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Inventory item description | |
DISABLE_DATE | DATE | |||
PURCHASE_INTEREST | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, LEAD_LINE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LEAD_ID
, PRODUCT_CATEGORY_ID
, PRODUCT_CAT_SET_ID
, CONCATENATED_CAT_DESC
, INTEREST_STATUS_CODE
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, UOM_CODE
, QUANTITY
, TOTAL_AMOUNT
, SHIP_DATE
, ORIGINAL_LEAD_LINE_ID
, QUOTED_LINE_FLAG
, ORG_ID
, FORECAST_DATE
, ROLLING_FORECAST_FLAG
, PRICE
, PRICE_VOLUME_MARGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, OFFER_ID
, OFFER_NAME
, OFFER_CODE
, SOURCE_PROMOTION_ID
, CAMPAIGN_NAME
, CAMPAIGN_ID
, CAMPAIGN_CODE
, SOURCE_CODE
, UNIT_OF_MEASURE_TL
, CONCATENATED_SEGMENTS
, ITEM_DESCRIPTION
, DISABLE_DATE
, PURCHASE_INTEREST
FROM APPS.AS_OPPORTUNITY_LINES_V;
APPS.AS_OPPORTUNITY_LINES_V is not referenced by any database object
|
|
|