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

VIEW: APPS.INL_CHARGE_LINE_TYPES_VL

Object Details
Object Name: INL_CHARGE_LINE_TYPES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINL.INL_CHARGE_LINE_TYPES_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


This view shows Charge Line Type information in a given language.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CHARGE_LINE_TYPE_ID NUMBER
Yes Charge Line Type Identifier
CHARGE_LINE_TYPE_CODE VARCHAR2 (30) Yes Charge Line Type Code
CHARGE_LINE_TYPE_NAME VARCHAR2 (80) Yes Charge Line Type Name
DFLT_LANDED_COST_FLAG CHAR (1)
"Y" or "N" flag indicating whether the amounts of the line should be considered in the landed cost
AP_LINE_TYPE_CODE CHAR (13)
Payables Invoice Line Type lookup code
ALLOCATION_BASIS VARCHAR2 (30)
Criteria through which an associated amount will be distributed into two or more components of a shipment
ACTIVE_FROM_DATE DATE

Active From Date
ACTIVE_TO_DATE DATE

Active To Date
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
Query Text

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


SELECT CHARGE_LINE_TYPE_ID
,      CHARGE_LINE_TYPE_CODE
,      CHARGE_LINE_TYPE_NAME
,      DFLT_LANDED_COST_FLAG
,      AP_LINE_TYPE_CODE
,      ALLOCATION_BASIS
,      ACTIVE_FROM_DATE
,      ACTIVE_TO_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.INL_CHARGE_LINE_TYPES_VL;

Dependencies

[top of page]

APPS.INL_CHARGE_LINE_TYPES_VL references the following:

SchemaAPPS
ViewPON_COST_FACTORS_VL
APPS.INL_CHARGE_LINE_TYPES_VL is referenced by following:

SchemaAPPS
Package BodyINL_CHARGE_PVT - show dependent code
Package BodyINL_INTERFACE_PVT - show dependent code
Package BodyINL_SHIPMENT_PVT - show dependent code