FND Design Data [Home] [Help]

View: CS_TAX_LINES_SUMMARY_V

Product: CS - Service
Description: View provided for the Taxation module.
Implementation/DBA Data: ViewAPPS.CS_TAX_LINES_SUMMARY_V
View Text

SELECT SHIP_LOC.CUSTOMER_ID
, BILL_LOC.CUSTOMER_ID
, TO_NUMBER(NULL)
, ESTDET.ESTIMATE_DETAIL_ID
, INC.INCIDENT_ID
, NULL
, SYSDATE
, SYSDATE
, V.TAX_CODE
, V.TAX_RATE
, TO_NUMBER(NULL)
, ESTDET.SHIP_TO_ORG_ID
, ESTDET.INVOICE_TO_ORG_ID
, SHIP_LOC.POSTAL_CODE
, BILL_LOC.POSTAL_CODE
, ESTDET.INVENTORY_ITEM_ID
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, SHIP_LOC.LOCATION_ID
, BILL_LOC.LOCATION_ID
, NULL
, (ESTDET.QUANTITY_REQUIRED*ESTDET.SELLING_PRICE)
, ESTDET.CONVERSION_RATE
, TO_NUMBER(NULL)
, C.CURRENCY_CODE
, TO_NUMBER(NULL)
, C.PRECISION
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, ESTDET.QUANTITY_REQUIRED
, NULL
, TO_NUMBER(NULL)
, 'ALL'
, 'Y'
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, ESTDET.ESTIMATE_DETAIL_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'Y'
, NULL
, NULL
, NULL
, NULL
, NULL
, V.VAT_TAX_ID
, ASO.ORDER_TYPE_ID
, NVL(V.AMOUNT_INCLUDES_TAX_FLAG
, 'N')
, MTL.ORGANIZATION_ID
, NULL
, INC.ORG_ID
, NULL
, NULL
, V.TAXABLE_BASIS
, V.TAX_CALCULATION_PLSQL_BLOCK
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL FROM RA_ADDRESSES BILL_LOC
, RA_ADDRESSES SHIP_LOC
, RA_SITE_USES BILL_SITE
, RA_SITE_USES SHIP_SITE
, FND_CURRENCIES C
, CS_INCIDENTS_ALL INC
, CS_ESTIMATE_DETAILS ESTDET
, MTL_SYSTEM_ITEMS MTL
, AR_VAT_TAX V
, CS_BUSINESS_PROCESSES BP
, ASO_I_ORDER_TYPES_V ASO
WHERE ESTDET.INCIDENT_ID = INC.INCIDENT_ID
AND SHIP_SITE.SITE_USE_ID(+) = CS_CHARGE_CORE_PVT.GET_SHIP_TO_SITE_ID(ESTDET.INCIDENT_ID
, ESTDET.ESTIMATE_DETAIL_ID)
AND SHIP_SITE.ADDRESS_ID = SHIP_LOC.ADDRESS_ID(+)
AND BILL_SITE.SITE_USE_ID(+) = CS_CHARGE_CORE_PVT.GET_INVOICE_TO_PARTY_SITE_ID(ESTDET.INCIDENT_ID
, ESTDET.ESTIMATE_DETAIL_ID)
AND BILL_SITE.ADDRESS_ID = BILL_LOC.ADDRESS_ID(+)
AND ESTDET.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID(+)
AND MTL.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND C.CURRENCY_CODE(+) = ESTDET.CURRENCY_CODE
AND ESTDET.BUSINESS_PROCESS_ID = BP.BUSINESS_PROCESS_ID(+)
AND BP.ORDER_TYPE_ID = ASO.ORDER_TYPE_ID(+)
AND ESTDET.TAX_CODE = V.TAX_CODE(+) AND SYSDATE BETWEEN NVL(V.START_DATE
, TO_DATE('01011900'
, 'MMDDYYYY'))
AND NVL(V.END_DATE
, TO_DATE('12312199'
, 'MMDDYYYY'))
AND NVL(V.ENABLED_FLAG
, 'Y') = 'Y'
AND NVL(V.AMOUNT_INCLUDES_TAX_FLAG
, 'N') = 'N'

Columns

Name
SHIP_TO_CUSTOMER_ID
BILL_TO_CUSTOMER_ID
TRX_CHARGE_LINE_ID
TRX_LINE_ID
TRX_HEADER_ID
TRX_LINK_TO_CUST_TRX_LINE_ID
TRX_DATE
GL_DATE
TAX_CODE
TAX_RATE
TAX_AMOUNT
SHIP_TO_SITE_USE_ID
BILL_TO_SITE_USE_ID
SHIP_TO_POSTAL_CODE
BILL_TO_POSTAL_CODE
INVENTORY_ITEM_ID
MEMO_LINE_ID
TAX_EXEMPT_FLAG
TAX_EXEMPT_NUMBER
TAX_EXEMPT_REASON_CODE
SHIP_TO_LOCATION_CCID
BILL_TO_LOCATION_CCID
INVOICING_RULE_ID
EXTENDED_AMOUNT
EXCHANGE_RATE
SET_OF_BOOKS_ID
CURRENCY_CODE
MINIMUM_ACCOUNTABLE_UNIT
PRECISION
USSGL_TRANSACTION_CODE
USSGL_TRX_CODE_CONTEXT
REQUEST_ID
POO_ADDRESS_CODE
POA_ADDRESS_CODE
SHIP_FROM_ADDRESS_CODE
SHIP_TO_ADDRESS_CODE
FOB_CODE
TAXED_QUANTITY
PART_NUMBER
TAX_LINE_NUMBER
LOCATION_QUALIFIER
TAXABLE_FLAG
COMPOUNDING_PRECEDENCE
TAX_EXEMPTION_ID
TAX_EXCEPTION_ID
VENDOR_CONTROL_EXEMPTIONS
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
NUMERIC_ATTRIBUTE1
NUMERIC_ATTRIBUTE2
NUMERIC_ATTRIBUTE3
NUMERIC_ATTRIBUTE4
NUMERIC_ATTRIBUTE5
TRX_NUMBER
SHIP_TO_CUSTOMER_NUMBER
SHIP_TO_CUSTOMER_NAME
BILL_TO_CUSTOMER_NUMBER
BILL_TO_CUSTOMER_NAME
PREVIOUS_TRX_LINE_ID
PREVIOUS_TRX_HEADER_ID
PREVIOUS_TRX_NUMBER
AUDIT_FLAG
TRX_LINE_TYPE
DIVISION_CODE
COMPANY_CODE
TAX_HEADER_LEVEL_FLAG
TAX_ROUNDING_VALUE
VAT_TAX_ID
TRX_TYPE_ID
AMOUNT_INCLUDES_TAX_FLAG
SHIP_FROM_WAREHOUSE_ID
POO_ID
POA_ID
PAYMENT_TERM_ID
PAYMENT_TERMS_DISCOUNT_PERCENT
TAXABLE_BASIS
TAX_CALCULATION_PLSQL_BLOCK
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
NUMERIC_ATTRIBUTE6
NUMERIC_ATTRIBUTE7
NUMERIC_ATTRIBUTE8
NUMERIC_ATTRIBUTE9
NUMERIC_ATTRIBUTE10