[Home] [Help] [Dependency Information]

VIEW: APPS.AP_INVOICE_DISTRIBUTIONS_V

Object Details

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

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      ACCOUNTING_EVENT_ID
,      ACCOUNTING_DATE
,      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
,      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
,      PO_DISTRIBUTION_NUMBER
,      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
,      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
,      PO_LINE_NUMBER
,      LINE_LOCATION_ID
,      PO_LINE_LOCATION_NUMBER
,      PO_NUMBER
,      UNIT_MEAS_LOOKUP_CODE
,      UNIT_OF_MEASURE
,      PO_CODE_COMBINATION_ID
,      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
,      PO_RELEASE_ID
,      PO_RELEASE_NUMBER
,      DESTINATION_TYPE_CODE
,      INVOICE_DISTRIBUTION_ID
,      MATCHED_UOM_LOOKUP_CODE
,      RECEIPT_TXN_DATE
,      RCV_TRANSACTION_ID
,      RECEIPT_NUMBER
,      RCV_SHIPMENT_HEADER_ID
,      RECEIPT_LINE_NUMBER
,      RCV_SHIPMENT_LINE_ID
,      AWARD_ID
,      GMS_BURDENABLE_RAW_COST
,      PREPAY_DISTRIBUTION_ID
,      PREPAY_NUMBER
,      PREPAY_DIST_NUMBER
,      START_EXPENSE_DATE
,      MERCHANT_DOCUMENT_NUMBER
,      MERCHANT_NAME
,      MERCHANT_REFERENCE
,      MERCHANT_TAX_REG_NUMBER
,      MERCHANT_TAXPAYER_ID
,      COUNTRY_OF_SUPPLY
,      PARENT_REVERSAL_ID
,      REVERSED_DISTRIBUTION_NUM
,      REVERSING_DISTRIBUTION_ID
,      REVERSING_DISTRIBUTION_NUM
,      PO_SHIPMENT_CLOSED_CODE
,      INVOICE_LINE_NUMBER
,      PREPAY_LINE_NUMBER
,      ROUNDING_AMT
,      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_BOOK_TYPE_NAME
,      ASSET_CATEGORY_ID
,      DISTRIBUTION_CLASS
,      DISTRIBUTION_CLASS_DSP
,      INTENDED_USE
,      DETAIL_TAX_DIST_ID
,      REC_NREC_RATE
,      RECOVERY_RATE_ID
,      RECOVERY_RATE_NAME
,      RECOVERY_TYPE_CODE
,      WITHHOLDING_TAX_CODE_ID
,      WITHHOLDING_TAX_CODE
,      TAX_RECOVERABLE_FLAG
,      DIST_MATCH_TYPE
,      DIST_MATCH_TYPE_DSP
,      CANCELLATION_FLAG
,      CANCELLED_DATE
,      ASSOCIATED_CHARGES
,      CASH_POSTED_FLAG
,      ACCRUAL_POSTED_FLAG
,      RETAINED_AMOUNT_REMAINING
,      RELATED_RETAINAGE_INV_DIST_NUM
,      RETAINED_INVOICE_DIST_NUM
,      WEB_PARAMETER_ID
,      PAY_AWT_GROUP_ID
,      PAY_AWT_GROUP_NAME
FROM APPS.AP_INVOICE_DISTRIBUTIONS_V;

Dependencies

[top of page]

APPS

AP_AWT_GROUPS

AP_BATCHES_ALL

AP_INCOME_TAX_REGIONS

AP_INVOICES_ALL

AP_INVOICES_UTILITY_PKG - show dependent code

AP_INVOICE_DISTRIBUTIONS

AP_INVOICE_DISTRIBUTIONS_PKG - show dependent code

AP_LOOKUP_CODES

AP_TAX_CODES_ALL

FA_BOOK_CONTROLS

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_ALL

PO_HEADERS_ALL

PO_LINES_ALL

PO_LINE_LOCATIONS_ALL

PO_RELEASES_ALL

RCV_SHIPMENT_HEADERS

RCV_SHIPMENT_LINES

RCV_TRANSACTIONS

APPS

AP_MATCHING_UTILS_PKG - show dependent code

FV_IPAC_DISBURSEMENT_PKG - show dependent code

GHG_PO_EMISSIONS_PKG - show dependent code

GHG_TRANSACTIONS_PKG - show dependent code

GHG_UTILITIES_PKG - show dependent code

IGI_MPP_EXP_RECOGNITION