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: ViewSQLAP.AP_RECURRING_PAYMENTS_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
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:

SchemaAPPS
SynonymAP_AWT_GROUPS
SynonymAP_DISTRIBUTION_SETS_ALL
ViewAP_LOOKUP_CODES
SynonymAP_RECURRING_PAYMENTS
SynonymAP_SUPPLIERS
SynonymAP_SUPPLIER_SITES_ALL
SynonymAP_TERMS
ViewCE_BANK_BRANCHES_V
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
ViewIBY_DELIVERY_CHANNELS_VL
SynonymIBY_EXT_BANK_ACCOUNTS
ViewIBY_PAYMENT_METHODS_VL
ViewIBY_PAYMENT_REASONS_VL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
APPS.AP_RECURRING_PAYMENTS_V is referenced by following:

SchemaAPPS
Package BodyFV_IPAC_DISBURSEMENT_PKG - show dependent code