View: INL_EBTAX_LINES_V

Product:	INL - Oracle Landed Cost Management
Description:	This view shows EBTAX Line information.
Implementation/DBA Data:	APPS.INL_EBTAX_LINES_V

View Text

SELECT 'SHIP_LINE' SOURCE
, OL.SHIP_LINE_ID SHIP_LINE_ID
, OL.SHIP_LINE_GROUP_ID SHIP_LINE_GROUP_ID
, OL.SHIP_LINE_NUM SHIP_LINE_NUM
, OL.SHIP_LINE_TYPE_ID SHIP_LINE_TYPE_ID
, OL.SHIP_LINE_SRC_TYPE_CODE SRC_TYPE_CODE
, OL.SHIP_LINE_SOURCE_ID SRC_ID
, OL.SHIP_HEADER_ID SHIP_HEADER_ID
, OL.TXN_UNIT_PRICE UNIT_PRICE
, OL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, OL.TXN_UOM_CODE UOM_CODE
, NULL PARTY_ID
, NULL PARTY_SITE_ID
, OL.TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY
, OL.INTENDED_USE INTENDED_USE
, OL.PRODUCT_FISCAL_CLASS PRODUCT_FISCAL_CLASS
, OL.PRODUCT_CATEGORY PRODUCT_CATEGORY
, OL.PRODUCT_TYPE PRODUCT_TYPE
, OL.USER_DEF_FISCAL_CLASS USER_DEF_FISCAL_CLASS
, OL.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, OL.ASSESSABLE_VALUE ASSESSABLE_VALUE
, NVL(OL.TXN_QTY*OL.TXN_UNIT_PRICE
, 0) LINE_AMT
, OL.TXN_QTY LINE_QTY
, OL.TAX_ALREADY_CALCULATED_FLAG TAX_ALREADY_CALCULATED_FLAG
, OL.SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID
, OL.SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID
, OL.SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID
, OL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, OL.BILL_FROM_PARTY_ID BILL_FROM_PARTY_ID
, OL.BILL_FROM_PARTY_SITE_ID BILL_FROM_PARTY_SITE_ID
, OL.BILL_TO_ORGANIZATION_ID BILL_TO_ORGANIZATION_ID
, OL.BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, OL.POA_PARTY_ID POA_PARTY_ID
, OL.POA_PARTY_SITE_ID POA_PARTY_SITE_ID
, OL.POO_ORGANIZATION_ID POO_ORGANIZATION_ID
, OL.POO_LOCATION_ID POO_LOCATION_ID
, OL.CURRENCY_CODE CURRENCY_CODE
, OL.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, OL.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, OL.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, OL.ADJUSTMENT_NUM ADJUSTMENT_NUM
FROM INL_ADJ_SHIP_LINES_V OL UNION ALL SELECT 'CHARGE' SOURCE
, CL.CHARGE_LINE_ID SHIP_LINE_ID
, NULL SHIP_LINE_GROUP_ID
, CL.CHARGE_LINE_NUM SHIP_LINE_NUM
, NULL SHIP_LINE_TYPE_ID
, NULL SRC_TYPE_CODE
, NULL SRC_ID
, NULL SHIP_HEADER_ID
, CL.CHARGE_AMT UNIT_PRICE
, NULL INVENTORY_ITEM_ID
, NULL UOM_CODE
, CL.PARTY_ID PARTY_ID
, CL.PARTY_SITE_ID PARTY_SITE_ID
, CL.TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY
, CL.INTENDED_USE INTENDED_USE
, CL.PRODUCT_FISCAL_CLASS PRODUCT_FISCAL_CLASS
, CL.PRODUCT_CATEGORY PRODUCT_CATEGORY
, CL.PRODUCT_TYPE PRODUCT_TYPE
, CL.USER_DEF_FISCAL_CLASS USER_DEF_FISCAL_CLASS
, CL.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, CL.ASSESSABLE_VALUE ASSESSABLE_VALUE
, CL.CHARGE_AMT LINE_AMT
, 1 LINE_QTY
, CL.TAX_ALREADY_CALCULATED_FLAG TAX_ALREADY_CALCULATED_FLAG
, CL.SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID
, CL.SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID
, CL.SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID
, CL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, CL.BILL_FROM_PARTY_ID BILL_FROM_PARTY_ID
, CL.BILL_FROM_PARTY_SITE_ID BILL_FROM_PARTY_SITE_ID
, CL.BILL_TO_ORGANIZATION_ID BILL_TO_ORGANIZATION_ID
, CL.BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, CL.POA_PARTY_ID POA_PARTY_ID
, CL.POA_PARTY_SITE_ID POA_PARTY_SITE_ID
, CL.POO_ORGANIZATION_ID POO_ORGANIZATION_ID
, CL.POO_LOCATION_ID POO_LOCATION_ID
, CL.CURRENCY_CODE CURRENCY_CODE
, CL.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CL.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CL.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CL.ADJUSTMENT_NUM ADJUSTMENT_NUM
FROM INL_ADJ_CHARGE_LINES_V CL

Columns