[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | INL_ADJ_CHARGE_LINES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  INL.INL_ADJ_CHARGE_LINES_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view shows adjusted information on Charge Lines.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CHARGE_LINE_ID | NUMBER | Yes | Charge Line Identifier | |
| CHARGE_LINE_NUM | NUMBER | Yes | Charge Line Number | |
| CHARGE_LINE_TYPE_ID | NUMBER | Yes | Charge Line Type Identifier | |
| LANDED_COST_FLAG | VARCHAR2 | (1) | Yes | "Y" or "N" flag indicating whether the amount should be considered in the landed cost |
| PARENT_CHARGE_LINE_ID | NUMBER | Parent Charge Line Identifier | ||
| ADJUSTMENT_NUM | NUMBER | Yes | Adjustment Number | |
| MATCH_ID | NUMBER | Match Identifier | ||
| MATCH_AMOUNT_ID | NUMBER | Match Amount Identifier | ||
| CHARGE_AMT | NUMBER | Yes | Charge Ammount | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
| CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
| PARTY_ID | NUMBER | Party Identifier | ||
| PARTY_SITE_ID | NUMBER | Party Site Identifier | ||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Categorization of a transaction for tax purposes | |
| INTENDED_USE | VARCHAR2 | (30) | Purpose for which a product may be used | |
| PRODUCT_FISCAL_CLASS | VARCHAR2 | (240) | Classification of the product(s) by tax authority for tax purposes | |
| PRODUCT_CATEGORY | VARCHAR2 | (240) | Used to classify products for tax purposes | |
| PRODUCT_TYPE | VARCHAR2 | (240) | Product related classification for tax purposes | |
| USER_DEF_FISCAL_CLASS | VARCHAR2 | (240) | User Defined Fiscal Classifiction | |
| TAX_CLASSIFICATION_CODE | VARCHAR2 | (30) | Tax Classification Code | |
| ASSESSABLE_VALUE | NUMBER | EBTAX Assessable Value | ||
| TAX_ALREADY_CALCULATED_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the taxes have already been calculated | |
| SHIP_FROM_PARTY_ID | NUMBER | Ship From Party Identifier | ||
| SHIP_FROM_PARTY_SITE_ID | NUMBER | Ship From Party Site Identifier | ||
| SHIP_TO_ORGANIZATION_ID | NUMBER | Ship To Organization Identifier | ||
| SHIP_TO_LOCATION_ID | NUMBER | Ship To Location Identifier | ||
| BILL_FROM_PARTY_ID | NUMBER | Bill From Party Identifier | ||
| BILL_FROM_PARTY_SITE_ID | NUMBER | Bill From Party Site Identifier | ||
| BILL_TO_ORGANIZATION_ID | NUMBER | Bill To Organization Identifier | ||
| BILL_TO_LOCATION_ID | NUMBER | Bill To Location Identifier | ||
| POA_PARTY_ID | NUMBER | Point of Order Acceptance Party Identifier | ||
| POA_PARTY_SITE_ID | NUMBER | Point of Order Acceptance Party Site Identifier | ||
| POO_ORGANIZATION_ID | NUMBER | Point of Order Origin Organization Identifier | ||
| POO_LOCATION_ID | NUMBER | Point of Order Origin Location Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT CHARGE_LINE_ID
, CHARGE_LINE_NUM
, CHARGE_LINE_TYPE_ID
, LANDED_COST_FLAG
, PARENT_CHARGE_LINE_ID
, ADJUSTMENT_NUM
, MATCH_ID
, MATCH_AMOUNT_ID
, CHARGE_AMT
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, PARTY_ID
, PARTY_SITE_ID
, TRX_BUSINESS_CATEGORY
, INTENDED_USE
, PRODUCT_FISCAL_CLASS
, PRODUCT_CATEGORY
, PRODUCT_TYPE
, USER_DEF_FISCAL_CLASS
, TAX_CLASSIFICATION_CODE
, ASSESSABLE_VALUE
, TAX_ALREADY_CALCULATED_FLAG
, SHIP_FROM_PARTY_ID
, SHIP_FROM_PARTY_SITE_ID
, SHIP_TO_ORGANIZATION_ID
, SHIP_TO_LOCATION_ID
, BILL_FROM_PARTY_ID
, BILL_FROM_PARTY_SITE_ID
, BILL_TO_ORGANIZATION_ID
, BILL_TO_LOCATION_ID
, POA_PARTY_ID
, POA_PARTY_SITE_ID
, POO_ORGANIZATION_ID
, POO_LOCATION_ID
FROM APPS.INL_ADJ_CHARGE_LINES_V;
APPS
INL_CHARGE_LINES
APPS
INL_ADJ_ASSOCIATIONS_V
INL_CHARGE_OVERALL_V
INL_EBTAX_LINES_V
INL_LANDEDCOST_PVT
- show dependent code
INL_SHIPMENT_PVT
- show dependent code
|
|
|
|