eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: AP.AP_RECURRING_PAYMENTS_ALL#

Object Details

Object Name:	AP_RECURRING_PAYMENTS_ALL#
Object Type:	VIEW
Owner:	AP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
RECURRING_PAYMENT_ID	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
VENDOR_ID	NUMBER	(15)	Yes
RECURRING_PAY_NUM	VARCHAR2	(25)	Yes
VENDOR_SITE_ID	NUMBER	(15)	Yes
REC_PAY_PERIOD_TYPE	VARCHAR2	(15)	Yes
NUM_OF_PERIODS	NUMBER	(15)	Yes
FIRST_PERIOD	VARCHAR2	(15)	Yes
FIRST_PERIOD_NUM	NUMBER	(15)	Yes
AUTHORIZED_TOTAL	NUMBER		Yes
CONTROL_AMOUNT	NUMBER		Yes
DISTRIBUTION_SET_ID	NUMBER	(15)
TERMS_ID	NUMBER	(15)	Yes
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
AMOUNT_APPLICABLE_TO_DISCOUNT	NUMBER		Yes
PAYMENT_METHOD_LOOKUP_CODE	VARCHAR2	(25)
REM_PERIODS	NUMBER	(15)
ACCOUNTING_DATE	DATE
RELEASED_AMOUNT	NUMBER
BATCH_ID	NUMBER	(15)
ACCTS_PAY_CODE_COMBINATION_ID	NUMBER	(15)
INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Yes
PAYMENT_CURRENCY_CODE	VARCHAR2	(15)	Yes
INVOICE_BASE_RATE	NUMBER	(10)
PAY_GROUP_LOOKUP_CODE	VARCHAR2	(25)
TAX_AMOUNT	NUMBER
PAYMENT_INVOICE_CROSS_RATE	NUMBER	(10)
EXCHANGE_RATE	NUMBER
NEXT_PERIOD	VARCHAR2	(15)
NEXT_PAYMENT	NUMBER
INCREMENT_PERCENT	NUMBER	(10)
NUM_OF_PERIODS_REM	NUMBER	(15)
SPECIAL_PAYMENT_AMOUNT1	NUMBER
SPECIAL_PERIOD_NAME1	VARCHAR2	(30)
SPECIAL_PAYMENT_AMOUNT2	NUMBER
SPECIAL_PERIOD_NAME2	VARCHAR2	(30)
DESCRIPTION	VARCHAR2	(240)
PAID_FLAG1	VARCHAR2	(1)
PAID_FLAG2	VARCHAR2	(1)
HOLD_LOOKUP_CODE	VARCHAR2	(25)
HOLD_REASON	VARCHAR2	(240)
APPROVED_BY	NUMBER	(15)
EXPIRY_DATE	DATE
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)
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
PAYMENT_CROSS_RATE	NUMBER		Yes
EXCHANGE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
TAX_NAME	VARCHAR2	(15)
EXCLUSIVE_PAYMENT_FLAG	VARCHAR2	(1)
AWT_GROUP_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)
PO_HEADER_ID	NUMBER	(15)
PO_LINE_ID	NUMBER	(15)
LINE_LOCATION_ID	NUMBER	(15)
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)
EXTERNAL_BANK_ACCOUNT_ID	VARCHAR2	(15)
APPROVAL_REQUIRED_FLAG	VARCHAR2	(1)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
FIRST_AMOUNT	NUMBER
LEGAL_ENTITY_ID	NUMBER	(15)
TAXATION_COUNTRY	VARCHAR2	(30)
TAX_CONTROL_AMOUNT	NUMBER
PRIMARY_INTENDED_USE	VARCHAR2	(30)
PRODUCT_FISC_CLASSIFICATION	VARCHAR2	(240)
USER_DEFINED_FISC_CLASS	VARCHAR2	(240)
TRX_BUSINESS_CATEGORY	VARCHAR2	(240)
REQUESTER_ID	NUMBER	(15)
ITEM_DESCRIPTION	VARCHAR2	(240)
MANUFACTURER	VARCHAR2	(30)
MODEL_NUMBER	VARCHAR2	(40)
PO_RELEASE_ID	NUMBER
REMITTANCE_MESSAGE1	VARCHAR2	(150)
REMITTANCE_MESSAGE2	VARCHAR2	(150)
REMITTANCE_MESSAGE3	VARCHAR2	(150)
PAYMENT_REASON_CODE	VARCHAR2	(30)
PAYMENT_METHOD_CODE	VARCHAR2	(30)
BANK_CHARGE_BEARER	VARCHAR2	(30)
SETTLEMENT_PRIORITY	VARCHAR2	(30)
PAYMENT_REASON_COMMENTS	VARCHAR2	(30)
DELIVERY_CHANNEL_CODE	VARCHAR2	(30)
PAY_AWT_GROUP_ID	NUMBER	(15)
REMIT_TO_SUPPLIER_NAME	VARCHAR2	(240)
REMIT_TO_SUPPLIER_ID	NUMBER	(15)
REMIT_TO_SUPPLIER_SITE	VARCHAR2	(240)
REMIT_TO_SUPPLIER_SITE_ID	NUMBER	(15)
RELATIONSHIP_ID	NUMBER	(15)
PRODUCT_TYPE	VARCHAR2	(240)
PRODUCT_CATEGORY	VARCHAR2	(240)

