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: APPS.AP_RECURRING_PAYMENTS_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
ACCOUNTING_DATE	DATE
ACCTS_PAY_CODE_COMBINATION_ID	NUMBER	(15)
AMOUNT_APPLICABLE_TO_DISCOUNT	NUMBER		Yes
APPROVED_BY	NUMBER	(15)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	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)
ATTRIBUTE_CATEGORY	VARCHAR2	(150)
AUTHORIZED_TOTAL	NUMBER		Yes
AWT_GROUP_ID	NUMBER	(15)
BATCH_ID	NUMBER	(15)
CONTROL_AMOUNT	NUMBER		Yes
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
DESCRIPTION	VARCHAR2	(240)
DISTRIBUTION_SET_ID	NUMBER	(15)
EXCHANGE_DATE	DATE
EXCHANGE_RATE	NUMBER
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
EXCLUSIVE_PAYMENT_FLAG	VARCHAR2	(1)
EXPIRY_DATE	DATE
FIRST_PERIOD	VARCHAR2	(15)	Yes
FIRST_PERIOD_NUM	NUMBER	(15)	Yes
HOLD_LOOKUP_CODE	VARCHAR2	(25)
HOLD_REASON	VARCHAR2	(240)
INCREMENT_PERCENT	NUMBER	(10)
INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
NEXT_PAYMENT	NUMBER
NEXT_PERIOD	VARCHAR2	(15)
NUM_OF_PERIODS	NUMBER	(15)	Yes
NUM_OF_PERIODS_REM	NUMBER	(15)
ORG_ID	NUMBER	(15)
PAID_FLAG1	VARCHAR2	(1)
PAID_FLAG2	VARCHAR2	(1)
PAYMENT_CROSS_RATE	NUMBER		Yes
PAYMENT_CURRENCY_CODE	VARCHAR2	(15)	Yes
PAY_GROUP_LOOKUP_CODE	VARCHAR2	(25)
RECURRING_PAYMENT_ID	NUMBER	(15)	Yes
RECURRING_PAY_NUM	VARCHAR2	(25)	Yes
REC_PAY_PERIOD_TYPE	VARCHAR2	(15)	Yes
RELEASED_AMOUNT	NUMBER
REM_PERIODS	NUMBER	(15)
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
SPECIAL_PAYMENT_AMOUNT1	NUMBER
SPECIAL_PAYMENT_AMOUNT2	NUMBER
SPECIAL_PERIOD_NAME1	VARCHAR2	(30)
SPECIAL_PERIOD_NAME2	VARCHAR2	(30)
TAX_AMOUNT	NUMBER
TAX_NAME	VARCHAR2	(15)
TERMS_ID	NUMBER	(15)	Yes
VENDOR_ID	NUMBER	(15)	Yes
VENDOR_SITE_ID	NUMBER	(15)	Yes
PO_HEADER_ID	NUMBER	(15)
PO_LINE_ID	NUMBER	(15)
LINE_LOCATION_ID	NUMBER	(15)
VENDOR_NAME	VARCHAR2	(240)
VENDOR_NUMBER	VARCHAR2	(30)
VENDOR_SITE_CODE	VARCHAR2	(80)
INVOICE_HOLD_CODE	VARCHAR2	(6)
PAYMENT_PRIORITY	NUMBER
INVOICE_AMOUNT_LIMIT	NUMBER
STATE	VARCHAR2	(150)
HOLD_DSP	VARCHAR2	(80)
TERMS	VARCHAR2	(50)
DISTRIBUTION_SET	VARCHAR2	(50)
PO_NUMBER	VARCHAR2	(50)
LINE_NUM	VARCHAR2	(240)
SHIPMENT_NUM	NUMBER
AWT_GROUP_NAME	VARCHAR2	(25)
VENDOR_ALLOW_AWT_FLAG	VARCHAR2	(1)
SITE_ALLOW_AWT_FLAG	VARCHAR2	(1)
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)
BANK_ACCOUNT_NAME	VARCHAR2	(80)
BANK_NAME	VARCHAR2	(360)
BANK_NUMBER	VARCHAR2	(30)
BANK_NUM	VARCHAR2	(30)
BANK_BRANCH_NAME	VARCHAR2	(360)
BANK_ACCOUNT_NUM	VARCHAR2	(100)
APPROVAL_REQUIRED_FLAG	VARCHAR2	(1)
REQUESTER_ID	NUMBER	(15)
PO_RELEASE_ID	NUMBER
RELEASE_NUM	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
MANUFACTURER	VARCHAR2	(30)
MODEL_NUMBER	VARCHAR2	(40)
PO_TYPE_LOOKUP_CODE	VARCHAR2	(25)
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)
LEGAL_ENTITY_ID	NUMBER	(15)
PAYMENT_METHOD_CODE	VARCHAR2	(30)
IBY_PAYMENT_METHOD	VARCHAR2	(100)
PAYMENT_REASON_CODE	VARCHAR2	(30)
PAYMENT_REASON	VARCHAR2	(80)
REMITTANCE_MESSAGE1	VARCHAR2	(150)
REMITTANCE_MESSAGE2	VARCHAR2	(150)
REMITTANCE_MESSAGE3	VARCHAR2	(150)
PARTY_ID	NUMBER
PARTY_SITE_ID	NUMBER	(15)
BANK_CHARGE_BEARER	VARCHAR2	(30)
BANK_CHARGE_BEARER_DSP	VARCHAR2	(80)
SETTLEMENT_PRIORITY	VARCHAR2	(30)
SETTLEMENT_PRIORITY_DSP	VARCHAR2	(80)
PAYMENT_REASON_COMMENTS	VARCHAR2	(30)
DELIVERY_CHANNEL_CODE	VARCHAR2	(30)
DELIVERY_CHANNEL	VARCHAR2	(80)
FIRST_AMOUNT	NUMBER
EXCLUDE_FREIGHT_FROM_DISCOUNT	VARCHAR2	(1)
PAY_AWT_GROUP_ID	NUMBER	(15)
PAY_AWT_GROUP_NAME	VARCHAR2	(25)
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 ROW_ID
,      ACCOUNTING_DATE
,      ACCTS_PAY_CODE_COMBINATION_ID
,      AMOUNT_APPLICABLE_TO_DISCOUNT
,      APPROVED_BY
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      AUTHORIZED_TOTAL
,      AWT_GROUP_ID
,      BATCH_ID
,      CONTROL_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      DESCRIPTION
,      DISTRIBUTION_SET_ID
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCLUSIVE_PAYMENT_FLAG
,      EXPIRY_DATE
,      FIRST_PERIOD
,      FIRST_PERIOD_NUM
,      HOLD_LOOKUP_CODE
,      HOLD_REASON
,      INCREMENT_PERCENT
,      INVOICE_CURRENCY_CODE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NEXT_PAYMENT
,      NEXT_PERIOD
,      NUM_OF_PERIODS
,      NUM_OF_PERIODS_REM
,      ORG_ID
,      PAID_FLAG1
,      PAID_FLAG2
,      PAYMENT_CROSS_RATE
,      PAYMENT_CURRENCY_CODE
,      PAY_GROUP_LOOKUP_CODE
,      RECURRING_PAYMENT_ID
,      RECURRING_PAY_NUM
,      REC_PAY_PERIOD_TYPE
,      RELEASED_AMOUNT
,      REM_PERIODS
,      SET_OF_BOOKS_ID
,      SPECIAL_PAYMENT_AMOUNT1
,      SPECIAL_PAYMENT_AMOUNT2
,      SPECIAL_PERIOD_NAME1
,      SPECIAL_PERIOD_NAME2
,      TAX_AMOUNT
,      TAX_NAME
,      TERMS_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      VENDOR_NAME
,      VENDOR_NUMBER
,      VENDOR_SITE_CODE
,      INVOICE_HOLD_CODE
,      PAYMENT_PRIORITY
,      INVOICE_AMOUNT_LIMIT
,      STATE
,      HOLD_DSP
,      TERMS
,      DISTRIBUTION_SET
,      PO_NUMBER
,      LINE_NUM
,      SHIPMENT_NUM
,      AWT_GROUP_NAME
,      VENDOR_ALLOW_AWT_FLAG
,      SITE_ALLOW_AWT_FLAG
,      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
,      BANK_ACCOUNT_NAME
,      BANK_NAME
,      BANK_NUMBER
,      BANK_NUM
,      BANK_BRANCH_NAME
,      BANK_ACCOUNT_NUM
,      APPROVAL_REQUIRED_FLAG
,      REQUESTER_ID
,      PO_RELEASE_ID
,      RELEASE_NUM
,      ITEM_DESCRIPTION
,      MANUFACTURER
,      MODEL_NUMBER
,      PO_TYPE_LOOKUP_CODE
,      TAXATION_COUNTRY
,      TAX_CONTROL_AMOUNT
,      PRIMARY_INTENDED_USE
,      PRODUCT_FISC_CLASSIFICATION
,      USER_DEFINED_FISC_CLASS
,      TRX_BUSINESS_CATEGORY
,      LEGAL_ENTITY_ID
,      PAYMENT_METHOD_CODE
,      IBY_PAYMENT_METHOD
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      PARTY_ID
,      PARTY_SITE_ID
,      BANK_CHARGE_BEARER
,      BANK_CHARGE_BEARER_DSP
,      SETTLEMENT_PRIORITY
,      SETTLEMENT_PRIORITY_DSP
,      PAYMENT_REASON_COMMENTS
,      DELIVERY_CHANNEL_CODE
,      DELIVERY_CHANNEL
,      FIRST_AMOUNT
,      EXCLUDE_FREIGHT_FROM_DISCOUNT
,      PAY_AWT_GROUP_ID
,      PAY_AWT_GROUP_NAME
,      REMIT_TO_SUPPLIER_NAME
,      REMIT_TO_SUPPLIER_ID
,      REMIT_TO_SUPPLIER_SITE
,      REMIT_TO_SUPPLIER_SITE_ID
,      RELATIONSHIP_ID
,      PRODUCT_TYPE
,      PRODUCT_CATEGORY
FROM APPS.AP_RECURRING_PAYMENTS_V;

Dependencies

[top of page]

APPS.AP_RECURRING_PAYMENTS_V references the following:

APPS: AP_AWT_GROUPS; AP_DISTRIBUTION_SETS_ALL; AP_LOOKUP_CODES; AP_RECURRING_PAYMENTS; AP_SUPPLIERS; AP_SUPPLIER_SITES_ALL; AP_TERMS; CE_BANK_BRANCHES_V; FND_GLOBAL - show dependent code; FND_LOOKUPS; IBY_DELIVERY_CHANNELS_VL; IBY_EXT_BANK_ACCOUNTS; IBY_PAYMENT_METHODS_VL; IBY_PAYMENT_REASONS_VL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL

APPS.AP_RECURRING_PAYMENTS_V is referenced by following:

APPS: FV_IPAC_DISBURSEMENT_PKG - show dependent code