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


VIEW: APPS.POS_AP_EXPENSE_REPORTS_V

Object Details
Object Name: POS_AP_EXPENSE_REPORTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_AP_EXPENSE_REPORTS_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DESCRIPTION VARCHAR2 (240)
INVOICE_AMOUNT VARCHAR2 (4000)
INVOICE_CURRENCY_CODE VARCHAR2 (15)
WITHHELD_AMOUNT_CURRENCY_CODE VARCHAR2 (56)
INVOICE_DATE DATE

INVOICE_ID NUMBER

INVOICE_NUM VARCHAR2 (50)
DUE_DATE DATE

GROSS_AMOUNT VARCHAR2 (4000)
AMOUNT_REMAINING VARCHAR2 (4000)
DISCOUNT_DATE DATE

DISCOUNT_AMOUNT_AVAILABLE VARCHAR2 (4000)
INVOICE_TYPE VARCHAR2 (80)
PAYMENT_STATUS VARCHAR2 (80)
PO_NUMBER VARCHAR2 (4000)
PAYMENT_NUMBER VARCHAR2 (4000)
VENDOR_SITE_CODE VARCHAR2 (15)
VENDOR_SITE_ID NUMBER

VENDOR_ID NUMBER

EMPLOYEE_ID NUMBER

REPORT_PRIMARY_KEY NUMBER

DOCUMENT_TYPE VARCHAR2 (20)
MANAGER_APPROVED VARCHAR2 (80)
AP_APPROVED VARCHAR2 (80)
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)
FULL_NAME VARCHAR2 (240)
Query Text

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


SELECT DESCRIPTION
,      INVOICE_AMOUNT
,      INVOICE_CURRENCY_CODE
,      WITHHELD_AMOUNT_CURRENCY_CODE
,      INVOICE_DATE
,      INVOICE_ID
,      INVOICE_NUM
,      DUE_DATE
,      GROSS_AMOUNT
,      AMOUNT_REMAINING
,      DISCOUNT_DATE
,      DISCOUNT_AMOUNT_AVAILABLE
,      INVOICE_TYPE
,      PAYMENT_STATUS
,      PO_NUMBER
,      PAYMENT_NUMBER
,      VENDOR_SITE_CODE
,      VENDOR_SITE_ID
,      VENDOR_ID
,      EMPLOYEE_ID
,      REPORT_PRIMARY_KEY
,      DOCUMENT_TYPE
,      MANAGER_APPROVED
,      AP_APPROVED
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      FULL_NAME
FROM APPS.POS_AP_EXPENSE_REPORTS_V;

Dependencies

[top of page]

APPS.POS_AP_EXPENSE_REPORTS_V references the following:

SchemaAPPS
SynonymAP_EXPENSE_REPORT_HEADERS_ALL
SynonymAP_INVOICES_ALL
ViewAP_LOOKUP_CODES
SynonymAP_PAYMENT_SCHEDULES_ALL
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_PEOPLE_X
PL/SQL PackagePOS_AP_INVOICES_PKG - show dependent code
PL/SQL PackagePOS_AP_INVOICE_PAYMENTS_PKG - show dependent code
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.POS_AP_EXPENSE_REPORTS_V is not referenced by any database object