Product: | AS - Sales Foundation |
---|---|
Description: | |
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)
, TO_NUMBER(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)
, ARP_TAX_VIEW_VERTEX.POO_ADDRESS_CODE( 'AS_TAX_LINES_SUMMARY_V_V'
, Q.QUOTE_ID
, QL.QUOTE_LINE_ID)
, ARP_TAX_VIEW_VERTEX.POA_ADDRESS_CODE( 'AS_TAX_LINES_SUMMARY_V_V'
, Q.QUOTE_ID
, QL.QUOTE_LINE_ID
, SALES.SALESREP_ID)
, ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE( 'AS_TAX_LINES_SUMMARY_V_V'
, Q.QUOTE_ID
, QL.QUOTE_LINE_ID
, QL.ORGANIZATION_ID)
, ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE( 'AS_TAX_LINES_SUMMARY_V_V'
, Q.QUOTE_ID
, QL.QUOTE_LINE_ID
, NVL(SHIP.ADDRESS_ID
, BILL.ADDRESS_ID)
, NVL(SHIP.LOCATION_ID
, BILL.LOCATION_ID)
, SYSDATE
, NVL(SHIP.STATE
, BILL.STATE)
, NVL(SHIP.POSTAL_CODE
, BILL.POSTAL_CODE))
, Q.FOB_CODE
, QL.QUANTITY
, ARP_TAX_VIEW_VERTEX.PRODUCT_CODE( 'AS_TAX_LINES_SUMMARY_V_V'
, Q.QUOTE_ID
, QL.QUOTE_LINE_ID
, QL.INVENTORY_ITEM_ID
, NULL)
, NULL
, 'ALL'
, 'Y'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS( 'AS_TAX_LINES_SUMMARY_V_V'
, Q.QUOTE_ID
, QL.QUOTE_LINE_ID
, INV_TYPE.CUST_TRX_TYPE_ID)
, ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE( 'AS_TAX_LINES_SUMMARY_V_V'
, Q.QUOTE_ID
, QL.QUOTE_LINE_ID)
, ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS( 'AS_TAX_LINES_SUMMARY_V_V'
, Q.QUOTE_ID
, QL.QUOTE_LINE_ID
, Q.CUSTOMER_ID)
, NULL
, NULL
, NULL
, ARP_TAX_VIEW_VERTEX.USE_SECONDARY( 'AS_TAX_LINES_SUMMARY_V_V'
, Q.QUOTE_ID
, QL.QUOTE_LINE_ID)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, SC.CUSTOMER_NUMBER SHIP_TO_CUSTOMER_NUMBER
, SC.CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME
, BC.CUSTOMER_NUMBER BILL_TO_CUSTOMER_NUMBER
, BC.CUSTOMER_NAME BILL_TO_CUSTOMER_NAME
, NULL
, NULL
, NULL
, 'N'
, NULL
, ARP_TAX_VIEW_VERTEX.DIVISION_CODE( 'AS_TAX_LINES_SUMMARY_V_V'
, Q.QUOTE_ID
, QL.QUOTE_LINE_ID)
, ARP_TAX_VIEW_VERTEX.COMPANY_CODE( 'AS_TAX_LINES_SUMMARY_V_V'
, Q.QUOTE_ID
, QL.QUOTE_LINE_ID)
, DECODE( NVL(SYS.TAX_ROUNDING_ALLOW_OVERRIDE
, 'N')
, 'Y'
, NVL( BILL_SITE.TAX_HEADER_LEVEL_FLAG
, NVL( BC.TAX_HEADER_LEVEL_FLAG
, NVL( SYS.TAX_HEADER_LEVEL_FLAG
, 'N' )))
, NVL( SYS.TAX_HEADER_LEVEL_FLAG
, 'N' ))
, DECODE( NVL( SYS.TAX_ROUNDING_ALLOW_OVERRIDE
, 'N')
, 'Y'
, NVL( BILL_SITE.TAX_ROUNDING_RULE
, NVL( BC.TAX_ROUNDING_RULE
, NVL( SYS.TAX_ROUNDING_RULE
, 'NEAREST')))
, NVL( SYS.TAX_ROUNDING_RULE
, 'NEAREST' ))
, 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
, TO_NUMBER(NULL)
, NULL
, V.TAXABLE_BASIS
, V.TAX_CALCULATION_PLSQL_BLOCK
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(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
, RA_CUST_TRX_TYPES INV_TYPE
, AR_VAT_TAX TG
, AR_VAT_TAX V
, RA_CUSTOMERS SC
, RA_CUSTOMERS BC
, AR_SYSTEM_PARAMETERS SYS
, PER_ASSIGNMENTS_F ASGN
, RA_SALESREPS SALES
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 SHIP.CUSTOMER_ID = SC.CUSTOMER_ID (+)
AND BILL.CUSTOMER_ID = BC.CUSTOMER_ID (+)
AND Q.ORDER_TYPE_ID = SO.ORDER_TYPE_ID(+)
AND SO.CUST_TRX_TYPE_ID = INV_TYPE.CUST_TRX_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 Q.EMPLOYEE_PERSON_ID = SALES.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'))