VIEW: APPS.INL_EBTAX_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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