[Home] [Help] [Dependency Information]
Object Name: | QPFV_COUPON_ISSUES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QP.QPFV_COUPON_ISSUES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view gives information about Coupon Issue type of modifier.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LIST_HEADER_ID | NUMBER | Yes | ||
BENEFIT_MODIFIER_LINE_ID | NUMBER | Yes | ||
LIST_LINE_NO | VARCHAR2 | (30) | ||
START_DATE_ACTIVE | DATE | |||
END_DATE_ACTIVE | DATE | |||
PRODUCT_PRECEDENCE | NUMBER | |||
PRICING_PHASE_ID | NUMBER | |||
PRICING_GROUP_SEQUENCE | NUMBER | |||
EXPIRATION_PERIOD_START_DATE | DATE | |||
NUMBER_EXPIRATION_PERIODS | NUMBER | |||
EXPIRATION_DATE | DATE | |||
ACCRUAL_FLAG | VARCHAR2 | (1) | ||
ESTIM_GL_VALUE | NUMBER | |||
ACCRUAL_CONVERSION_RATE | NUMBER | |||
EXPIRATION_PERIOD_UOM | VARCHAR2 | (3) | ||
UOM_NAME | VARCHAR2 | (25) | This is the name of expiration period uom code. | |
INCOMPATIBILITY_GRP_CODE | VARCHAR2 | (30) | ||
_LA:INCOMPATIBILITY_GRP_CODE | CHAR | (73) | ||
LIST_LINE_TYPE_CODE | VARCHAR2 | (30) | Yes | |
_LA:LIST_LINE_TYPE_CODE | CHAR | (65) | ||
PRICE_BREAK_TYPE_CODE | VARCHAR2 | (30) | ||
_LA:PRICE_BREAK_TYPE_CODE | CHAR | (69) | ||
MODIFIER_LEVEL_CODE | VARCHAR2 | (30) | Yes | |
_LA:MODIFIER_LEVEL_CODE | CHAR | (65) | ||
LIST_LINE_ID | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
_DF | CHAR | (23) | Descriptive Flexfield column values of qp_list_lines table. | |
ORIG_SYS_HEADER_REF | VARCHAR2 | (50) | ||
ORIG_SYS_LINE_REF | VARCHAR2 | (50) |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_HEADER_ID
, BENEFIT_MODIFIER_LINE_ID
, LIST_LINE_NO
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PRODUCT_PRECEDENCE
, PRICING_PHASE_ID
, PRICING_GROUP_SEQUENCE
, EXPIRATION_PERIOD_START_DATE
, NUMBER_EXPIRATION_PERIODS
, EXPIRATION_DATE
, ACCRUAL_FLAG
, ESTIM_GL_VALUE
, ACCRUAL_CONVERSION_RATE
, EXPIRATION_PERIOD_UOM
, UOM_NAME
, INCOMPATIBILITY_GRP_CODE
, _LA:INCOMPATIBILITY_GRP_CODE
, LIST_LINE_TYPE_CODE
, _LA:LIST_LINE_TYPE_CODE
, PRICE_BREAK_TYPE_CODE
, _LA:PRICE_BREAK_TYPE_CODE
, MODIFIER_LEVEL_CODE
, _LA:MODIFIER_LEVEL_CODE
, LIST_LINE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, _DF
, ORIG_SYS_HEADER_REF
, ORIG_SYS_LINE_REF
FROM APPS.QPFV_COUPON_ISSUES;
APPS.QPFV_COUPON_ISSUES is not referenced by any database object
|
|
|