[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_CVREFOFFERABBREV_2003 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_UC_CVREFOFFERABBREV_2003 |
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 |
---|---|---|---|---|
ABBREVCODE | VARCHAR2 | (2) | Abbreviation code | |
ABBREVTEXT | VARCHAR2 | (250) | Abbreviation description | |
LETTERFORMAT | VARCHAR2 | (1) | Letter format takes values from A to G | |
SUMMARYCHAR | VARCHAR2 | (1) | Summary of conditions character | |
UNCOND | VARCHAR2 | (1) | Y - Valid for unconditional offers, N - Not valid for unconditional offers | |
WITHDRAWAL | VARCHAR2 | (1) | Y - Valid for withdrawal decisions, N - Not valid for withdrawal decisions | |
RELEASE | VARCHAR2 | (1) | Y - Valid for release to clearing, N - Not valid for release to clearing | |
TARIFF | VARCHAR2 | (1) | Y - Valid for use in Tariff offers, N - Not valid for use in Tariff offers |
Cut, paste (and edit) the following text to query this object:
SELECT ABBREVCODE
, ABBREVTEXT
, LETTERFORMAT
, SUMMARYCHAR
, UNCOND
, WITHDRAWAL
, RELEASE
, TARIFF
FROM APPS.IGS_UC_CVREFOFFERABBREV_2003;
|
|
|