eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: AP.AP_INVOICE_LINES_ALL#

Object Details

Object Name:	AP_INVOICE_LINES_ALL#
Object Type:	VIEW
Owner:	AP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
INVOICE_ID	NUMBER	(15)	Yes
LINE_NUMBER	NUMBER		Yes
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes
REQUESTER_ID	NUMBER	(15)
DESCRIPTION	VARCHAR2	(240)
LINE_SOURCE	VARCHAR2	(30)
ORG_ID	NUMBER	(15)
LINE_GROUP_NUMBER	NUMBER
INVENTORY_ITEM_ID	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
SERIAL_NUMBER	VARCHAR2	(35)
MANUFACTURER	VARCHAR2	(30)
MODEL_NUMBER	VARCHAR2	(40)
WARRANTY_NUMBER	VARCHAR2	(15)
GENERATE_DISTS	VARCHAR2	(1)
MATCH_TYPE	VARCHAR2	(25)
DISTRIBUTION_SET_ID	NUMBER	(15)
ACCOUNT_SEGMENT	VARCHAR2	(25)
BALANCING_SEGMENT	VARCHAR2	(25)
COST_CENTER_SEGMENT	VARCHAR2	(25)
OVERLAY_DIST_CODE_CONCAT	VARCHAR2	(250)
DEFAULT_DIST_CCID	NUMBER	(15)
PRORATE_ACROSS_ALL_ITEMS	VARCHAR2	(1)
ACCOUNTING_DATE	DATE		Yes
PERIOD_NAME	VARCHAR2	(15)
DEFERRED_ACCTG_FLAG	VARCHAR2	(1)
DEF_ACCTG_START_DATE	DATE
DEF_ACCTG_END_DATE	DATE
DEF_ACCTG_NUMBER_OF_PERIODS	NUMBER
DEF_ACCTG_PERIOD_TYPE	VARCHAR2	(30)
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
AMOUNT	NUMBER		Yes
BASE_AMOUNT	NUMBER
ROUNDING_AMT	NUMBER
QUANTITY_INVOICED	NUMBER
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)
UNIT_PRICE	NUMBER
WFAPPROVAL_STATUS	VARCHAR2	(30)	Yes
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
DISCARDED_FLAG	VARCHAR2	(1)
ORIGINAL_AMOUNT	NUMBER
ORIGINAL_BASE_AMOUNT	NUMBER
ORIGINAL_ROUNDING_AMT	NUMBER
CANCELLED_FLAG	VARCHAR2	(1)
INCOME_TAX_REGION	VARCHAR2	(10)
TYPE_1099	VARCHAR2	(10)
STAT_AMOUNT	NUMBER
PREPAY_INVOICE_ID	NUMBER	(15)
PREPAY_LINE_NUMBER	NUMBER
INVOICE_INCLUDES_PREPAY_FLAG	VARCHAR2	(1)
CORRECTED_INV_ID	NUMBER	(15)
CORRECTED_LINE_NUMBER	NUMBER
PO_HEADER_ID	NUMBER
PO_LINE_ID	NUMBER
PO_RELEASE_ID	NUMBER
PO_LINE_LOCATION_ID	NUMBER
PO_DISTRIBUTION_ID	NUMBER
RCV_TRANSACTION_ID	NUMBER
FINAL_MATCH_FLAG	VARCHAR2	(1)
ASSETS_TRACKING_FLAG	VARCHAR2	(1)
ASSET_BOOK_TYPE_CODE	VARCHAR2	(15)
ASSET_CATEGORY_ID	NUMBER	(15)
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
EXPENDITURE_TYPE	VARCHAR2	(30)
EXPENDITURE_ITEM_DATE	DATE
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)
PA_QUANTITY	NUMBER
PA_CC_AR_INVOICE_ID	NUMBER	(15)
PA_CC_AR_INVOICE_LINE_NUM	NUMBER	(15)
PA_CC_PROCESSED_CODE	VARCHAR2	(1)
AWARD_ID	NUMBER	(15)
AWT_GROUP_ID	NUMBER	(15)
REFERENCE_1	VARCHAR2	(30)
REFERENCE_2	VARCHAR2	(30)
RECEIPT_VERIFIED_FLAG	VARCHAR2	(1)
RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)
RECEIPT_MISSING_FLAG	VARCHAR2	(1)
JUSTIFICATION	VARCHAR2	(240)
EXPENSE_GROUP	VARCHAR2	(80)
START_EXPENSE_DATE	DATE
END_EXPENSE_DATE	DATE
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)
RECEIPT_CONVERSION_RATE	NUMBER
RECEIPT_CURRENCY_AMOUNT	NUMBER
DAILY_AMOUNT	NUMBER
WEB_PARAMETER_ID	NUMBER
ADJUSTMENT_REASON	VARCHAR2	(240)
MERCHANT_DOCUMENT_NUMBER	VARCHAR2	(80)
MERCHANT_NAME	VARCHAR2	(240)
MERCHANT_REFERENCE	VARCHAR2	(240)
MERCHANT_TAX_REG_NUMBER	VARCHAR2	(80)
MERCHANT_TAXPAYER_ID	VARCHAR2	(80)
COUNTRY_OF_SUPPLY	VARCHAR2	(5)
CREDIT_CARD_TRX_ID	NUMBER	(15)
COMPANY_PREPAID_INVOICE_ID	NUMBER	(15)
CC_REVERSAL_FLAG	VARCHAR2	(1)
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
REQUEST_ID	NUMBER	(15)
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)
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)
LINE_SELECTED_FOR_APPL_FLAG	VARCHAR2	(1)
PREPAY_APPL_REQUEST_ID	NUMBER	(15)
APPLICATION_ID	NUMBER	(15)
PRODUCT_TABLE	VARCHAR2	(30)
REFERENCE_KEY1	VARCHAR2	(150)
REFERENCE_KEY2	VARCHAR2	(150)
REFERENCE_KEY3	VARCHAR2	(150)
REFERENCE_KEY4	VARCHAR2	(150)
REFERENCE_KEY5	VARCHAR2	(150)
PURCHASING_CATEGORY_ID	NUMBER	(15)
COST_FACTOR_ID	NUMBER	(15)
CONTROL_AMOUNT	NUMBER
ASSESSABLE_VALUE	NUMBER
TOTAL_REC_TAX_AMOUNT	NUMBER
TOTAL_NREC_TAX_AMOUNT	NUMBER
TOTAL_REC_TAX_AMT_FUNCL_CURR	NUMBER
TOTAL_NREC_TAX_AMT_FUNCL_CURR	NUMBER
INCLUDED_TAX_AMOUNT	NUMBER
PRIMARY_INTENDED_USE	VARCHAR2	(30)
TAX_ALREADY_CALCULATED_FLAG	VARCHAR2	(1)
SHIP_TO_LOCATION_ID	NUMBER	(15)
PRODUCT_TYPE	VARCHAR2	(240)
PRODUCT_CATEGORY	VARCHAR2	(240)
PRODUCT_FISC_CLASSIFICATION	VARCHAR2	(240)
USER_DEFINED_FISC_CLASS	VARCHAR2	(240)
TRX_BUSINESS_CATEGORY	VARCHAR2	(240)
SUMMARY_TAX_LINE_ID	NUMBER
TAX_REGIME_CODE	VARCHAR2	(30)
TAX	VARCHAR2	(30)
TAX_JURISDICTION_CODE	VARCHAR2	(30)
TAX_STATUS_CODE	VARCHAR2	(30)
TAX_RATE_ID	NUMBER	(15)
TAX_RATE_CODE	VARCHAR2	(150)
TAX_RATE	NUMBER
TAX_CODE_ID	NUMBER	(15)
HISTORICAL_FLAG	VARCHAR2	(1)
TAX_CLASSIFICATION_CODE	VARCHAR2	(30)
SOURCE_APPLICATION_ID	NUMBER
SOURCE_EVENT_CLASS_CODE	VARCHAR2	(30)
SOURCE_ENTITY_CODE	VARCHAR2	(30)
SOURCE_TRX_ID	NUMBER
SOURCE_LINE_ID	NUMBER
SOURCE_TRX_LEVEL_TYPE	VARCHAR2	(30)
RETAINED_AMOUNT	NUMBER
RETAINED_AMOUNT_REMAINING	NUMBER
RETAINED_INVOICE_ID	NUMBER	(15)
RETAINED_LINE_NUMBER	NUMBER
LINE_SELECTED_FOR_RELEASE_FLAG	VARCHAR2	(1)
LINE_OWNER_ROLE	VARCHAR2	(320)
DISPUTABLE_FLAG	VARCHAR2	(1)
RCV_SHIPMENT_LINE_ID	NUMBER	(15)
AIL_INVOICE_ID	NUMBER	(15)
AIL_DISTRIBUTION_LINE_NUMBER	NUMBER	(15)
AIL_INVOICE_ID2	NUMBER	(15)
AIL_DISTRIBUTION_LINE_NUMBER2	NUMBER	(15)
AIL_INVOICE_ID3	NUMBER	(15)
AIL_DISTRIBUTION_LINE_NUMBER3	NUMBER	(15)
AIL_INVOICE_ID4	NUMBER	(15)
PAY_AWT_GROUP_ID	NUMBER	(15)

