VIEW: APPS.JL_BR_AP_INVOICES_SHIP_V

Source

View Text - Preformatted

SELECT APIN.ROWID , APIN.INVOICE_ID , APIN.LAST_UPDATE_DATE , APIN.LAST_UPDATED_BY , APIN.VENDOR_ID , APIN.INVOICE_NUM , APIN.SET_OF_BOOKS_ID , APIN.INVOICE_CURRENCY_CODE , APIN.PAYMENT_CURRENCY_CODE , APIN.PAYMENT_CROSS_RATE , APIN.INVOICE_AMOUNT , APIN.VENDOR_SITE_ID , APIN.AMOUNT_PAID , APIN.DISCOUNT_AMOUNT_TAKEN , APIN.INVOICE_DATE , APIN.SOURCE , APIN.INVOICE_TYPE_LOOKUP_CODE , APIN.DESCRIPTION , APIN.BATCH_ID , APIN.AMOUNT_APPLICABLE_TO_DISCOUNT , APIN.TAX_AMOUNT , APIN.TERMS_ID , APIN.TERMS_DATE , APIN.PAYMENT_METHOD_LOOKUP_CODE , APIN.PAY_GROUP_LOOKUP_CODE , APIN.ACCTS_PAY_CODE_COMBINATION_ID , APIN.PAYMENT_STATUS_FLAG , APIN.CREATION_DATE , APIN.CREATED_BY , APIN.BASE_AMOUNT , APIN.VAT_CODE , APIN.LAST_UPDATE_LOGIN , APIN.EXCLUSIVE_PAYMENT_FLAG , APIN.PO_HEADER_ID , APIN.FREIGHT_AMOUNT , APIN.GOODS_RECEIVED_DATE , APIN.INVOICE_RECEIVED_DATE , APIN.VOUCHER_NUM , APIN.APPROVED_AMOUNT , APIN.RECURRING_PAYMENT_ID , APIN.EXCHANGE_RATE , APIN.EXCHANGE_RATE_TYPE , APIN.EXCHANGE_DATE , APIN.EARLIEST_SETTLEMENT_DATE , APIN.ORIGINAL_PREPAYMENT_AMOUNT , APIN.DOC_SEQUENCE_ID , APIN.DOC_SEQUENCE_VALUE , APIN.DOC_CATEGORY_CODE , APIN.ATTRIBUTE1 , APIN.ATTRIBUTE2 , APIN.ATTRIBUTE3 , APIN.ATTRIBUTE4 , APIN.ATTRIBUTE5 , APIN.ATTRIBUTE6 , APIN.ATTRIBUTE7 , APIN.ATTRIBUTE8 , APIN.ATTRIBUTE9 , APIN.ATTRIBUTE10 , APIN.ATTRIBUTE11 , APIN.ATTRIBUTE12 , APIN.ATTRIBUTE13 , APIN.ATTRIBUTE14 , APIN.ATTRIBUTE15 , APIN.ATTRIBUTE_CATEGORY , APIN.APPROVAL_STATUS , APIN.APPROVAL_DESCRIPTION , APIN.POSTING_STATUS , APIN.AUTHORIZED_BY , APIN.CANCELLED_DATE , APIN.CANCELLED_BY , APIN.CANCELLED_AMOUNT , APIN.TEMP_CANCELLED_AMOUNT , APIN.USSGL_TRANSACTION_CODE , APIN.USSGL_TRX_CODE_CONTEXT , APIN.PROJECT_ID , APIN.TASK_ID , APIN.EXPENDITURE_TYPE , APIN.EXPENDITURE_ITEM_DATE , APIN.PA_QUANTITY , APIN.EXPENDITURE_ORGANIZATION_ID , APIN.PA_DEFAULT_DIST_CCID , APIN.VENDOR_PREPAY_AMOUNT , APIN.PAYMENT_AMOUNT_TOTAL , APIN.AWT_FLAG , APIN.AWT_GROUP_ID , APIN.REFERENCE_1 , APIN.REFERENCE_2 , APIN.ORG_ID , APIN.PRE_WITHHOLDING_AMOUNT , APIN.GLOBAL_ATTRIBUTE_CATEGORY , APIN.GLOBAL_ATTRIBUTE1 , APIN.GLOBAL_ATTRIBUTE2 , APIN.GLOBAL_ATTRIBUTE3 , APIN.GLOBAL_ATTRIBUTE4 , APIN.GLOBAL_ATTRIBUTE5 , APIN.GLOBAL_ATTRIBUTE6 , APIN.GLOBAL_ATTRIBUTE7 , APIN.GLOBAL_ATTRIBUTE8 , APIN.GLOBAL_ATTRIBUTE9 , APIN.GLOBAL_ATTRIBUTE10 , APIN.GLOBAL_ATTRIBUTE11 , APIN.GLOBAL_ATTRIBUTE12 , APIN.GLOBAL_ATTRIBUTE13 , APIN.GLOBAL_ATTRIBUTE14 , APIN.GLOBAL_ATTRIBUTE15 , APIN.GLOBAL_ATTRIBUTE16 , APIN.GLOBAL_ATTRIBUTE17 , APIN.GLOBAL_ATTRIBUTE18 , APIN.GLOBAL_ATTRIBUTE19 , APIN.GLOBAL_ATTRIBUTE20 , APIN.AUTO_TAX_CALC_FLAG , APT.NAME FROM AP_INVOICES APIN, AP_TERMS APT WHERE APT.TERM_ID (+) = APIN.TERMS_ID

View Text - HTML Formatted

