[Home] [Help] [Dependency Information]

VIEW: APPS.AP_INVOICE_DISTS_INQUIRY_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      ACCOUNTING_DATE
,      ACCRUAL_POSTED_FLAG
,      ACCTS_PAY_CODE_COMBINATION_ID
,      AMOUNT
,      ASSETS_ADDITION_FLAG
,      ASSETS_TRACKING_FLAG
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      AWT_FLAG
,      AWT_GROSS_AMOUNT
,      AWT_GROUP_ID
,      AWT_INVOICE_ID
,      AWT_ORIGIN_GROUP_ID
,      AWT_TAX_RATE_ID
,      BASE_AMOUNT
,      BASE_QUANTITY_VARIANCE
,      BATCH_ID
,      CASH_POSTED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      DESCRIPTION
,      DISTRIBUTION_LINE_NUMBER
,      DIST_CODE_COMBINATION_ID
,      ENCUMBERED_FLAG
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      FINAL_MATCH_FLAG
,      INCOME_TAX_REGION
,      INVOICE_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LINE_TYPE_LOOKUP_CODE
,      MATCH_STATUS_FLAG
,      ORG_ID
,      OTHER_INVOICE_ID
,      PACKET_ID
,      PARENT_INVOICE_ID
,      PA_ADDITION_FLAG
,      PA_QUANTITY
,      PERIOD_NAME
,      POSTED_AMOUNT
,      POSTED_BASE_AMOUNT
,      POSTED_FLAG
,      PO_DISTRIBUTION_ID
,      PREPAY_AMOUNT_REMAINING
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_ID
,      QUANTITY_INVOICED
,      QUANTITY_VARIANCE
,      REFERENCE_1
,      REFERENCE_2
,      REQUEST_ID
,      REVERSAL_FLAG
,      SET_OF_BOOKS_ID
,      STAT_AMOUNT
,      TASK_ID
,      TYPE_1099
,      UNIT_PRICE
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      VAT_CODE
,      INVOICE_NUM
,      PARENT_INVOICE_NUM
,      BATCH_NAME
,      INCOME_TAX_REGION_NAME
,      POSTED_STATUS
,      LINE_TYPE
,      STATUS
,      AWT_CREATION_METHOD
,      POSTED_STATUS_DISP
,      AWT_GROUP_NAME
,      CHART_OF_ACCOUNTS_ID
,      SET_OF_BOOKS_NAME
,      SET_OF_BOOKS_SHORT_NAME
,      PROJECT
,      TASK
,      EXPENDITURE_ORGANIZATION_NAME
,      PO_ACCRUE_ON_RECEIPT_FLAG
,      PO_HEADER_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      PO_NUMBER
,      UNIT_MEAS_LOOKUP_CODE
,      TAX_TYPE
,      UNIT_OF_MEASURE
,      TAX_RECOVERY_RATE
,      TAX_RECOVERY_OVERRIDE_FLAG
,      TAX_RECOVERABLE_FLAG
,      TAX_CODE_OVERRIDE_FLAG
,      VENDOR_ID
,      VENDOR_SITE_ID
,      INVOICE_CURRENCY_CODE
,      VENDOR_NAME
,      VENDOR_NUMBER
,      VENDOR_SITE_CODE
,      INVOICE_TOTAL
,      TAX_CODE_ID
,      INVOICE_LINE_NUMBER
,      PREPAY_LINE_NUMBER
,      ROUNDING_AMOUNT
,      CHARGE_APPLICABLE_TO_DIST_ID
,      CHARGE_APPLICABLE_TO_LINE_NUM
,      CHARGE_APPLICABLE_TO_DIST_NUM
,      CORRECTED_INVOICE_DIST_ID
,      CORRECTED_INVOICE_NUM
,      CORRECTED_INVOICE_LINE_NUM
,      CORRECTED_INVOICE_DIST_NUM
,      CORRECTED_QUANTITY
,      RELATED_ID
,      RELATED_DIST_NUM
,      ASSET_BOOK_TYPE_CODE
,      ASSET_CATEGORY_ID
,      DISTRIBUTION_CLASS
FROM APPS.AP_INVOICE_DISTS_INQUIRY_V;

Dependencies

[top of page]

APPS

AP_AWT_GROUPS

AP_BATCHES

AP_INCOME_TAX_REGIONS

AP_INVOICES

AP_INVOICE_DISTRIBUTIONS

AP_INVOICE_DISTRIBUTIONS_PKG - show dependent code

AP_LOOKUP_CODES

AP_TAX_CODES

FND_GLOBAL - show dependent code

FND_PROFILE - show dependent code

GL_SETS_OF_BOOKS

HR_GENERAL - show dependent code

HR_ORGANIZATION_UNITS

HR_SECURITY - show dependent code

PA_PROJECTS_ALL

PA_TASKS_EXPEND_V

PA_TASK_UTILS - show dependent code

PA_UTILS4 - show dependent code

PO_DISTRIBUTIONS

PO_HEADERS

PO_LINES

PO_LINE_LOCATIONS

PO_VENDORS

PO_VENDOR_SITES

APPS.AP_INVOICE_DISTS_INQUIRY_V is not referenced by any database object