[Home] [Help] [Dependency Information]

VIEW: APPS.AP_INVOICE_PAYMENTS_V

Object Details

Object Name:	AP_INVOICE_PAYMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.AP_INVOICE_PAYMENTS_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      ACCOUNTING_DATE
,      ACCRUAL_POSTED_FLAG
,      ACCTS_PAY_CODE_COMBINATION_ID
,      AMOUNT
,      ASSETS_ADDITION_FLAG
,      ASSET_CODE_COMBINATION_ID
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      BANK_ACCOUNT_NUM
,      BANK_ACCOUNT_TYPE
,      BANK_NUM
,      CASH_JE_BATCH_ID
,      CASH_POSTED_FLAG
,      CHECK_ID
,      CREATED_BY
,      CREATION_DATE
,      DISCOUNT_LOST
,      DISCOUNT_TAKEN
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      FUTURE_PAY_CODE_COMBINATION_ID
,      FUTURE_PAY_POSTED_FLAG
,      GAIN_CODE_COMBINATION_ID
,      INVOICE_BASE_AMOUNT
,      INVOICE_ID
,      INVOICE_PAYMENT_ID
,      JE_BATCH_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LOSS_CODE_COMBINATION_ID
,      PAYMENT_BASE_AMOUNT
,      PAYMENT_NUM
,      PERIOD_NAME
,      POSTED_FLAG
,      SET_OF_BOOKS_ID
,      INVOICE_PAYMENT_TYPE
,      OTHER_INVOICE_ID
,      CHECK_NUMBER
,      CHECK_DATE
,      CHECK_AMOUNT
,      CHECK_TYPE
,      CHECK_STATUS
,      PAYMENT_TYPE
,      INVOICE_NUM
,      INVOICE_DATE
,      INVOICE_AMOUNT
,      AMOUNT_PAID
,      DESCRIPTION
,      JE_BATCH_NAME
,      SET_OF_BOOKS_NAME
,      EXTERNAL_BANK_ACCOUNT_ID
,      APS_EXTERNAL_BANK_ACCOUNT_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      ORG_ID
,      PAYMENT_ID
,      REVERSAL_INV_PMT_ID
,      REVERSAL_FLAG
,      REMIT_TO_SUPPLIER_NAME
,      REMIT_TO_SUPPLIER_ID
,      REMIT_TO_SUPPLIER_SITE
,      REMIT_TO_SUPPLIER_SITE_ID
,      RELATIONSHIP_ID
FROM APPS.AP_INVOICE_PAYMENTS_V;

Dependencies

[top of page]

APPS

AP_CHECKS_ALL

AP_INVOICES_ALL

AP_INVOICE_PAYMENTS

AP_LOOKUP_CODES

AP_PAYMENT_SCHEDULES_ALL

FND_GLOBAL - show dependent code

GL_JE_BATCHES

GL_SETS_OF_BOOKS

IBY_PAYMENT_METHODS_VL

APPS

LNS_FUNDING_PUB - show dependent code