SELECT APIN.ROWID
, APIN.INVOICE_ID
, APIN.LAST_UPDATE_DATE
, APIN.LAST_UPDATED_BY
, APIN.VENDOR_ID
, APIN.INVOICE_NUM
, APIN.SET_OF_BOOKS_ID
, APIN.INVOICE_CURRENCY_CODE
, APIN.PAYMENT_CURRENCY_CODE
, APIN.PAYMENT_CROSS_RATE
, APIN.INVOICE_AMOUNT
, APIN.VENDOR_SITE_ID
, APIN.AMOUNT_PAID
, APIN.DISCOUNT_AMOUNT_TAKEN
, APIN.INVOICE_DATE
, APIN.SOURCE
, APIN.INVOICE_TYPE_LOOKUP_CODE
, APIN.DESCRIPTION
, APIN.BATCH_ID
, APIN.AMOUNT_APPLICABLE_TO_DISCOUNT
, APIN.TAX_AMOUNT
, APIN.TERMS_ID
, APIN.TERMS_DATE
, APIN.PAYMENT_METHOD_LOOKUP_CODE
, APIN.PAY_GROUP_LOOKUP_CODE
, APIN.ACCTS_PAY_CODE_COMBINATION_ID
, APIN.PAYMENT_STATUS_FLAG
, APIN.CREATION_DATE
, APIN.CREATED_BY
, APIN.BASE_AMOUNT
, APIN.VAT_CODE
, APIN.LAST_UPDATE_LOGIN
, APIN.EXCLUSIVE_PAYMENT_FLAG
, APIN.PO_HEADER_ID
, APIN.FREIGHT_AMOUNT
, APIN.GOODS_RECEIVED_DATE
, APIN.INVOICE_RECEIVED_DATE
, APIN.VOUCHER_NUM
, APIN.APPROVED_AMOUNT
, APIN.RECURRING_PAYMENT_ID
, APIN.EXCHANGE_RATE
, APIN.EXCHANGE_RATE_TYPE
, APIN.EXCHANGE_DATE
, APIN.EARLIEST_SETTLEMENT_DATE
, APIN.ORIGINAL_PREPAYMENT_AMOUNT
, APIN.DOC_SEQUENCE_ID
, APIN.DOC_SEQUENCE_VALUE
, APIN.DOC_CATEGORY_CODE
, APIN.ATTRIBUTE1
, APIN.ATTRIBUTE2
, APIN.ATTRIBUTE3
, APIN.ATTRIBUTE4
, APIN.ATTRIBUTE5
, APIN.ATTRIBUTE6
, APIN.ATTRIBUTE7
, APIN.ATTRIBUTE8
, APIN.ATTRIBUTE9
, APIN.ATTRIBUTE10
, APIN.ATTRIBUTE11
, APIN.ATTRIBUTE12
, APIN.ATTRIBUTE13
, APIN.ATTRIBUTE14
, APIN.ATTRIBUTE15
, APIN.ATTRIBUTE_CATEGORY
, APIN.APPROVAL_STATUS
, APIN.APPROVAL_DESCRIPTION
, APIN.POSTING_STATUS
, APIN.AUTHORIZED_BY
, APIN.CANCELLED_DATE
, APIN.CANCELLED_BY
, APIN.CANCELLED_AMOUNT
, APIN.TEMP_CANCELLED_AMOUNT
, APIN.USSGL_TRANSACTION_CODE
, APIN.USSGL_TRX_CODE_CONTEXT
, APIN.PROJECT_ID
, APIN.TASK_ID
, APIN.EXPENDITURE_TYPE
, APIN.EXPENDITURE_ITEM_DATE
, APIN.PA_QUANTITY
, APIN.EXPENDITURE_ORGANIZATION_ID
, APIN.PA_DEFAULT_DIST_CCID
, APIN.VENDOR_PREPAY_AMOUNT
, APIN.PAYMENT_AMOUNT_TOTAL
, APIN.AWT_FLAG
, APIN.AWT_GROUP_ID
, APIN.REFERENCE_1
, APIN.REFERENCE_2
, APIN.ORG_ID
, APIN.PRE_WITHHOLDING_AMOUNT
, APIN.GLOBAL_ATTRIBUTE_CATEGORY
, APIN.GLOBAL_ATTRIBUTE1
, APIN.GLOBAL_ATTRIBUTE2
, APIN.GLOBAL_ATTRIBUTE3
, APIN.GLOBAL_ATTRIBUTE4
, APIN.GLOBAL_ATTRIBUTE5
, APIN.GLOBAL_ATTRIBUTE6
, APIN.GLOBAL_ATTRIBUTE7
, APIN.GLOBAL_ATTRIBUTE8
, APIN.GLOBAL_ATTRIBUTE9
, APIN.GLOBAL_ATTRIBUTE10
, APIN.GLOBAL_ATTRIBUTE11
, APIN.GLOBAL_ATTRIBUTE12
, APIN.GLOBAL_ATTRIBUTE13
, APIN.GLOBAL_ATTRIBUTE14
, APIN.GLOBAL_ATTRIBUTE15
, APIN.GLOBAL_ATTRIBUTE16
, APIN.GLOBAL_ATTRIBUTE17
, APIN.GLOBAL_ATTRIBUTE18
, APIN.GLOBAL_ATTRIBUTE19
, APIN.GLOBAL_ATTRIBUTE20
, APIN.AUTO_TAX_CALC_FLAG
, APT.NAME
FROM AP_INVOICES APIN
, AP_TERMS APT
WHERE APT.TERM_ID (+) = APIN.TERMS_ID