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


VIEW: APPS.AP_VIEW_PREPAYS_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
INVOICE_ID NUMBER (15)
INVOICE_LINE_NUMBER NUMBER

PREPAY_INVOICE_ID NUMBER (15)
PREPAY_LINE_NUMBER NUMBER

PREPAY_AMOUNT_APPLIED NUMBER

TAX_AMOUNT_APPLIED NUMBER

PREPAY_AMOUNT_REMAINING NUMBER

ACCOUNTING_DATE DATE

PERIOD_NAME VARCHAR2 (15)
SET_OF_BOOKS_ID NUMBER (15)
DESCRIPTION VARCHAR2 (240)
INVOICE_INCLUDES_PREPAY_FLAG VARCHAR2 (1)
PO_LINE_LOCATION_ID NUMBER

PO_DISTRIBUTION_ID NUMBER

RCV_TRANSACTION_ID NUMBER

ORG_ID NUMBER (15)
PREPAY_NUMBER VARCHAR2 (50)
VENDOR_ID NUMBER (15)
VENDOR_SITE_ID NUMBER (15)
PO_NUMBER VARCHAR2 (20)
VENDOR_NAME VARCHAR2 (240)
VENDOR_NUMBER VARCHAR2 (30)
VENDOR_SITE_CODE VARCHAR2 (15)
RECEIPT_NUMBER VARCHAR2 (30)
INVOICE_CURRENCY_CODE VARCHAR2 (15)
Query Text

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


SELECT ROW_ID
,      INVOICE_ID
,      INVOICE_LINE_NUMBER
,      PREPAY_INVOICE_ID
,      PREPAY_LINE_NUMBER
,      PREPAY_AMOUNT_APPLIED
,      TAX_AMOUNT_APPLIED
,      PREPAY_AMOUNT_REMAINING
,      ACCOUNTING_DATE
,      PERIOD_NAME
,      SET_OF_BOOKS_ID
,      DESCRIPTION
,      INVOICE_INCLUDES_PREPAY_FLAG
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      RCV_TRANSACTION_ID
,      ORG_ID
,      PREPAY_NUMBER
,      VENDOR_ID
,      VENDOR_SITE_ID
,      PO_NUMBER
,      VENDOR_NAME
,      VENDOR_NUMBER
,      VENDOR_SITE_CODE
,      RECEIPT_NUMBER
,      INVOICE_CURRENCY_CODE
FROM APPS.AP_VIEW_PREPAYS_V;

Dependencies

[top of page]

APPS.AP_VIEW_PREPAYS_V references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
SynonymAP_INVOICE_DISTRIBUTIONS
SynonymAP_INVOICE_LINES
PL/SQL PackageAP_MATCHING_UTILS_PKG - show dependent code
PL/SQL PackageAP_PREPAY_UTILS_PKG - show dependent code
SynonymPO_HEADERS_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS

APPS.AP_VIEW_PREPAYS_V is not referenced by any database object