[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_EXPENSE_REPORT_LINES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_EXPENSE_REPORT_LINES_ALL
|
| Subobject Name: | |
| Status: | VALID |
AP_EXPENSE_REPORT_LINES_ALL stores detailed information about expense items for individual expense reports you enter. Your Oracle Payables application uses this information to create invoice distributions when you import expense reports using the Expense Report Import program.
This table corresponds to the tabbed regions of the Expense Reports window.
This table has no primary key.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_EXPENSE_REPORT_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 REPORT_LINE_ID
|
| AP_EXPENSE_REPORT_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
REPORT_HEADER_ID
|
| AP_EXPENSE_REPORT_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
REFERENCE_1
REFERENCE_2
|
| AP_EXPENSE_REPORT_LINES_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TASK_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REPORT_HEADER_ID | NUMBER | Yes | Expense report header identifier | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| CODE_COMBINATION_ID | NUMBER | Code combination identifier. | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Yes | Description of expense report item |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of books identifier |
| AMOUNT | NUMBER | Amount | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code |
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type for an item on a foreign currency expense report | |
| EXCHANGE_RATE | NUMBER | Exchange rate for a foreign currency | ||
| EXCHANGE_DATE | DATE | Date exchange rate is effective, usually accounting date of a transaction | ||
| VAT_CODE | VARCHAR2 | (30) | Tax code | |
| LINE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | Name of line type |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| STAT_AMOUNT | NUMBER | Statistical amount associated with an item | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | Transaction code for creating US Standard General Ledger journal entries | |
| USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (30) | USSGL Transaction Code Descriptive Flexfield context column | |
| PROJECT_ACCOUNTING_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield structure defining column for Oracle Projects expense report line | |
| PROJECT_ID | NUMBER | (15) | Project identifier for Oracle Projects expense report line | |
| TASK_ID | NUMBER | (15) | Task identifier for Oracle Projects expense report line | |
| EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | Orgaization identifier for Oracle Projects expense report line | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Expenditure type for Oracle Projects expense report line | |
| EXPENDITURE_ITEM_DATE | DATE | Item date for Oracle Projects expense report line | ||
| PA_QUANTITY | NUMBER | Quantity for Oracle Projects expense report line | ||
| DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Line number for invoice distribution line created from expense report line | |
| REFERENCE_1 | VARCHAR2 | (30) | Reference 1 | |
| REFERENCE_2 | VARCHAR2 | (30) | Reference 2 | |
| AWT_GROUP_ID | NUMBER | (15) | Withholding Tax group identifier | |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| RECEIPT_VERIFIED_FLAG | VARCHAR2 | (1) | Indicates whether your payables department received for the expense line. | |
| JUSTIFICATION_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether a justification is required for the expense line. | |
| RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether you payables department requires that a receipt be sent to them for the expense line. | |
| RECEIPT_MISSING_FLAG | VARCHAR2 | (1) | Indicates whether the employee does not possess a receipt for an expense line. | |
| JUSTIFICATION | VARCHAR2 | (240) | Reason the employee gave to justify incurring the expense. | |
| EXPENSE_GROUP | VARCHAR2 | (80) | User-defined label used to identify a group of expense lines contained on a single receipt, for example, a hotel bill. | |
| START_EXPENSE_DATE | DATE | Start date for expense | ||
| END_EXPENSE_DATE | DATE | End date for expense | ||
| RECEIPT_CURRENCY_CODE | VARCHAR2 | (15) | Indicates the code for the currency in which the expense line was incurred. | |
| RECEIPT_CONVERSION_RATE | NUMBER | The user-defined conversion rate between the receipt currency and the currency in which the expense report will be paid. | ||
| DAILY_AMOUNT | NUMBER | Indicates the amount charged daily for a multi-day receipt, for example, the daily rate of a rental car or hotel room. | ||
| RECEIPT_CURRENCY_AMOUNT | NUMBER | The amount that appears on the receipt. | ||
| WEB_PARAMETER_ID | NUMBER | Expense report item type identifier | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | Amount includes tax flag | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| ADJUSTMENT_REASON | VARCHAR2 | (240) | Reason your payables department adjusted (reduced) the expense line amount, or reason your payables department short paid an expense line. | |
| POLICY_SHORTPAY_FLAG | VARCHAR2 | (1) | Flag to indicate policy violation shortpay | |
| AWARD_ID | NUMBER | (15) | If Oracle Grants Accounting is installed, the award ID is used with data in project columns to track grant information | |
| MERCHANT_DOCUMENT_NUMBER | VARCHAR2 | (80) | Third party document number | |
| MERCHANT_REFERENCE | VARCHAR2 | (240) | Third party reference number | |
| MERCHANT_TAX_REG_NUMBER | VARCHAR2 | (80) | Third party tax registration number | |
| MERCHANT_TAXPAYER_ID | VARCHAR2 | (80) | Third party taxpayer identifier | |
| COUNTRY_OF_SUPPLY | VARCHAR2 | (5) | Country where services or goods were received | |
| TAX_CODE_OVERRIDE_FLAG | VARCHAR2 | (1) | Indicates whether the user has overwritten the tax code for the invoice distribution. The possible values for this flag are: Y and N | |
| TAX_CODE_ID | NUMBER | (15) | Tax code identifier | |
| CREDIT_CARD_TRX_ID | NUMBER | (15) | Identifies the credit card transaction from which the expense line is derived | |
| ITEMIZE_ID | NUMBER | (15) | No longer used | |
| PROJECT_NAME | VARCHAR2 | (30) | Temporary storage for project number when user enteres it manually and wants to save the expesne report | |
| TASK_NAME | VARCHAR2 | (30) | Temporary storage for task number when user enteres it manually and wants to save the expesne report | |
| COMPANY_PREPAID_INVOICE_ID | NUMBER | (15) | Invoice ID when this line is an prepaid credit card transaction | |
| PA_INTERFACED_FLAG | VARCHAR2 | (1) | This flag is set to Y if this is a project-related Oracle Internet Expense expense report line that has been transferred to Oracle Projects | |
| PROJECT_NUMBER | VARCHAR2 | (30) | Project number for project-related expense report line | |
| TASK_NUMBER | VARCHAR2 | (30) | Task number for project-related expense report line | |
| AWARD_NUMBER | VARCHAR2 | (15) | Award Number | |
| VEHICLE_CATEGORY_CODE | VARCHAR2 | (30) | Vehicle category. | |
| VEHICLE_TYPE | VARCHAR2 | (30) | Vehicle type. | |
| FUEL_TYPE | VARCHAR2 | (30) | Fuel type. | |
| NUMBER_PEOPLE | NUMBER | Number of passengers. | ||
| DAILY_DISTANCE | NUMBER | Daily distance. | ||
| DISTANCE_UNIT_CODE | VARCHAR2 | (30) | Distance unit. | |
| AVG_MILEAGE_RATE | NUMBER | Mileage rate. | ||
| DESTINATION_FROM | VARCHAR2 | (80) | Location from. | |
| DESTINATION_TO | VARCHAR2 | (80) | Location to. | |
| TRIP_DISTANCE | NUMBER | Trip distance. | ||
| LICENSE_PLATE_NUMBER | VARCHAR2 | (30) | License plate number. | |
| MILEAGE_RATE_ADJUSTED_FLAG | VARCHAR2 | (1) | Mileage rate adjusted status indicator | |
| LOCATION_ID | NUMBER | (15) | Location Id. | |
| NUM_PDM_DAYS1 | NUMBER | First day. | ||
| NUM_PDM_DAYS2 | NUMBER | Number of interim days. | ||
| NUM_PDM_DAYS3 | NUMBER | Last day. | ||
| PER_DIEM_RATE1 | NUMBER | Rate for first day. | ||
| PER_DIEM_RATE2 | NUMBER | Rate for interim days. | ||
| PER_DIEM_RATE3 | NUMBER | Rate for last day. | ||
| DEDUCTION_ADDITION_AMT1 | NUMBER | Total deduction/addition for first day. | ||
| DEDUCTION_ADDITION_AMT2 | NUMBER | Total deduction/addition for interim. | ||
| DEDUCTION_ADDITION_AMT3 | NUMBER | Total deduction/aaddition for last day. | ||
| NUM_FREE_BREAKFASTS1 | NUMBER | Number of free breakfasts for the first day. | ||
| NUM_FREE_LUNCHES1 | NUMBER | Number of free lunches for the first day. | ||
| NUM_FREE_DINNERS1 | NUMBER | Number of free dinners for the first day. | ||
| NUM_FREE_ACCOMMODATIONS1 | NUMBER | Number of free accommodations for the first day. | ||
| NUM_FREE_BREAKFASTS2 | NUMBER | Number of free breakfasts for interim. | ||
| NUM_FREE_LUNCHES2 | NUMBER | Number of free lunches for the interim. | ||
| NUM_FREE_DINNERS2 | NUMBER | Number of free dinners for the interim. | ||
| NUM_FREE_ACCOMMODATIONS2 | NUMBER | Number of free accommodations for interim. | ||
| NUM_FREE_BREAKFASTS3 | NUMBER | Number of free breakfasts for the last day. | ||
| NUM_FREE_LUNCHES3 | NUMBER | Number of free lunches for the last day. | ||
| NUM_FREE_DINNERS3 | NUMBER | Number of free dinners for the last day. | ||
| NUM_FREE_ACCOMMODATIONS3 | NUMBER | Number of free accommodations for last day. | ||
| ATTENDEES | VARCHAR2 | (240) | Attendees. | |
| NUMBER_ATTENDEES | NUMBER | Number of attendees. | ||
| TRAVEL_TYPE | VARCHAR2 | (30) | Travel type. | |
| TICKET_CLASS_CODE | VARCHAR2 | (30) | Ticket class code. | |
| TICKET_NUMBER | VARCHAR2 | (80) | Ticket number. | |
| FLIGHT_NUMBER | VARCHAR2 | (80) | Flight number. | |
| LOCATION_TO_ID | NUMBER | (15) | ID for Location To | |
| ITEMIZATION_PARENT_ID | NUMBER | Indicates a line's involvement in an itemization: if NULL, line is not involved in an itemization; if -1, line is a parent line for an itemization; if >0, line is an itemized child line and this value is the parent line's REPORT_LINE_ID | ||
| FLEX_CONCATENATED | VARCHAR2 | (240) | Cost center for the expense line. | |
| FUNC_CURRENCY_AMT | NUMBER | Reimbursement amount in functional currency. | ||
| LOCATION | VARCHAR2 | (80) | Location Name | |
| CATEGORY_CODE | VARCHAR2 | (30) | Category Code | |
| ADJUSTMENT_REASON_CODE | VARCHAR2 | (30) | Identifies the reason why the expense line was adjusted. | |
| AP_VALIDATION_ERROR | VARCHAR2 | (240) | Contains errors encountered during validation | |
| SUBMITTED_AMOUNT | NUMBER | The original reimbursement amount. This column is populated if the auditor adjusts the reimbursement amount | ||
| REPORT_LINE_ID | NUMBER | (15) | Report Line Identifier | |
| ALLOCATION_REASON | VARCHAR2 | (240) | Reason for updating allocations for this report line. | |
| ALLOCATION_SPLIT_CODE | VARCHAR2 | (30) | Indicates how this expense line is split. A null value indicates that the line is not split. | |
| RATE_PER_PASSENGER | NUMBER | Passenger rate used | ||
| PASSENGER_RATE_TYPE | VARCHAR2 | (30) | Passenger rate type. | |
| PASSENGER_AMOUNT | NUMBER | Passenger amount. | ||
| RANGE_LOW | NUMBER | Distance threshold low range | ||
| RANGE_HIGH | NUMBER | Distance threshold high range | ||
| UOM_DAYS | NUMBER | Unit of measure in days for per diem expense type. | ||
| IMAGE_RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Image Receipt Required Flag | |
| RECEIPTS_ISSUE | VARCHAR2 | (240) | Receipts Issue | |
| ADJUSTMENT_REASON_COPY | VARCHAR2 | (30) | Holds the value of adjustment reason for manager approval notification | |
| MERCHANT_NAME#1 | VARCHAR2 | (240) | Third party name |
Cut, paste (and edit) the following text to query this object:
SELECT REPORT_HEADER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CODE_COMBINATION_ID
, ITEM_DESCRIPTION
, SET_OF_BOOKS_ID
, AMOUNT
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CURRENCY_CODE
, EXCHANGE_RATE_TYPE
, EXCHANGE_RATE
, EXCHANGE_DATE
, VAT_CODE
, LINE_TYPE_LOOKUP_CODE
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, STAT_AMOUNT
, USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT
, PROJECT_ACCOUNTING_CONTEXT
, PROJECT_ID
, TASK_ID
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, PA_QUANTITY
, DISTRIBUTION_LINE_NUMBER
, REFERENCE_1
, REFERENCE_2
, AWT_GROUP_ID
, ORG_ID
, RECEIPT_VERIFIED_FLAG
, JUSTIFICATION_REQUIRED_FLAG
, RECEIPT_REQUIRED_FLAG
, RECEIPT_MISSING_FLAG
, JUSTIFICATION
, EXPENSE_GROUP
, START_EXPENSE_DATE
, END_EXPENSE_DATE
, RECEIPT_CURRENCY_CODE
, RECEIPT_CONVERSION_RATE
, DAILY_AMOUNT
, RECEIPT_CURRENCY_AMOUNT
, WEB_PARAMETER_ID
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, AMOUNT_INCLUDES_TAX_FLAG
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, ADJUSTMENT_REASON
, POLICY_SHORTPAY_FLAG
, AWARD_ID
, MERCHANT_DOCUMENT_NUMBER
, MERCHANT_REFERENCE
, MERCHANT_TAX_REG_NUMBER
, MERCHANT_TAXPAYER_ID
, COUNTRY_OF_SUPPLY
, TAX_CODE_OVERRIDE_FLAG
, TAX_CODE_ID
, CREDIT_CARD_TRX_ID
, ITEMIZE_ID
, PROJECT_NAME
, TASK_NAME
, COMPANY_PREPAID_INVOICE_ID
, PA_INTERFACED_FLAG
, PROJECT_NUMBER
, TASK_NUMBER
, AWARD_NUMBER
, VEHICLE_CATEGORY_CODE
, VEHICLE_TYPE
, FUEL_TYPE
, NUMBER_PEOPLE
, DAILY_DISTANCE
, DISTANCE_UNIT_CODE
, AVG_MILEAGE_RATE
, DESTINATION_FROM
, DESTINATION_TO
, TRIP_DISTANCE
, LICENSE_PLATE_NUMBER
, MILEAGE_RATE_ADJUSTED_FLAG
, LOCATION_ID
, NUM_PDM_DAYS1
, NUM_PDM_DAYS2
, NUM_PDM_DAYS3
, PER_DIEM_RATE1
, PER_DIEM_RATE2
, PER_DIEM_RATE3
, DEDUCTION_ADDITION_AMT1
, DEDUCTION_ADDITION_AMT2
, DEDUCTION_ADDITION_AMT3
, NUM_FREE_BREAKFASTS1
, NUM_FREE_LUNCHES1
, NUM_FREE_DINNERS1
, NUM_FREE_ACCOMMODATIONS1
, NUM_FREE_BREAKFASTS2
, NUM_FREE_LUNCHES2
, NUM_FREE_DINNERS2
, NUM_FREE_ACCOMMODATIONS2
, NUM_FREE_BREAKFASTS3
, NUM_FREE_LUNCHES3
, NUM_FREE_DINNERS3
, NUM_FREE_ACCOMMODATIONS3
, ATTENDEES
, NUMBER_ATTENDEES
, TRAVEL_TYPE
, TICKET_CLASS_CODE
, TICKET_NUMBER
, FLIGHT_NUMBER
, LOCATION_TO_ID
, ITEMIZATION_PARENT_ID
, FLEX_CONCATENATED
, FUNC_CURRENCY_AMT
, LOCATION
, CATEGORY_CODE
, ADJUSTMENT_REASON_CODE
, AP_VALIDATION_ERROR
, SUBMITTED_AMOUNT
, REPORT_LINE_ID
, ALLOCATION_REASON
, ALLOCATION_SPLIT_CODE
, RATE_PER_PASSENGER
, PASSENGER_RATE_TYPE
, PASSENGER_AMOUNT
, RANGE_LOW
, RANGE_HIGH
, UOM_DAYS
, IMAGE_RECEIPT_REQUIRED_FLAG
, RECEIPTS_ISSUE
, ADJUSTMENT_REASON_COPY
, MERCHANT_NAME#1
FROM AP.AP_EXPENSE_REPORT_LINES_ALL;
AP.AP_EXPENSE_REPORT_LINES_ALL does not reference any database object
AP.AP_EXPENSE_REPORT_LINES_ALL is referenced by following:
AP
AP_EXPENSE_REPORT_LINES_ALL#
|
|
|
|