View: JL_BR_AP_INVOICES_SHIP_V

Product:	JL - Latin America Localizations
Description:	- Retrofitted
Implementation/DBA Data:	APPS.JL_BR_AP_INVOICES_SHIP_V

View Text

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

Columns