View: TAX_LINES_DELETE_V_A

View Text

SELECT H.SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, H.BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID
, TO_NUMBER(NULL) TRX_CHARGE_LINE_ID
, T.CUSTOMER_TRX_LINE_ID TRX_LINE_ID
, H.CUSTOMER_TRX_ID TRX_HEADER_ID
, T.LINK_TO_CUST_TRX_LINE_ID TRX_LINK_TO_CUST_TRX_LINE_ID
, H.TRX_DATE TRX_DATE
, D.GL_DATE GL_DATE
, V.TAX_CODE TAX_CODE
, T.TAX_RATE TAX_RATE
, T.EXTENDED_AMOUNT * -1 TAX_AMOUNT
, H.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, H.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, NULL SHIP_TO_POSTAL_CODE
, NULL BILL_TO_POSTAL_CODE
, L.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, L.MEMO_LINE_ID MEMO_LINE_ID
, L.TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, L.TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, L.TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, TO_NUMBER(NULL) SHIP_TO_LOCATION_CCID
, TO_NUMBER(NULL) BILL_TO_LOCATION_CCID
, H.INVOICING_RULE_ID INVOICING_RULE_ID
, L.EXTENDED_AMOUNT * -1 EXTENDED_AMOUNT
, H.EXCHANGE_RATE EXCHANGE_RATE
, H.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, C.CURRENCY_CODE CURRENCY_CODE
, C.MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT
, C.PRECISION PRECISION
, L.DEFAULT_USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, L.DEFAULT_USSGL_TRX_CODE_CONTEXT USSGL_TRX_CODE_CONTEXT
, NULL REQUEST_ID
, NVL(T.GLOBAL_ATTRIBUTE11
, ARP_TAX_VIEW_TAXWARE.POO_ADDRESS_CODE( 'TAX_LINES_DELETE_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID
, H.PRIMARY_SALESREP_ID)) POO_ADDRESS_CODE
, NVL(T.GLOBAL_ATTRIBUTE10
, ARP_TAX_VIEW_TAXWARE.POA_ADDRESS_CODE( 'TAX_LINES_DELETE_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID)) POA_ADDRESS_CODE
, NVL(T.GLOBAL_ATTRIBUTE9
, ARP_TAX_VIEW_TAXWARE.SHIP_FROM_ADDRESS_CODE( 'TAX_LINES_DELETE_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID
, L.WAREHOUSE_ID)) SHIP_FROM_ADDRESS_CODE
, T.GLOBAL_ATTRIBUTE8 SHIP_TO_ADDRESS_CODE
, H.FOB_POINT FOB_CODE
, L.QUANTITY_INVOICED TAXED_QUANTITY
, ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE( 'TAX_LINES_DELETE_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID
, L.INVENTORY_ITEM_ID
, L.MEMO_LINE_ID) PART_NUMBER
, NULL TAX_LINE_NUMBER
, 'ALL' LOCATION_QUALIFIER
, 'Y' TAXABLE_FLAG
, NULL COMPOUNDING_PRECEDENCE
, T.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
, NULL TAX_EXCEPTION_ID
, ARP_TAX_VIEW_TAXWARE.VENDOR_CONTROL_EXEMPTIONS( 'TAX_LINES_DELETE_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID
, TY.CUST_TRX_TYPE_ID) VENDOR_CONTROL_EXEMPTIONS
, ARP_TAX_VIEW_TAXWARE.CALCULATION_FLAG( 'TAX_LINES_DELETE_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) ATTRIBUTE1
, ARP_TAX_VIEW_TAXWARE.USE_NEXPRO( 'TAX_LINES_DELETE_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
, ARP_TAX_VIEW_TAXWARE.USE_SECONDARY( 'TAX_LINES_DELETE_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) NUMERIC_ATTRIBUTE1
, ARP_TAX_VIEW_TAXWARE.TAX_SEL_PARM( 'TAX_LINES_DELETE_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) NUMERIC_ATTRIBUTE2
, ARP_TAX_VIEW_TAXWARE.TAX_TYPE( 'TAX_LINES_DELETE_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) NUMERIC_ATTRIBUTE3
, ARP_TAX_VIEW_TAXWARE.SERVICE_INDICATOR( 'TAX_LINES_DELETE_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) NUMERIC_ATTRIBUTE4
, NULL NUMERIC_ATTRIBUTE5
, H.TRX_NUMBER TRX_NUMBER
, NULL SHIP_TO_CUSTOMER_NUMBER
, NULL SHIP_TO_CUSTOMER_NAME
, NULL BILL_TO_CUSTOMER_NUMBER
, NULL BILL_TO_CUSTOMER_NAME
, L.PREVIOUS_CUSTOMER_TRX_LINE_ID PREVIOUS_TRX_LINE_ID
, L.PREVIOUS_CUSTOMER_TRX_ID PREVIOUS_TRX_HEADER_ID
, P.TRX_NUMBER PREVIOUS_TRX_NUMBER
, 'Y' AUDIT_FLAG
, NULL TRX_LINE_TYPE
, ARP_TAX_VIEW_TAXWARE.DIVISION_CODE( 'TAX_LINES_DELETE_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) DIVISION_CODE
, ARP_TAX_VIEW_TAXWARE.COMPANY_CODE( 'TAX_LINES_DELETE_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) COMPANY_CODE
, NULL TAX_HEADER_LEVEL_FLAG
, NULL TAX_ROUNDING_RULE
, V.VAT_TAX_ID VAT_TAX_ID
, H.CUST_TRX_TYPE_ID TRX_TYPE_ID
, NVL(L.AMOUNT_INCLUDES_TAX_FLAG
, V.AMOUNT_INCLUDES_TAX_FLAG) AMOUNT_INCLUDES_TAX_FLAG
, L.WAREHOUSE_ID SHIP_FROM_WAREHOUSE_ID
, DECODE(SALES.PERSON_ID
, NULL
, H.ORG_ID
, ARP_TAX.AR_TAX_SALESREP_LOC(SALES.PERSON_ID
, H.TRX_DATE)) POO_ID
, H.ORG_ID POA_ID
, H.TERM_ID PAYMENT_TERM_ID
, TO_NUMBER(NULL) PAYMENT_TERMS_DISCOUNT_PERCENT
, V.TAXABLE_BASIS TAXABLE_BASIS
, V.TAX_CALCULATION_PLSQL_BLOCK TAX_CALCULATION_PLSQL_BLOCK
, NULL ATTRIBUTE6
, NULL ATTRIBUTE7
, NULL ATTRIBUTE8
, NULL ATTRIBUTE9
, NULL ATTRIBUTE10
, TO_NUMBER(NULL) NUMERIC_ATTRIBUTE6
, TO_NUMBER(NULL) NUMERIC_ATTRIBUTE7
, TO_NUMBER(NULL) NUMERIC_ATTRIBUTE8
, TO_NUMBER(NULL) NUMERIC_ATTRIBUTE9
, TO_NUMBER(NULL) NUMERIC_ATTRIBUTE10
FROM RA_CUSTOMER_TRX_LINES L
, RA_CUSTOMER_TRX_LINES T
, RA_CUSTOMER_TRX H
, RA_CUST_TRX_LINE_GL_DIST D
, FND_CURRENCIES C
, RA_CUST_TRX_TYPES TY
, AR_VAT_TAX V
, RA_CUSTOMER_TRX P
, AR_MEMO_LINES ML
, RA_SALESREPS SALES
WHERE H.CUST_TRX_TYPE_ID = TY.CUST_TRX_TYPE_ID
AND L.CUSTOMER_TRX_ID = H.CUSTOMER_TRX_ID
AND H.INVOICE_CURRENCY_CODE = C.CURRENCY_CODE
AND H.CUSTOMER_TRX_ID = D.CUSTOMER_TRX_ID(+)
AND D.ACCOUNT_CLASS(+) = 'REC'
AND D.LATEST_REC_FLAG(+) = 'Y'
AND T.VAT_TAX_ID = V.VAT_TAX_ID(+)
AND L.PREVIOUS_CUSTOMER_TRX_ID = P.CUSTOMER_TRX_ID(+)
AND T.LINK_TO_CUST_TRX_LINE_ID = L.CUSTOMER_TRX_LINE_ID
AND T.LINE_TYPE = 'TAX'
AND L.LINE_TYPE = 'LINE'
AND L.MEMO_LINE_ID = ML.MEMO_LINE_ID(+)
AND ML.LINE_TYPE(+) = 'LINE'
AND H.PRIMARY_SALESREP_ID = SALES.SALESREP_ID (+)

Columns