[Home] [Help]
| Product: | AS - Sales Foundation |
|---|---|
| Description: | Tax lines summary view for sales tax calculation in quotes |
| Implementation/DBA Data: | Not implemented in this database |
SELECT SHIP.CUSTOMER_ID
, BILL.CUSTOMER_ID
, TO_NUMBER(NULL)
, QL.QUOTE_LINE_ID
, QL.QUOTE_ID
, NULL
, SYSDATE
, SYSDATE
, V.TAX_CODE
, TO_NUMBER(NULL)
, NULL
, Q.SHIP_TO_SITE_USE_ID
, Q.INVOICE_TO_SITE_USE_ID
, SHIP.POSTAL_CODE
, BILL.POSTAL_CODE
, QL.INVENTORY_ITEM_ID
, TO_NUMBER(NULL)
, Q.TAX_EXEMPT_FLAG
, Q.TAX_EXEMPT_NUM
, Q.TAX_EXEMPT_REASON_CODE
, SHIP.LOCATION_ID
, BILL.LOCATION_ID
, Q.INVOICING_RULE_ID
, (QL.LINE_QUOTE_PRICE - QL.LINE_LIST_PRICE * NVL(Q.TOTAL_DISCOUNT_PERCENT
, 0) / 100) * QL.QUANTITY
, Q.EXCHANGE_RATE
, TO_NUMBER(NULL)
, C.CURRENCY_CODE
, TO_NUMBER(NULL)
, C.PRECISION
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, Q.FOB_CODE
, QL.QUANTITY
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'Y'
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, SO.CUST_TRX_TYPE_ID
, NVL(V.AMOUNT_INCLUDES_TAX_FLAG
, 'N')
, QL.ORGANIZATION_ID
, DECODE(Q.EMPLOYEE_PERSON_ID
, NULL
, Q.ORG_ID
, ASGN.ORGANIZATION_ID)
, Q.ORG_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM RA_ADDRESSES BILL
, RA_ADDRESSES SHIP
, RA_SITE_USES SHIP_SITE
, RA_SITE_USES BILL_SITE
, FND_CURRENCIES C
, AS_QUOTES Q
, AS_QUOTE_LINES QL
, SO_ORDER_TYPES SO
, AR_VAT_TAX TG
, AR_VAT_TAX V
, PER_ASSIGNMENTS_F ASGN
WHERE QL.QUOTE_ID = Q.QUOTE_ID
AND C.CURRENCY_CODE = Q.CURRENCY_CODE (+)
AND Q.SHIP_TO_SITE_USE_ID = SHIP_SITE.SITE_USE_ID (+)
AND Q.INVOICE_TO_SITE_USE_ID = BILL_SITE.SITE_USE_ID (+)
AND SHIP_SITE.ADDRESS_ID = SHIP.ADDRESS_ID (+)
AND BILL_SITE.ADDRESS_ID = BILL.ADDRESS_ID (+)
AND Q.ORDER_TYPE_ID = SO.ORDER_TYPE_ID(+)
AND QL.TAX_CODE = TG.TAX_CODE
AND SYSDATE BETWEEN NVL(TG.START_DATE
, TO_DATE('01011900'
, 'MMDDYYYY'))
AND NVL(TG.END_DATE
, TO_DATE('12312199'
, 'MMDDYYYY'))
AND TG.VAT_TAX_ID = V.VAT_TAX_ID(+)
AND SYSDATE BETWEEN NVL(V.START_DATE
, TO_DATE('01011900'
, 'MMDDYYYY'))
AND NVL(V.END_DATE
, TO_DATE('12312199'
, 'MMDDYYYY'))
AND NVL(V.AMOUNT_INCLUDES_TAX_FLAG
, 'N') = 'N'
AND Q.EMPLOYEE_PERSON_ID = ASGN.PERSON_ID(+)
AND NVL(ASGN.PRIMARY_FLAG
, 'Y') = 'Y'
AND SYSDATE BETWEEN NVL(ASGN.EFFECTIVE_START_DATE
, TO_DATE( '01011900'
, 'DDMMYYYY'))
AND NVL(ASGN.EFFECTIVE_END_DATE
, TO_DATE( '31122199'
, 'DDMMYYYY'))