View: TAX_ADJUSTMENTS_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
, L.ADJUSTMENT_ID TRX_LINE_ID
, L.ADJUSTMENT_ID TRX_HEADER_ID
, TO_NUMBER(NULL) TRX_LINK_TO_CUST_TRX_LINE_ID
, L.APPLY_DATE TRX_DATE
, L.GL_DATE GL_DATE
, NULL TAX_CODE
, NULL TAX_RATE
, L.TAX_ADJUSTED 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
, TO_NUMBER(NULL) INVENTORY_ITEM_ID
, TO_NUMBER(NULL) MEMO_LINE_ID
, NULL TAX_EXEMPT_FLAG
, NULL TAX_EXEMPT_NUMBER
, NULL 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
, NULL 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
, NULL USSGL_TRANSACTION_CODE
, NULL USSGL_TRX_CODE_CONTEXT
, NULL REQUEST_ID
, ARP_TAX_VIEW_TAXWARE.POO_ADDRESS_CODE( 'TAX_ADJUSTMENTS_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID
, H.PRIMARY_SALESREP_ID) POO_ADDRESS_CODE
, ARP_TAX_VIEW_TAXWARE.POA_ADDRESS_CODE( 'TAX_ADJUSTMENTS_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) POA_ADDRESS_CODE
, ARP_TAX_VIEW_TAXWARE.SHIP_FROM_ADDRESS_CODE( 'TAX_ADJUSTMENTS_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID
, NULL) SHIP_FROM_ADDRESS_CODE
, NULL SHIP_TO_ADDRESS_CODE
, H.FOB_POINT FOB_CODE
, NULL TAXED_QUANTITY
, NULL PART_NUMBER
, NULL TAX_LINE_NUMBER
, 'ALL' LOCATION_QUALIFIER
, 'Y' TAXABLE_FLAG
, NULL COMPOUNDING_PRECEDENCE
, NULL TAX_EXEMPTION_ID
, NULL TAX_EXCEPTION_ID
, ARP_TAX_VIEW_TAXWARE.VENDOR_CONTROL_EXEMPTIONS( 'TAX_ADJUSTMENTS_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID
, T.CUST_TRX_TYPE_ID) VENDOR_CONTROL_EXEMPTIONS
, ARP_TAX_VIEW_TAXWARE.CALCULATION_FLAG( 'TAX_ADJUSTMENTS_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) ATTRIBUTE1
, ARP_TAX_VIEW_TAXWARE.USE_NEXPRO( 'TAX_ADJUSTMENTS_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_ADJUSTMENTS_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) NUMERIC_ATTRIBUTE1
, ARP_TAX_VIEW_TAXWARE.TAX_SEL_PARM( 'TAX_ADJUSTMENTS_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) NUMERIC_ATTRIBUTE2
, ARP_TAX_VIEW_TAXWARE.TAX_TYPE( 'TAX_ADJUSTMENTS_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) NUMERIC_ATTRIBUTE3
, ARP_TAX_VIEW_TAXWARE.SERVICE_INDICATOR( 'TAX_ADJUSTMENTS_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) NUMERIC_ATTRIBUTE4
, NULL NUMERIC_ATTRIBUTE5
, L.ADJUSTMENT_NUMBER TRX_NUMBER
, NULL SHIP_TO_CUSTOMER_NUMBER
, NULL SHIP_TO_CUSTOMER_NAME
, NULL BILL_TO_CUSTOMER_NUMBER
, NULL BILL_TO_CUSTOMER_NAME
, NULL PREVIOUS_TRX_LINE_ID
, NULL PREVIOUS_TRX_HEADER_ID
, NULL PREVIOUS_TRX_NUMBER
, ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG( 'TAX_ADJUSTMENTS_V_A'
, L.ADJUSTMENT_ID
, L.ADJUSTMENT_ID) AUDIT_FLAG
, 'ADJ' TRX_LINE_TYPE
, ARP_TAX_VIEW_TAXWARE.DIVISION_CODE( 'TAX_ADJUSTMENTS_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) DIVISION_CODE
, ARP_TAX_VIEW_TAXWARE.COMPANY_CODE( 'TAX_ADJUSTMENTS_V_A'
, H.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) COMPANY_CODE
, NULL TAX_HEADER_LEVEL_FLAG
, NULL TAX_ROUNDING_RULE
, TO_NUMBER(NULL) VAT_TAX_ID
, H.CUST_TRX_TYPE_ID TRX_TYPE_ID
, 'N' AMOUNT_INCLUDES_TAX_FLAG
, NULL 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
, NULL PAYMENT_TERMS_DISCOUNT_PERCENT
, NULL TAXABLE_BASIS
, NULL TAX_CALCULATION_PLSQL_BLOCK
, NULL ATTRIBUTE6
, NULL ATTRIBUTE7
, NULL ATTRIBUTE8
, NULL ATTRIBUTE9
, NULL ATTRIBUTE10
, NULL NUMERIC_ATTRIBUTE6
, NULL NUMERIC_ATTRIBUTE7
, NULL NUMERIC_ATTRIBUTE8
, NULL NUMERIC_ATTRIBUTE9
, NULL NUMERIC_ATTRIBUTE10
FROM AR_ADJUSTMENTS L
, RA_CUSTOMER_TRX H
, FND_CURRENCIES C
, RA_CUST_TRX_TYPES T
, RA_SALESREPS SALES
WHERE H.CUST_TRX_TYPE_ID = T.CUST_TRX_TYPE_ID
AND L.CUSTOMER_TRX_ID = H.CUSTOMER_TRX_ID
AND H.INVOICE_CURRENCY_CODE = C.CURRENCY_CODE
AND L.TYPE = 'TAX'
AND L.STATUS = 'A'
AND H.PRIMARY_SALESREP_ID = SALES.SALESREP_ID (+)

Columns