[Home] [Help] [Dependency Information]

VIEW: APPS.AP_DOCUMENTS_PAYABLE

Object Details

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

[View Source]

Columns

Query Text

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

SELECT PAY_PROC_TRXN_TYPE_CODE
,      CALLING_APP_ID
,      CALLING_APP_DOC_UNIQUE_REF1
,      CALLING_APP_DOC_UNIQUE_REF2
,      CALLING_APP_DOC_UNIQUE_REF3
,      CALLING_APP_DOC_UNIQUE_REF4
,      CALLING_APP_DOC_UNIQUE_REF5
,      CALLING_APP_DOC_REF_NUMBER
,      CALL_APP_PAY_SERVICE_REQ_CODE
,      PAYMENT_FUNCTION
,      PAYMENT_DATE
,      DOCUMENT_DATE
,      DOCUMENT_TYPE
,      DOCUMENT_CURRENCY_CODE
,      DOCUMENT_AMOUNT
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_AMOUNT
,      PAYMENT_METHOD_CODE
,      EXCLUSIVE_PAYMENT_FLAG
,      PAYEE_PARTY_ID
,      PARTY_SITE_ID
,      SUPPLIER_SITE_ID
,      BENEFICIARY_PARTY
,      LEGAL_ENTITY_ID
,      ORG_ID
,      ORG_TYPE
,      ALLOW_REMOVING_DOCUMENT_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ANTICIPATED_VALUE_DATE
,      PO_NUMBER
,      DOCUMENT_DESCRIPTION
,      DOCUMENT_CURRENCY_TAX_AMOUNT
,      DOCUMENT_CURR_CHARGE_AMOUNT
,      AMOUNT_WITHHELD
,      PAYMENT_CURR_DISCOUNT_TAKEN
,      DISCOUNT_DATE
,      PAYMENT_DUE_DATE
,      PAYMENT_PROFILE_ID
,      INTERNAL_BANK_ACCOUNT_ID
,      EXTERNAL_BANK_ACCOUNT_ID
,      BANK_CHARGE_BEARER
,      INTEREST_RATE
,      PAYMENT_GROUPING_NUMBER
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_COMMENTS
,      SETTLEMENT_PRIORITY
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      UNIQUE_REMITTANCE_IDENTIFIER
,      URI_CHECK_DIGIT
,      DELIVERY_CHANNEL_CODE
,      PAYMENT_FORMAT_CODE
,      DOCUMENT_SEQUENCE_ID
,      DOCUMENT_SEQUENCE_VALUE
,      DOCUMENT_CATEGORY_CODE
,      BANK_ASSIGNED_REF_CODE
,      REMIT_TO_LOCATION_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ADDRESS_SOURCE
,      EMPLOYEE_ADDRESS_CODE
,      EMPLOYEE_PAYMENT_FLAG
,      EMPLOYEE_PERSON_ID
,      EMPLOYEE_ADDRESS_ID
,      EXT_REMIT_PAYEE_ID
,      REMIT_PAYEE_PARTY_ID
,      REMIT_PARTY_SITE_ID
,      REMIT_SUPPLIER_SITE_ID
,      REMIT_BENEFICIARY_PARTY
,      RELATIONSHIP_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
,      AFFECTS_REJECTION_LEVEL
FROM APPS.AP_DOCUMENTS_PAYABLE;

Dependencies

[top of page]

APPS

AP_CHECKS_ALL

AP_INVOICES_ALL

AP_INVOICES_PKG - show dependent code

AP_INVOICE_DISTRIBUTIONS_ALL

AP_INVOICE_PAYMENTS_ALL

AP_INV_SELECTION_CRITERIA_ALL

AP_PAYMENT_SCHEDULES_ALL

AP_PAYMENT_UTIL_PKG - show dependent code

AP_SELECTED_INVOICES_ALL

AP_SUPPLIERS

AP_SUPPLIER_SITES_ALL

CE_BANK_ACCT_USES_ALL

HZ_PARTY_SITES

APPS.AP_DOCUMENTS_PAYABLE is not referenced by any database object