DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AP_DOCUMENTS_PAYABLE

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
PAY_PROC_TRXN_TYPE_CODE VARCHAR2 (30)
CALLING_APP_ID NUMBER

CALLING_APP_DOC_UNIQUE_REF1 NUMBER (15)
CALLING_APP_DOC_UNIQUE_REF2 NUMBER (15)
CALLING_APP_DOC_UNIQUE_REF3 NUMBER (15)
CALLING_APP_DOC_UNIQUE_REF4 NUMBER

CALLING_APP_DOC_UNIQUE_REF5 VARCHAR2 (0)
CALLING_APP_DOC_REF_NUMBER VARCHAR2 (50)
CALL_APP_PAY_SERVICE_REQ_CODE VARCHAR2 (255)
PAYMENT_FUNCTION VARCHAR2 (30)
PAYMENT_DATE DATE

DOCUMENT_DATE DATE

DOCUMENT_TYPE VARCHAR2 (25)
DOCUMENT_CURRENCY_CODE VARCHAR2 (15)
DOCUMENT_AMOUNT NUMBER

PAYMENT_CURRENCY_CODE VARCHAR2 (15)
PAYMENT_AMOUNT NUMBER

PAYMENT_METHOD_CODE VARCHAR2 (30)
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 (1)
PAYEE_PARTY_ID NUMBER

PARTY_SITE_ID NUMBER

SUPPLIER_SITE_ID VARCHAR2 (40)
BENEFICIARY_PARTY NUMBER

LEGAL_ENTITY_ID NUMBER (15)
ORG_ID NUMBER (15)
ORG_TYPE VARCHAR2 (30)
ALLOW_REMOVING_DOCUMENT_FLAG VARCHAR2 (1)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

OBJECT_VERSION_NUMBER NUMBER

ANTICIPATED_VALUE_DATE DATE

PO_NUMBER VARCHAR2 (4000)
DOCUMENT_DESCRIPTION VARCHAR2 (240)
DOCUMENT_CURRENCY_TAX_AMOUNT VARCHAR2 (0)
DOCUMENT_CURR_CHARGE_AMOUNT VARCHAR2 (0)
AMOUNT_WITHHELD NUMBER

PAYMENT_CURR_DISCOUNT_TAKEN NUMBER

DISCOUNT_DATE DATE

PAYMENT_DUE_DATE DATE

PAYMENT_PROFILE_ID NUMBER (15)
INTERNAL_BANK_ACCOUNT_ID NUMBER (15)
EXTERNAL_BANK_ACCOUNT_ID NUMBER

BANK_CHARGE_BEARER VARCHAR2 (30)
INTEREST_RATE NUMBER

PAYMENT_GROUPING_NUMBER NUMBER

PAYMENT_REASON_CODE VARCHAR2 (30)
PAYMENT_REASON_COMMENTS VARCHAR2 (240)
SETTLEMENT_PRIORITY VARCHAR2 (30)
REMITTANCE_MESSAGE1 VARCHAR2 (150)
REMITTANCE_MESSAGE2 VARCHAR2 (150)
REMITTANCE_MESSAGE3 VARCHAR2 (150)
UNIQUE_REMITTANCE_IDENTIFIER VARCHAR2 (30)
URI_CHECK_DIGIT VARCHAR2 (2)
DELIVERY_CHANNEL_CODE VARCHAR2 (30)
PAYMENT_FORMAT_CODE VARCHAR2 (0)
DOCUMENT_SEQUENCE_ID NUMBER

DOCUMENT_SEQUENCE_VALUE NUMBER

DOCUMENT_CATEGORY_CODE VARCHAR2 (30)
BANK_ASSIGNED_REF_CODE VARCHAR2 (0)
REMIT_TO_LOCATION_ID NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ADDRESS_SOURCE VARCHAR2 (3)
EMPLOYEE_ADDRESS_CODE VARCHAR2 (15)
EMPLOYEE_PAYMENT_FLAG VARCHAR2 (1)
EMPLOYEE_PERSON_ID NUMBER

EMPLOYEE_ADDRESS_ID VARCHAR2 (0)
REMIT_PAYEE_PARTY_ID NUMBER

REMIT_PARTY_SITE_ID NUMBER

REMIT_SUPPLIER_SITE_ID NUMBER

REMIT_BENEFICIARY_PARTY NUMBER

RELATIONSHIP_ID NUMBER

GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
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
,      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
FROM APPS.AP_DOCUMENTS_PAYABLE;

Dependencies

[top of page]

APPS.AP_DOCUMENTS_PAYABLE references the following:

SchemaAPPS
SynonymAP_CHECKS_ALL
SynonymAP_INVOICES_ALL
PL/SQL PackageAP_INVOICES_PKG - show dependent code
SynonymAP_INVOICE_DISTRIBUTIONS_ALL
SynonymAP_INVOICE_PAYMENTS_ALL
SynonymAP_INV_SELECTION_CRITERIA_ALL
SynonymAP_PAYMENT_SCHEDULES_ALL
PL/SQL PackageAP_PAYMENT_UTIL_PKG - show dependent code
SynonymAP_SELECTED_INVOICES_ALL
SynonymAP_SUPPLIERS
SynonymAP_SUPPLIER_SITES_ALL
SynonymCE_BANK_ACCT_USES_ALL
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageFV_CCR_GRP - show dependent code
PL/SQL PackageFV_INSTALL - show dependent code
ViewFV_TPP_ASSIGNMENTS_V
SynonymHZ_PARTY_SITES

APPS.AP_DOCUMENTS_PAYABLE is not referenced by any database object