Query Text

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


SELECT INVOICE_ID
,      LINE_NUMBER
,      LINE_TYPE_LOOKUP_CODE
,      REQUESTER_ID
,      DESCRIPTION
,      LINE_SOURCE
,      ORG_ID
,      LINE_GROUP_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      SERIAL_NUMBER
,      MANUFACTURER
,      MODEL_NUMBER
,      WARRANTY_NUMBER
,      GENERATE_DISTS
,      MATCH_TYPE
,      DISTRIBUTION_SET_ID
,      ACCOUNT_SEGMENT
,      BALANCING_SEGMENT
,      COST_CENTER_SEGMENT
,      OVERLAY_DIST_CODE_CONCAT
,      DEFAULT_DIST_CCID
,      PRORATE_ACROSS_ALL_ITEMS
,      ACCOUNTING_DATE
,      PERIOD_NAME
,      DEFERRED_ACCTG_FLAG
,      DEF_ACCTG_START_DATE
,      DEF_ACCTG_END_DATE
,      DEF_ACCTG_NUMBER_OF_PERIODS
,      DEF_ACCTG_PERIOD_TYPE
,      SET_OF_BOOKS_ID
,      AMOUNT
,      BASE_AMOUNT
,      ROUNDING_AMT
,      QUANTITY_INVOICED
,      UNIT_MEAS_LOOKUP_CODE
,      UNIT_PRICE
,      WFAPPROVAL_STATUS
,      USSGL_TRANSACTION_CODE
,      DISCARDED_FLAG
,      ORIGINAL_AMOUNT
,      ORIGINAL_BASE_AMOUNT
,      ORIGINAL_ROUNDING_AMT
,      CANCELLED_FLAG
,      INCOME_TAX_REGION
,      TYPE_1099
,      STAT_AMOUNT
,      PREPAY_INVOICE_ID
,      PREPAY_LINE_NUMBER
,      INVOICE_INCLUDES_PREPAY_FLAG
,      CORRECTED_INV_ID
,      CORRECTED_LINE_NUMBER
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_RELEASE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      RCV_TRANSACTION_ID
,      FINAL_MATCH_FLAG
,      ASSETS_TRACKING_FLAG
,      ASSET_BOOK_TYPE_CODE
,      ASSET_CATEGORY_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      PA_QUANTITY
,      PA_CC_AR_INVOICE_ID
,      PA_CC_AR_INVOICE_LINE_NUM
,      PA_CC_PROCESSED_CODE
,      AWARD_ID
,      AWT_GROUP_ID
,      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
,      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
,      LINE_SELECTED_FOR_APPL_FLAG
,      PREPAY_APPL_REQUEST_ID
,      APPLICATION_ID
,      PRODUCT_TABLE
,      REFERENCE_KEY1
,      REFERENCE_KEY2
,      REFERENCE_KEY3
,      REFERENCE_KEY4
,      REFERENCE_KEY5
,      PURCHASING_CATEGORY_ID
,      COST_FACTOR_ID
,      CONTROL_AMOUNT
,      ASSESSABLE_VALUE
,      TOTAL_REC_TAX_AMOUNT
,      TOTAL_NREC_TAX_AMOUNT
,      TOTAL_REC_TAX_AMT_FUNCL_CURR
,      TOTAL_NREC_TAX_AMT_FUNCL_CURR
,      INCLUDED_TAX_AMOUNT
,      PRIMARY_INTENDED_USE
,      TAX_ALREADY_CALCULATED_FLAG
,      SHIP_TO_LOCATION_ID
,      PRODUCT_TYPE
,      PRODUCT_CATEGORY
,      PRODUCT_FISC_CLASSIFICATION
,      USER_DEFINED_FISC_CLASS
,      TRX_BUSINESS_CATEGORY
,      SUMMARY_TAX_LINE_ID
,      TAX_REGIME_CODE
,      TAX
,      TAX_JURISDICTION_CODE
,      TAX_STATUS_CODE
,      TAX_RATE_ID
,      TAX_RATE_CODE
,      TAX_RATE
,      TAX_CODE_ID
,      HISTORICAL_FLAG
,      TAX_CLASSIFICATION_CODE
,      SOURCE_APPLICATION_ID
,      SOURCE_EVENT_CLASS_CODE
,      SOURCE_ENTITY_CODE
,      SOURCE_TRX_ID
,      SOURCE_LINE_ID
,      SOURCE_TRX_LEVEL_TYPE
,      RETAINED_AMOUNT
,      RETAINED_AMOUNT_REMAINING
,      RETAINED_INVOICE_ID
,      RETAINED_LINE_NUMBER
,      LINE_SELECTED_FOR_RELEASE_FLAG
,      LINE_OWNER_ROLE
,      DISPUTABLE_FLAG
,      RCV_SHIPMENT_LINE_ID
,      AIL_INVOICE_ID
,      AIL_DISTRIBUTION_LINE_NUMBER
,      AIL_INVOICE_ID2
,      AIL_DISTRIBUTION_LINE_NUMBER2
,      AIL_INVOICE_ID3
,      AIL_DISTRIBUTION_LINE_NUMBER3
,      AIL_INVOICE_ID4
,      PAY_AWT_GROUP_ID
FROM AP.AP_INVOICE_LINES_ALL#;

Dependencies

[top of page]

AP.AP_INVOICE_LINES_ALL# references the following:

AP: AP_INVOICE_LINES_ALL

AP.AP_INVOICE_LINES_ALL# is referenced by following:

APPS: AP_INVOICE_LINES; AP_INVOICE_LINES_ALL; IGI_AP_INVOICE_LINES_EXP_T1; IGI_AP_INVOICE_LINES_T1; IGI_AP_INVOICE_LINES_T2; JAI_AP_ILA_ARIUD_T1