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


VIEW: APPS.OE_RETROBILLED_INFO_V

Object Details
Object Name: OE_RETROBILLED_INFO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_RETROBILLED_INFO_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
LINE_NUMBER NUMBER
Yes Original line sequence number within the order
ORIG_SHIPMENT_NUMBER NUMBER
Yes Original system generated identifer of a shipment within a line
ORIG_OPTION_NUMBER NUMBER

Original system generated identifer for an option or a class within a model
ORIG_COMPONENT_NUMBER NUMBER

Original system Generated Identifier of the included item within a model or a class
ORIG_SERVICE_NUMBER NUMBER

Original unique number to identify the service lines
ORDERED_ITEM VARCHAR2 (2000)
Stores name of Ordered Item
PRICING_DATE DATE

Determines effective list and price modifiers
QTY NUMBER

Retrobill Quantity Ordered
UNIT_SELLING_PRICE NUMBER

Retrobill actual price chaged to customer
AMOUNT NUMBER

Retrobill amount
RETROBILL_ORDER_NUMBER NUMBER
Yes Retrobill user-visible number of the order
RETROBILL_LINE_NUMBER NUMBER
Yes Retrobill Line sequence number within the order
SHIPMENT_NUMBER NUMBER
Yes Retrobill system generated identifer of a shipment within a line
OPTION_NUMBER NUMBER

Retrobill system generated identifer for an option or a class within a model
COMPONENT_NUMBER NUMBER

Retrobill System Generated Identifier of the included item within a model or a class
SERVICE_NUMBER NUMBER

Retrobill unique number to identify the service lines.
INVOICED_QUANTITY NUMBER

Retrobill - To indicate whether the invoicing activity is complete or not.
ITEM_IDENTIFIER_TYPE VARCHAR2 (30)
Retrobill - To distinguish different types of items (internal, customer. and generic items)
ORDER_QUANTITY_UOM VARCHAR2 (3)
Retrobill ordered quantity Unit of measure
NAME VARCHAR2 (30) Yes Transaction type name in translated language
HEADER_ID NUMBER
Yes Original foreign key reference to OE_ORDER_HEADERS_ALL; the order to which this line belongs.
LINE_ID NUMBER
Yes Original System Generated Line Identifier.
RETROBILL_HEADER_ID NUMBER
Yes Retrobill foreign key reference to OE_ORDER_HEADERS_ALL; the order to which this line belongs
RETROBILL_LINE_ID NUMBER
Yes Retrobill Original System Generated Line Identifier.
Query Text

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


SELECT LINE_NUMBER
,      ORIG_SHIPMENT_NUMBER
,      ORIG_OPTION_NUMBER
,      ORIG_COMPONENT_NUMBER
,      ORIG_SERVICE_NUMBER
,      ORDERED_ITEM
,      PRICING_DATE
,      QTY
,      UNIT_SELLING_PRICE
,      AMOUNT
,      RETROBILL_ORDER_NUMBER
,      RETROBILL_LINE_NUMBER
,      SHIPMENT_NUMBER
,      OPTION_NUMBER
,      COMPONENT_NUMBER
,      SERVICE_NUMBER
,      INVOICED_QUANTITY
,      ITEM_IDENTIFIER_TYPE
,      ORDER_QUANTITY_UOM
,      NAME
,      HEADER_ID
,      LINE_ID
,      RETROBILL_HEADER_ID
,      RETROBILL_LINE_ID
FROM APPS.OE_RETROBILLED_INFO_V;

Dependencies

[top of page]

APPS.OE_RETROBILLED_INFO_V references the following:

SchemaAPPS
SynonymFND_LANGUAGES
SynonymOE_ORDER_HEADERS
SynonymOE_ORDER_LINES_ALL
SynonymOE_TRANSACTION_TYPES_TL

APPS.OE_RETROBILLED_INFO_V is not referenced by any database object