Query Text

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


SELECT RECURRING_PAYMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      VENDOR_ID
,      RECURRING_PAY_NUM
,      VENDOR_SITE_ID
,      REC_PAY_PERIOD_TYPE
,      NUM_OF_PERIODS
,      FIRST_PERIOD
,      FIRST_PERIOD_NUM
,      AUTHORIZED_TOTAL
,      CONTROL_AMOUNT
,      DISTRIBUTION_SET_ID
,      TERMS_ID
,      SET_OF_BOOKS_ID
,      AMOUNT_APPLICABLE_TO_DISCOUNT
,      PAYMENT_METHOD_LOOKUP_CODE
,      REM_PERIODS
,      ACCOUNTING_DATE
,      RELEASED_AMOUNT
,      BATCH_ID
,      ACCTS_PAY_CODE_COMBINATION_ID
,      INVOICE_CURRENCY_CODE
,      PAYMENT_CURRENCY_CODE
,      INVOICE_BASE_RATE
,      PAY_GROUP_LOOKUP_CODE
,      TAX_AMOUNT
,      PAYMENT_INVOICE_CROSS_RATE
,      EXCHANGE_RATE
,      NEXT_PERIOD
,      NEXT_PAYMENT
,      INCREMENT_PERCENT
,      NUM_OF_PERIODS_REM
,      SPECIAL_PAYMENT_AMOUNT1
,      SPECIAL_PERIOD_NAME1
,      SPECIAL_PAYMENT_AMOUNT2
,      SPECIAL_PERIOD_NAME2
,      DESCRIPTION
,      PAID_FLAG1
,      PAID_FLAG2
,      HOLD_LOOKUP_CODE
,      HOLD_REASON
,      APPROVED_BY
,      EXPIRY_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      EXCHANGE_RATE_TYPE
,      PAYMENT_CROSS_RATE
,      EXCHANGE_DATE
,      LAST_UPDATE_LOGIN
,      TAX_NAME
,      EXCLUSIVE_PAYMENT_FLAG
,      AWT_GROUP_ID
,      ORG_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      LINE_LOCATION_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
,      EXTERNAL_BANK_ACCOUNT_ID
,      APPROVAL_REQUIRED_FLAG
,      USSGL_TRANSACTION_CODE
,      FIRST_AMOUNT
,      LEGAL_ENTITY_ID
,      TAXATION_COUNTRY
,      TAX_CONTROL_AMOUNT
,      PRIMARY_INTENDED_USE
,      PRODUCT_FISC_CLASSIFICATION
,      USER_DEFINED_FISC_CLASS
,      TRX_BUSINESS_CATEGORY
,      REQUESTER_ID
,      ITEM_DESCRIPTION
,      MANUFACTURER
,      MODEL_NUMBER
,      PO_RELEASE_ID
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      PAYMENT_REASON_CODE
,      PAYMENT_METHOD_CODE
,      BANK_CHARGE_BEARER
,      SETTLEMENT_PRIORITY
,      PAYMENT_REASON_COMMENTS
,      DELIVERY_CHANNEL_CODE
,      PAY_AWT_GROUP_ID
,      REMIT_TO_SUPPLIER_NAME
,      REMIT_TO_SUPPLIER_ID
,      REMIT_TO_SUPPLIER_SITE
,      REMIT_TO_SUPPLIER_SITE_ID
,      RELATIONSHIP_ID
,      PRODUCT_TYPE
,      PRODUCT_CATEGORY
FROM AP.AP_RECURRING_PAYMENTS_ALL#;

Dependencies

[top of page]

AP.AP_RECURRING_PAYMENTS_ALL# references the following:

AP: AP_RECURRING_PAYMENTS_ALL

AP.AP_RECURRING_PAYMENTS_ALL# is referenced by following:

APPS: AP_RECURRING_PAYMENTS; AP_RECURRING_PAYMENTS_ALL