View: IBE_ORDER_QUOTE_PAY_TAX_V

View Text

SELECT PAY.PAYMENT_ID PAYPAYMENT_ID
, PAY.CREATION_DATE PAYCREATION_DATE
, PAY.CREATED_BY PAYCREATED_BY
, PAY.LAST_UPDATE_DATE PAYLAST_UPDATE_DATE
, PAY.LAST_UPDATED_BY PAYLAST_UPDATED_BY
, PAY.LAST_UPDATE_LOGIN PAYLAST_UPDATE_LOGIN
, PAY.REQUEST_ID PAYREQUEST_ID
, PAY.PROGRAM_APPLICATION_ID PAYPROGRAM_APPLICATION_ID
, PAY.PROGRAM_ID PAYPROGRAM_ID
, PAY.PROGRAM_UPDATE_DATE PAYPROGRAM_UPDATE_DATE
, PAY.QUOTE_HEADER_ID PAYQUOTE_HEADER_ID
, PAY.QUOTE_LINE_ID PAYQUOTE_LINE_ID
, PAY.PAYMENT_TYPE_CODE PAYPAYMENT_TYPE_CODE
, PAY.PAYMENT_REF_NUMBER PAYPAYMENT_REF_NUMBER
, PAY.PAYMENT_OPTION PAYPAYMENT_OPTION
, PAY.PAYMENT_TERM_ID PAYPAYMENT_TERM_ID
, PAY.CREDIT_CARD_CODE PAYCREDIT_CARD_CODE
, PAY.CREDIT_CARD_HOLDER_NAME PAYCREDIT_CARD_HOLDER_NAME
, PAY.CREDIT_CARD_EXPIRATION_DATE PAYCREDIT_CARD_EXPIRATION_DATE
, PAY.CREDIT_CARD_APPROVAL_CODE PAYCREDIT_CARD_APPROVAL_CODE
, PAY.CREDIT_CARD_APPROVAL_DATE PAYCREDIT_CARD_APPROVAL_DATE
, PAY.PAYMENT_AMOUNT PAYPAYMENT_AMOUNT
, PAY.ATTRIBUTE_CATEGORY PAYATTRIBUTE_CATEGORY
, PAY.ATTRIBUTE1 PAYATTRIBUTE1
, PAY.ATTRIBUTE2 PAYATTRIBUTE2
, PAY.ATTRIBUTE3 PAYATTRIBUTE3
, PAY.ATTRIBUTE4 PAYATTRIBUTE4
, PAY.ATTRIBUTE5 PAYATTRIBUTE5
, PAY.ATTRIBUTE6 PAYATTRIBUTE6
, PAY.ATTRIBUTE7 PAYATTRIBUTE7
, PAY.ATTRIBUTE8 PAYATTRIBUTE8
, PAY.ATTRIBUTE9 PAYATTRIBUTE9
, PAY.ATTRIBUTE10 PAYATTRIBUTE10
, PAY.ATTRIBUTE11 PAYATTRIBUTE11
, PAY.ATTRIBUTE12 PAYATTRIBUTE12
, PAY.ATTRIBUTE13 PAYATTRIBUTE13
, PAY.ATTRIBUTE14 PAYATTRIBUTE14
, PAY.ATTRIBUTE15 PAYATTRIBUTE15
, TAX.TAX_DETAIL_ID TAXTAX_DETAIL_ID
, TAX.CREATION_DATE TAXCREATION_DATE
, TAX.CREATED_BY TAXCREATED_BY
, TAX.LAST_UPDATE_DATE TAXLAST_UPDATE_DATE
, TAX.LAST_UPDATED_BY TAXLAST_UPDATED_BY
, TAX.LAST_UPDATE_LOGIN TAXLAST_UPDATE_LOGIN
, TAX.REQUEST_ID TAXREQUEST_ID
, TAX.PROGRAM_APPLICATION_ID TAXPROGRAM_APPLICATION_ID
, TAX.PROGRAM_ID TAXPROGRAM_ID
, TAX.PROGRAM_UPDATE_DATE TAXPROGRAM_UPDATE_DATE
, TAX.QUOTE_HEADER_ID TAXQUOTE_HEADER_ID
, TAX.QUOTE_LINE_ID TAXQUOTE_LINE_ID
, TAX.QUOTE_SHIPMENT_ID TAXQUOTE_SHIPMENT_ID
, TAX.ORIG_TAX_CODE TAXORIG_TAX_CODE
, TAX.TAX_CODE TAXTAX_CODE
, TAX.TAX_RATE TAXTAX_RATE
, TAX.TAX_DATE TAXTAX_DATE
, TAX.TAX_AMOUNT TAXTAX_AMOUNT
, TAX.TAX_EXEMPT_FLAG TAXTAX_EXEMPT_FLAG
, TAX.TAX_EXEMPT_NUMBER TAXTAX_EXEMPT_NUMBER
, TAX.TAX_EXEMPT_REASON_CODE TAXTAX_EXEMPT_REASON_CODE
, TAX.ATTRIBUTE_CATEGORY TAXATTRIBUTE_CATEGORY
, TAX.ATTRIBUTE1 TAXATTRIBUTE1
, TAX.ATTRIBUTE2 TAXATTRIBUTE2
, TAX.ATTRIBUTE3 TAXATTRIBUTE3
, TAX.ATTRIBUTE4 TAXATTRIBUTE4
, TAX.ATTRIBUTE5 TAXATTRIBUTE5
, TAX.ATTRIBUTE6 TAXATTRIBUTE6
, TAX.ATTRIBUTE7 TAXATTRIBUTE7
, TAX.ATTRIBUTE8 TAXATTRIBUTE8
, TAX.ATTRIBUTE9 TAXATTRIBUTE9
, TAX.ATTRIBUTE10 TAXATTRIBUTE10
, TAX.ATTRIBUTE11 TAXATTRIBUTE11
, TAX.ATTRIBUTE12 TAXATTRIBUTE12
, TAX.ATTRIBUTE13 TAXATTRIBUTE13
, TAX.ATTRIBUTE14 TAXATTRIBUTE14
, TAX.ATTRIBUTE15 TAXATTRIBUTE15
FROM ASO_QUOTE_HEADERS HDR
, ASO_PAYMENTS PAY
, ASO_TAX_DETAILS TAX
WHERE PAY.QUOTE_LINE_ID IS NULL
AND PAY.QUOTE_HEADER_ID (+) = HDR.QUOTE_HEADER_ID AND TAX.QUOTE_LINE_ID IS NULL
AND TAX.QUOTE_HEADER_ID (+) = HDR.QUOTE_HEADER_ID

Columns