View: SO_TAX_LINES_CREDIT_CHECK_V_A

View Text

SELECT A_SHIP.CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, A_BILL.CUSTOMER_ID BILL_TO_CUSTOMER_ID
, NULL TRX_CHARGE_LINE_ID
, L.LINE_ID TRX_LINE_ID
, H.HEADER_ID TRX_HEADER_ID
, NULL TRX_LINK_TO_CUST_TRX_LINE_ID
, NVL(L.SCHEDULE_DATE
, NVL(L.DATE_REQUESTED_CURRENT
, NVL(L.PROMISE_DATE
, SYSDATE) ) ) TRX_DATE
, NULL GL_DATE
, V.TAX_CODE TAX_CODE
, V.TAX_RATE TAX_RATE
, NULL TAX_AMOUNT
, S_SHIP.SITE_USE_ID SHIP_TO_SITE_USE_ID
, S_BILL.SITE_USE_ID BILL_TO_SITE_USE_ID
, A_SHIP.POSTAL_CODE SHIP_TO_POSTAL_CODE
, A_BILL.POSTAL_CODE BILL_TO_POSTAL_CODE
, L.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, NULL MEMO_LINE_ID
, H.TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, H.TAX_EXEMPT_NUM TAX_EXEMPT_NUMBER
, H.TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, A_SHIP.LOCATION_ID SHIP_TO_LOCATION_CCID
, A_BILL.LOCATION_ID BILL_TO_LOCATION_CCID
, H.INVOICING_RULE_ID INVOICING_RULE_ID
, (NVL(L.ORDERED_QUANTITY
, 0) - NVL(L.CANCELLED_QUANTITY
, 0) - NVL(L.INVOICED_QUANTITY
, 0)) * NVL(L.SELLING_PRICE
, 0) EXTENDED_AMOUNT
, H.CONVERSION_RATE EXCHANGE_RATE
, NULL SET_OF_BOOKS_ID
, C.CURRENCY_CODE TRX_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( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID
, H.SALESREP_ID) POO_ADDRESS_CODE
, ARP_TAX_VIEW_TAXWARE.POA_ADDRESS_CODE( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID) POA_ADDRESS_CODE
, ARP_TAX_VIEW_TAXWARE.SHIP_FROM_ADDRESS_CODE( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID
, NVL(L.WAREHOUSE_ID
, H.WAREHOUSE_ID)) SHIP_FROM_ADDRESS_CODE
, ARP_TAX_VIEW_TAXWARE.SHIP_TO_ADDRESS_CODE( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID
, NVL(A_SHIP.ADDRESS_ID
, A_BILL.ADDRESS_ID)
, NVL(A_SHIP.LOCATION_ID
, A_BILL.LOCATION_ID)
, NVL( L.SCHEDULE_DATE
, NVL( L.DATE_REQUESTED_CURRENT
, NVL( L.PROMISE_DATE
, SYSDATE ) ) )
, NVL(A_SHIP.STATE
, A_BILL.STATE)
, NVL(A_SHIP.POSTAL_CODE
, A_BILL.POSTAL_CODE)) SHIP_TO_ADDRESS_CODE
, H.FOB_CODE FOB_CODE
, NVL(L.ORDERED_QUANTITY
, 0) - NVL(L.CANCELLED_QUANTITY
, 0) - NVL(L.INVOICED_QUANTITY
, 0) TAXED_QUANTITY
, ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID
, L.INVENTORY_ITEM_ID
, NULL) PART_NUMBER
, NULL TAX_LINE_NUMBER
, AL.LOOKUP_CODE LOCATION_QUALIFIER
, DECODE(INV_TYPE.TAX_CALCULATION_FLAG
, 'Y'
, 'Y'
, DECODE(H.TAX_EXEMPT_FLAG
, 'R'
, 'Y'
, 'N')) TAXABLE_FLAG
, TO_NUMBER(NULL) COMPOUNDING_PRECEDENCE
, NULL TAX_EXEMPTION_ID
, NULL TAX_EXCEPTION_ID
, ARP_TAX_VIEW_TAXWARE.VENDOR_CONTROL_EXEMPTIONS( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID
, INV_TYPE.CUST_TRX_TYPE_ID) VENDOR_CONTROL_EXEMPTIONS
, ARP_TAX_VIEW_TAXWARE.CALCULATION_FLAG( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID) ATTRIBUTE1
, ARP_TAX_VIEW_TAXWARE.USE_NEXPRO( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID) ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
, ARP_TAX_VIEW_TAXWARE.USE_SECONDARY( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID) NUMERIC_ATTRIBUTE1
, ARP_TAX_VIEW_TAXWARE.TAX_SEL_PARM( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID) NUMERIC_ATTRIBUTE2
, ARP_TAX_VIEW_TAXWARE.TAX_TYPE( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID) NUMERIC_ATTRIBUTE3
, ARP_TAX_VIEW_TAXWARE.SERVICE_INDICATOR( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID) NUMERIC_ATTRIBUTE4
, NULL NUMERIC_ATTRIBUTE5
, NULL TRX_NUMBER
, 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 PREVIOUS_TRX_LINE_ID
, NULL PREVIOUS_TRX_HEADER_ID
, NULL PREVIOUS_TRX_NUMBER
, 'N' AUDIT_FLAG
, NULL TRX_LINE_TYPE
, ARP_TAX_VIEW_TAXWARE.DIVISION_CODE( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID) DIVISION_CODE
, ARP_TAX_VIEW_TAXWARE.COMPANY_CODE( 'SO_TAX_LINES_CREDIT_CHECK_V_A'
, H.HEADER_ID
, L.LINE_ID) COMPANY_CODE
, DECODE( NVL(SYS.TAX_ROUNDING_ALLOW_OVERRIDE
, 'N')
, 'Y'
, NVL( S_BILL.TAX_HEADER_LEVEL_FLAG
, NVL( BC.TAX_HEADER_LEVEL_FLAG
, NVL( SYS.TAX_HEADER_LEVEL_FLAG
, 'N' )))
, NVL( SYS.TAX_HEADER_LEVEL_FLAG
, 'N' )) TAX_HEADER_LEVEL_FLAG
, DECODE( NVL( SYS.TAX_ROUNDING_ALLOW_OVERRIDE
, 'N')
, 'Y'
, NVL( S_BILL.TAX_ROUNDING_RULE
, NVL( BC.TAX_ROUNDING_RULE
, NVL( SYS.TAX_ROUNDING_RULE
, 'NEAREST')))
, NVL( SYS.TAX_ROUNDING_RULE
, 'NEAREST' )) TAX_ROUNDING_RULE
, TO_NUMBER(NULL) VAT_TAX_ID
, NULL TRX_TYPE_ID
, V.AMOUNT_INCLUDES_TAX_FLAG AMOUNT_INCLUDES_TAX_FLAG
, L.WAREHOUSE_ID SHIP_FROM_WAREHOUSE_ID
, DECODE(SALES.PERSON_ID
, NULL
, H.ORG_ID
, ASGN.ORGANIZATION_ID) POO_ID
, H.ORG_ID POA_ID
, H.TERMS_ID PAYMENT_TERM_ID
, 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
, NULL NUMERIC_ATTRIBUTE6
, NULL NUMERIC_ATTRIBUTE7
, NULL NUMERIC_ATTRIBUTE8
, NULL NUMERIC_ATTRIBUTE9
, NULL NUMERIC_ATTRIBUTE10
FROM SO_LINES L
, SO_HEADERS H
, FND_CURRENCIES C
, RA_ADDRESSES A_SHIP
, RA_ADDRESSES A_BILL
, RA_SITE_USES S_SHIP
, RA_SITE_USES S_BILL
, SO_ORDER_TYPES ORD_TYPE
, RA_CUST_TRX_TYPES INV_TYPE
, AR_VAT_TAX V
, AR_SYSTEM_PARAMETERS SYS
, RA_CUSTOMERS BC
, RA_CUSTOMERS SC
, AR_LOOKUPS AL
, RA_SALESREPS SALES
, PER_ASSIGNMENTS_F ASGN
WHERE L.HEADER_ID = H.HEADER_ID
AND NVL(H.OPEN_FLAG
, 'N') = 'Y'
AND C.CURRENCY_CODE = H.CURRENCY_CODE
AND L.LINE_TYPE_CODE IN ('REGULAR'
, 'DETAIL')
AND S_SHIP.SITE_USE_ID (+) = L.SHIP_TO_SITE_USE_ID
AND A_SHIP.ADDRESS_ID (+) = S_SHIP.ADDRESS_ID
AND SC.CUSTOMER_ID(+) = A_SHIP.CUSTOMER_ID
AND S_BILL.SITE_USE_ID (+) = H.INVOICE_TO_SITE_USE_ID
AND A_BILL.ADDRESS_ID (+) = S_BILL.ADDRESS_ID
AND BC.CUSTOMER_ID(+) = A_BILL.CUSTOMER_ID
AND H.ORDER_TYPE_ID = ORD_TYPE.ORDER_TYPE_ID
AND ORD_TYPE.CUST_TRX_TYPE_ID = INV_TYPE.CUST_TRX_TYPE_ID
AND DECODE(L.S5
, 5
, 1
, 18
, 1
, NULL
, 1
, 0) = 1
AND NVL(L.SELLING_PRICE
, 0) != 0
AND (NVL(L.ORDERED_QUANTITY
, 0) - NVL(L.CANCELLED_QUANTITY
, 0) - NVL(L.INVOICED_QUANTITY
, 0)) != 0
AND L.TAX_CODE = V.TAX_CODE(+)
AND NVL( L.SCHEDULE_DATE
, NVL( L.DATE_REQUESTED_CURRENT
, NVL( L.PROMISE_DATE
, SYSDATE ) ) ) BETWEEN NVL(V.START_DATE
, TO_DATE( '01011900'
, 'DDMMYYYY'))
AND NVL(V.END_DATE
, TO_DATE( '31122199'
, 'DDMMYYYY'))
AND AL.LOOKUP_TYPE = 'ARTAXVDR_LOC_QUALIFIER'
AND ((AL.ENABLED_FLAG = 'Y'
AND V.TAX_TYPE = 'LOCATION'
AND ARP_PROCESS_TAX.VENDOR_INSTALLED_FLAG = 'Y') OR (AL.LOOKUP_CODE = 'ALL'
AND (NVL(V.TAX_TYPE
, 'VAT') != 'LOCATION' OR ARP_PROCESS_TAX.VENDOR_INSTALLED_FLAG != 'Y')))
AND SYSDATE BETWEEN NVL(AL.START_DATE_ACTIVE
, SYSDATE)
AND NVL(AL.END_DATE_ACTIVE
, SYSDATE)
AND H.SALESREP_ID = SALES.SALESREP_ID (+)
AND SALES.PERSON_ID = ASGN.PERSON_ID (+)
AND NVL(ASGN.PRIMARY_FLAG
, 'Y') = 'Y'
AND NVL(L.SCHEDULE_DATE
, NVL( L.DATE_REQUESTED_CURRENT
, NVL( L.PROMISE_DATE
, SYSDATE))) BETWEEN NVL(ASGN.EFFECTIVE_START_DATE
, TO_DATE( '01011900'
, 'DDMMYYYY'))
AND NVL(ASGN.EFFECTIVE_END_DATE
, TO_DATE( '31122199'
, 'DDMMYYYY'))
AND NVL(V.ENABLED_FLAG
, 'Y')='Y'

Columns