DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.SO_MANUAL_DISCOUNTS_V

Object Details
Object Name: SO_MANUAL_DISCOUNTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOE.SO_MANUAL_DISCOUNTS_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (30) Yes
DISCOUNT_ID NUMBER
Yes
PRICE_LIST_ID NUMBER
Yes
OVERRIDE_ALLOWED_FLAG VARCHAR2 (1)

AMOUNT NUMBER


PERCENT NUMBER


GSA_INDICATOR VARCHAR2 (1)

DISCOUNT_LINE_ID NUMBER


ENTITY_ID NUMBER


ENTITY_VALUE VARCHAR2 (4000)

LINE_PRICE NUMBER


LINE_AMOUNT NUMBER


LINE_PERCENT NUMBER


BREAK_PRICE NUMBER


BREAK_AMOUNT NUMBER


BREAK_PERCENT NUMBER


PRICE_BREAK_LINES_LOW_RANGE NUMBER


PRICE_BREAK_LINES_HIGH_RANGE NUMBER


UNIT_CODE VARCHAR2 (3)

METHOD_TYPE_CODE VARCHAR2 (30)

ROUNDING_FACTOR NUMBER


Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NAME
,      DISCOUNT_ID
,      PRICE_LIST_ID
,      OVERRIDE_ALLOWED_FLAG
,      AMOUNT
,      PERCENT
,      GSA_INDICATOR
,      DISCOUNT_LINE_ID
,      ENTITY_ID
,      ENTITY_VALUE
,      LINE_PRICE
,      LINE_AMOUNT
,      LINE_PERCENT
,      BREAK_PRICE
,      BREAK_AMOUNT
,      BREAK_PERCENT
,      PRICE_BREAK_LINES_LOW_RANGE
,      PRICE_BREAK_LINES_HIGH_RANGE
,      UNIT_CODE
,      METHOD_TYPE_CODE
,      ROUNDING_FACTOR
FROM APPS.SO_MANUAL_DISCOUNTS_V;

Dependencies

[top of page]

APPS.SO_MANUAL_DISCOUNTS_V references the following:

SchemaAPPS
PL/SQL PackageQP_PRICE_LIST_PVT - show dependent code
PL/SQL PackageQP_VIEW_UTIL - show dependent code
SynonymSO_DISCOUNTS
SynonymSO_DISCOUNT_LINES
SynonymSO_PRICE_BREAK_LINES
SynonymSO_PRICE_LISTS

APPS.SO_MANUAL_DISCOUNTS_V is not referenced by any database object