FND Design Data [Home] [Help]

Table: AP_EXPENSE_REPORT_LINES_ALL

Product: AP - Payables
Description: Expense item information for employee expense reports
Implementation/DBA Data: TableAP.AP_EXPENSE_REPORT_LINES_ALL
Primary Key: AP_EXPENSE_REPORT_LINES_PK
  1. ColumnREPORT_LINE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TableAP_EXPENSE_REPORT_HEADERS_ALL AP_EXPENSE_REPORT_LINES_ALL.REPORT_HEADER_ID
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TablePA_PROJECTS_ALL AP_EXPENSE_REPORT_LINES_ALL.PROJECT_ID
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TablePA_TASKS AP_EXPENSE_REPORT_LINES_ALL.TASK_ID
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TablePA_EXPENDITURE_TYPES AP_EXPENSE_REPORT_LINES_ALL.EXPENDITURE_TYPE
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TablePA_EXP_ORGS_IT AP_EXPENSE_REPORT_LINES_ALL.EXPENDITURE_ORGANIZATION_ID
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TableFND_CURRENCIES AP_EXPENSE_REPORT_LINES_ALL.RECEIPT_CURRENCY_CODE
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TableAP_CREDIT_CARD_TRXNS_ALL AP_EXPENSE_REPORT_LINES_ALL.CREDIT_CARD_TRX_ID
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TableAP_INVOICES_ALL AP_EXPENSE_REPORT_LINES_ALL.COMPANY_PREPAID_INVOICE_ID
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TableAP_POL_LOCATIONS_B AP_EXPENSE_REPORT_LINES_ALL.LOCATION_ID
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TableAP_POL_LOCATIONS_B AP_EXPENSE_REPORT_LINES_ALL.LOCATION_TO_ID
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_EXPENSE_REPORT_LINES_ALL.CODE_COMBINATION_ID
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I AP_EXPENSE_REPORT_LINES_ALL.SET_OF_BOOKS_ID
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TableFND_CURRENCIES AP_EXPENSE_REPORT_LINES_ALL.CURRENCY_CODE
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES AP_EXPENSE_REPORT_LINES_ALL.EXCHANGE_RATE_TYPE
AP_EXPENSE_REPORT_LINES_ALL FK Joins to TableAP_AWT_GROUPS AP_EXPENSE_REPORT_LINES_ALL.AWT_GROUP_ID
TableAP_EXP_REPORT_DISTS_ALL FK Joins to AP_EXPENSE_REPORT_LINES_ALL AP_EXP_REPORT_DISTS_ALL.REPORT_LINE_ID
TableOIE_ATTENDEES_ALL FK Joins to AP_EXPENSE_REPORT_LINES_ALL OIE_ATTENDEES_ALL.REPORT_LINE_ID
TableOIE_PDM_DAILY_BREAKUPS FK Joins to AP_EXPENSE_REPORT_LINES_ALL OIE_PDM_DAILY_BREAKUPS.REPORT_LINE_ID
TableOIE_PDM_DESTINATIONS FK Joins to AP_EXPENSE_REPORT_LINES_ALL OIE_PDM_DESTINATIONS.REPORT_LINE_ID