[Home] [Help] [Dependency Information]

VIEW: APPS.AP_INVOICE_LINES_V

Object Details

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

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      INVOICE_ID
,      LINE_NUMBER
,      LINE_TYPE_LOOKUP_CODE
,      LINE_TYPE
,      REQUESTER_ID
,      DESCRIPTION
,      LINE_SOURCE
,      ORG_ID
,      LINE_GROUP_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      SERIAL_NUMBER
,      MANUFACTURER
,      MODEL_NUMBER
,      WARRANTY_NUMBER
,      GENERATE_DISTRIBUTIONS
,      MATCH_TYPE
,      DISTRIBUTION_SET_ID
,      DISTRIBUTION_SET_NAME
,      ACCOUNT_SEGMENT
,      BALANCING_SEGMENT
,      COST_CENTER_SEGMENT
,      OVERLAY_DIST_CODE_CONCAT
,      DEFAULT_DIST_CCID
,      PRORATE_ACROSS_ALL_ITEMS
,      GL_DATE
,      PERIOD_NAME
,      DEFERRED_ACCTG_FLAG
,      DEFERRED_START_DATE
,      DEFERRED_END_DATE
,      DEFERRED_NUMBER_OF_PERIODS
,      DEFERRED_PERIOD_TYPE
,      SET_OF_BOOKS_ID
,      AMOUNT
,      BASE_AMOUNT
,      ROUNDING_AMOUNT
,      QUANTITY_INVOICED
,      UNIT_MEAS_LOOKUP_CODE
,      UNIT_PRICE
,      WFAPPROVAL_STATUS_LOOKUP_CODE
,      WFAPPROVAL_STATUS_DISP
,      DISCARDED_FLAG
,      ORIGINAL_AMOUNT
,      ORIGINAL_BASE_AMOUNT
,      ORIGINAL_ROUNDING_AMOUNT
,      CANCELLED_FLAG
,      INCOME_TAX_REGION
,      INCOME_TAX_TYPE
,      STAT_AMOUNT
,      PREPAY_INVOICE_ID
,      PREPAY_INVOICE_NUM
,      PREPAY_LINE_NUMBER
,      INVOICE_INCLUDES_PREPAY_FLAG
,      CORRECTED_INV_ID
,      CORRECTED_INVOICE_NUM
,      CORRECTED_LINE_NUMBER
,      PO_HEADER_ID
,      PO_NUMBER
,      PO_LINE_ID
,      PO_LINE_NUMBER
,      PO_RELEASE_ID
,      PO_RELEASE_NUMBER
,      PO_LINE_LOCATION_ID
,      PO_SHIPMENT_NUMBER
,      MATCHING_BASIS
,      MATCHING_BASIS_LOOKUP_CODE
,      PO_DISTRIBUTION_ID
,      PO_DISTRIBUTION_NUMBER
,      RCV_TRANSACTION_ID
,      RECEIPT_NUMBER
,      RECEIPT_LINE_NUMBER
,      FINAL_MATCH_FLAG
,      ASSETS_TRACKING_FLAG
,      ASSET_BOOK_TYPE_CODE
,      ASSET_BOOK_NAME
,      ASSET_CATEGORY_ID
,      PROJECT_ID
,      PROJECT
,      TASK_ID
,      TASK
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION_NAME
,      PA_QUANTITY
,      PA_CC_AR_INVOICE_ID
,      INTERCOMPANY_INVOICE_NUM
,      INTERCOMPANY_INVOICE_LINE_NUM
,      PROCESSED_CODE
,      AWARD_ID
,      AWT_GROUP_ID
,      AWT_GROUP_NAME
,      REFERENCE_1
,      REFERENCE_2
,      RECEIPT_VERIFIED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      RECEIPT_MISSING_FLAG
,      JUSTIFICATION
,      EXPENSE_GROUP
,      START_EXPENSE_DATE
,      END_EXPENSE_DATE
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CONVERSION_RATE
,      RECEIPT_CURRENCY_AMOUNT
,      DAILY_AMOUNT
,      WEB_PARAMETER_ID
,      ADJUSTMENT_REASON
,      MERCHANT_DOCUMENT_NUMBER
,      MERCHANT_NAME
,      MERCHANT_REFERENCE
,      MERCHANT_TAX_REG_NUMBER
,      MERCHANT_TAXPAYER_ID
,      COUNTRY_OF_SUPPLY
,      CREDIT_CARD_TRX_ID
,      COMPANY_PREPAID_INVOICE_ID
,      CC_REVERSAL_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      QUERY_PACKET_ID
,      VALIDATION_STATUS
,      ENCUMBRANCE_FLAG
,      ACCOUNTING_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      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
,      HIGHEST_DIST_LINE_NUM
,      PRIMARY_INTENDED_USE
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION_CODE
,      PRODUCT_FISC_CLASSIFICATION
,      USER_DEFINED_FISC_CLASS
,      TRX_BUSINESS_CATEGORY
,      PRODUCT_TYPE
,      PRODUCT_CATEGORY
,      ASSESSABLE_VALUE
,      CONTROL_AMOUNT
,      INCLUDED_TAX_AMOUNT
,      TOTAL_REC_TAX_AMOUNT
,      TOTAL_NREC_TAX_AMOUNT
,      TAX_REGIME_CODE
,      TAX
,      TAX_STATUS_CODE
,      TAX_RATE_CODE
,      TAX_RATE_ID
,      TAX_RATE
,      TAX_JURISDICTION_CODE
,      SUMMARY_TAX_LINE_ID
,      TAX_ALREADY_CALCULATED_FLAG
,      TAX_CLASSIFICATION_CODE
,      APPLICATION_ID
,      PRODUCT_TABLE
,      REFERENCE_KEY1
,      REFERENCE_KEY2
,      REFERENCE_KEY3
,      REFERENCE_KEY4
,      REFERENCE_KEY5
,      PURCHASING_CATEGORY_ID
,      COST_FACTOR_ID
,      COST_FACTOR_NAME
,      RECOUPED_AMOUNT
,      RECOUPMENT_RATE
,      RETAINED_AMOUNT
,      RETAINED_AMOUNT_REMAINING
,      RETAINED_INVOICE_ID
,      RETAINED_INVOICE_NUM
,      RETAINED_LINE_NUMBER
,      LINE_SELECTED_FOR_RELEASE_FLAG
,      RCV_SHIPMENT_LINE_ID
,      PAY_AWT_GROUP_ID
,      PAY_AWT_GROUP_NAME
FROM APPS.AP_INVOICE_LINES_V;

Dependencies

[top of page]

APPS

AP_AWT_GROUPS

AP_DISTRIBUTION_SETS_ALL

AP_INVOICES_ALL

AP_INVOICES_UTILITY_PKG - show dependent code

AP_INVOICE_LINES_ALL

AP_INVOICE_LINES_UTILITY_PKG - show dependent code

AP_LOOKUP_CODES

AP_MATCHING_UTILS_PKG - show dependent code

FA_BOOK_CONTROLS

FND_GLOBAL - show dependent code

FND_PROFILE - show dependent code

GL_SETS_OF_BOOKS

HR_GENERAL - show dependent code

HR_LOCATIONS

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

PON_PRICE_ELEMENT_TYPES_VL

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_INVOICE_LINES_V is not referenced by any database object