VIEW: AP.AP_INVOICE_LINES_ALL#

Source

View Text - Preformatted

select INVOICE_ID INVOICE_ID, LINE_NUMBER LINE_NUMBER, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE, REQUESTER_ID REQUESTER_ID, DESCRIPTION DESCRIPTION, LINE_SOURCE LINE_SOURCE, ORG_ID ORG_ID, LINE_GROUP_NUMBER LINE_GROUP_NUMBER, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_DESCRIPTION ITEM_DESCRIPTION, SERIAL_NUMBER SERIAL_NUMBER, MANUFACTURER MANUFACTURER, MODEL_NUMBER MODEL_NUMBER, WARRANTY_NUMBER WARRANTY_NUMBER, GENERATE_DISTS GENERATE_DISTS, MATCH_TYPE MATCH_TYPE, DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID, ACCOUNT_SEGMENT ACCOUNT_SEGMENT, BALANCING_SEGMENT BALANCING_SEGMENT, COST_CENTER_SEGMENT COST_CENTER_SEGMENT, OVERLAY_DIST_CODE_CONCAT OVERLAY_DIST_CODE_CONCAT, DEFAULT_DIST_CCID DEFAULT_DIST_CCID, PRORATE_ACROSS_ALL_ITEMS PRORATE_ACROSS_ALL_ITEMS, ACCOUNTING_DATE ACCOUNTING_DATE, PERIOD_NAME PERIOD_NAME, DEFERRED_ACCTG_FLAG DEFERRED_ACCTG_FLAG, DEF_ACCTG_START_DATE DEF_ACCTG_START_DATE, DEF_ACCTG_END_DATE DEF_ACCTG_END_DATE, DEF_ACCTG_NUMBER_OF_PERIODS DEF_ACCTG_NUMBER_OF_PERIODS, DEF_ACCTG_PERIOD_TYPE DEF_ACCTG_PERIOD_TYPE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, AMOUNT AMOUNT, BASE_AMOUNT BASE_AMOUNT, ROUNDING_AMT ROUNDING_AMT, QUANTITY_INVOICED QUANTITY_INVOICED, UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE, UNIT_PRICE UNIT_PRICE, WFAPPROVAL_STATUS WFAPPROVAL_STATUS, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, DISCARDED_FLAG DISCARDED_FLAG, ORIGINAL_AMOUNT ORIGINAL_AMOUNT, ORIGINAL_BASE_AMOUNT ORIGINAL_BASE_AMOUNT, ORIGINAL_ROUNDING_AMT ORIGINAL_ROUNDING_AMT, CANCELLED_FLAG CANCELLED_FLAG, INCOME_TAX_REGION INCOME_TAX_REGION, TYPE_1099 TYPE_1099, STAT_AMOUNT STAT_AMOUNT, PREPAY_INVOICE_ID PREPAY_INVOICE_ID, PREPAY_LINE_NUMBER PREPAY_LINE_NUMBER, INVOICE_INCLUDES_PREPAY_FLAG INVOICE_INCLUDES_PREPAY_FLAG, CORRECTED_INV_ID CORRECTED_INV_ID, CORRECTED_LINE_NUMBER CORRECTED_LINE_NUMBER, PO_HEADER_ID PO_HEADER_ID, PO_LINE_ID PO_LINE_ID, PO_RELEASE_ID PO_RELEASE_ID, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, FINAL_MATCH_FLAG FINAL_MATCH_FLAG, ASSETS_TRACKING_FLAG ASSETS_TRACKING_FLAG, ASSET_BOOK_TYPE_CODE ASSET_BOOK_TYPE_CODE, ASSET_CATEGORY_ID ASSET_CATEGORY_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, PA_QUANTITY PA_QUANTITY, PA_CC_AR_INVOICE_ID PA_CC_AR_INVOICE_ID, PA_CC_AR_INVOICE_LINE_NUM PA_CC_AR_INVOICE_LINE_NUM, PA_CC_PROCESSED_CODE PA_CC_PROCESSED_CODE, AWARD_ID AWARD_ID, AWT_GROUP_ID AWT_GROUP_ID, REFERENCE_1 REFERENCE_1, REFERENCE_2 REFERENCE_2, RECEIPT_VERIFIED_FLAG RECEIPT_VERIFIED_FLAG, RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG, RECEIPT_MISSING_FLAG RECEIPT_MISSING_FLAG, JUSTIFICATION JUSTIFICATION, EXPENSE_GROUP EXPENSE_GROUP, START_EXPENSE_DATE START_EXPENSE_DATE, END_EXPENSE_DATE END_EXPENSE_DATE, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE, RECEIPT_CONVERSION_RATE RECEIPT_CONVERSION_RATE, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT, DAILY_AMOUNT DAILY_AMOUNT, WEB_PARAMETER_ID WEB_PARAMETER_ID, ADJUSTMENT_REASON ADJUSTMENT_REASON, MERCHANT_DOCUMENT_NUMBER MERCHANT_DOCUMENT_NUMBER, MERCHANT_NAME#1 MERCHANT_NAME, MERCHANT_REFERENCE MERCHANT_REFERENCE, MERCHANT_TAX_REG_NUMBER MERCHANT_TAX_REG_NUMBER, MERCHANT_TAXPAYER_ID MERCHANT_TAXPAYER_ID, COUNTRY_OF_SUPPLY COUNTRY_OF_SUPPLY, CREDIT_CARD_TRX_ID CREDIT_CARD_TRX_ID, COMPANY_PREPAID_INVOICE_ID COMPANY_PREPAID_INVOICE_ID, CC_REVERSAL_FLAG CC_REVERSAL_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, LINE_SELECTED_FOR_APPL_FLAG LINE_SELECTED_FOR_APPL_FLAG, PREPAY_APPL_REQUEST_ID PREPAY_APPL_REQUEST_ID, APPLICATION_ID APPLICATION_ID, PRODUCT_TABLE PRODUCT_TABLE, REFERENCE_KEY1 REFERENCE_KEY1, REFERENCE_KEY2 REFERENCE_KEY2, REFERENCE_KEY3 REFERENCE_KEY3, REFERENCE_KEY4 REFERENCE_KEY4, REFERENCE_KEY5 REFERENCE_KEY5, PURCHASING_CATEGORY_ID PURCHASING_CATEGORY_ID, COST_FACTOR_ID COST_FACTOR_ID, CONTROL_AMOUNT CONTROL_AMOUNT, ASSESSABLE_VALUE ASSESSABLE_VALUE, TOTAL_REC_TAX_AMOUNT TOTAL_REC_TAX_AMOUNT, TOTAL_NREC_TAX_AMOUNT TOTAL_NREC_TAX_AMOUNT, TOTAL_REC_TAX_AMT_FUNCL_CURR TOTAL_REC_TAX_AMT_FUNCL_CURR, TOTAL_NREC_TAX_AMT_FUNCL_CURR TOTAL_NREC_TAX_AMT_FUNCL_CURR, INCLUDED_TAX_AMOUNT INCLUDED_TAX_AMOUNT, PRIMARY_INTENDED_USE PRIMARY_INTENDED_USE, TAX_ALREADY_CALCULATED_FLAG TAX_ALREADY_CALCULATED_FLAG, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, PRODUCT_TYPE PRODUCT_TYPE, PRODUCT_CATEGORY PRODUCT_CATEGORY, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY, SUMMARY_TAX_LINE_ID SUMMARY_TAX_LINE_ID, TAX_REGIME_CODE TAX_REGIME_CODE, TAX TAX, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE, TAX_STATUS_CODE TAX_STATUS_CODE, TAX_RATE_ID TAX_RATE_ID, TAX_RATE_CODE TAX_RATE_CODE, TAX_RATE TAX_RATE, TAX_CODE_ID TAX_CODE_ID, HISTORICAL_FLAG HISTORICAL_FLAG, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID, SOURCE_EVENT_CLASS_CODE SOURCE_EVENT_CLASS_CODE, SOURCE_ENTITY_CODE SOURCE_ENTITY_CODE, SOURCE_TRX_ID SOURCE_TRX_ID, SOURCE_LINE_ID SOURCE_LINE_ID, SOURCE_TRX_LEVEL_TYPE SOURCE_TRX_LEVEL_TYPE, RETAINED_AMOUNT RETAINED_AMOUNT, RETAINED_AMOUNT_REMAINING RETAINED_AMOUNT_REMAINING, RETAINED_INVOICE_ID RETAINED_INVOICE_ID, RETAINED_LINE_NUMBER RETAINED_LINE_NUMBER, LINE_SELECTED_FOR_RELEASE_FLAG LINE_SELECTED_FOR_RELEASE_FLAG, LINE_OWNER_ROLE LINE_OWNER_ROLE, DISPUTABLE_FLAG DISPUTABLE_FLAG, RCV_SHIPMENT_LINE_ID RCV_SHIPMENT_LINE_ID, AIL_INVOICE_ID AIL_INVOICE_ID, AIL_DISTRIBUTION_LINE_NUMBER AIL_DISTRIBUTION_LINE_NUMBER, AIL_INVOICE_ID2 AIL_INVOICE_ID2, AIL_DISTRIBUTION_LINE_NUMBER2 AIL_DISTRIBUTION_LINE_NUMBER2, AIL_INVOICE_ID3 AIL_INVOICE_ID3, AIL_DISTRIBUTION_LINE_NUMBER3 AIL_DISTRIBUTION_LINE_NUMBER3, AIL_INVOICE_ID4 AIL_INVOICE_ID4, PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID from "AP"."AP_INVOICE_LINES_ALL"

View Text - HTML Formatted

SELECT INVOICE_ID INVOICE_ID
, LINE_NUMBER LINE_NUMBER
, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE
, REQUESTER_ID REQUESTER_ID
, DESCRIPTION DESCRIPTION
, LINE_SOURCE LINE_SOURCE
, ORG_ID ORG_ID
, LINE_GROUP_NUMBER LINE_GROUP_NUMBER
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, SERIAL_NUMBER SERIAL_NUMBER
, MANUFACTURER MANUFACTURER
, MODEL_NUMBER MODEL_NUMBER
, WARRANTY_NUMBER WARRANTY_NUMBER
, GENERATE_DISTS GENERATE_DISTS
, MATCH_TYPE MATCH_TYPE
, DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, ACCOUNT_SEGMENT ACCOUNT_SEGMENT
, BALANCING_SEGMENT BALANCING_SEGMENT
, COST_CENTER_SEGMENT COST_CENTER_SEGMENT
, OVERLAY_DIST_CODE_CONCAT OVERLAY_DIST_CODE_CONCAT
, DEFAULT_DIST_CCID DEFAULT_DIST_CCID
, PRORATE_ACROSS_ALL_ITEMS PRORATE_ACROSS_ALL_ITEMS
, ACCOUNTING_DATE ACCOUNTING_DATE
, PERIOD_NAME PERIOD_NAME
, DEFERRED_ACCTG_FLAG DEFERRED_ACCTG_FLAG
, DEF_ACCTG_START_DATE DEF_ACCTG_START_DATE
, DEF_ACCTG_END_DATE DEF_ACCTG_END_DATE
, DEF_ACCTG_NUMBER_OF_PERIODS DEF_ACCTG_NUMBER_OF_PERIODS
, DEF_ACCTG_PERIOD_TYPE DEF_ACCTG_PERIOD_TYPE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AMOUNT AMOUNT
, BASE_AMOUNT BASE_AMOUNT
, ROUNDING_AMT ROUNDING_AMT
, QUANTITY_INVOICED QUANTITY_INVOICED
, UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE
, UNIT_PRICE UNIT_PRICE
, WFAPPROVAL_STATUS WFAPPROVAL_STATUS
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, DISCARDED_FLAG DISCARDED_FLAG
, ORIGINAL_AMOUNT ORIGINAL_AMOUNT
, ORIGINAL_BASE_AMOUNT ORIGINAL_BASE_AMOUNT
, ORIGINAL_ROUNDING_AMT ORIGINAL_ROUNDING_AMT
, CANCELLED_FLAG CANCELLED_FLAG
, INCOME_TAX_REGION INCOME_TAX_REGION
, TYPE_1099 TYPE_1099
, STAT_AMOUNT STAT_AMOUNT
, PREPAY_INVOICE_ID PREPAY_INVOICE_ID
, PREPAY_LINE_NUMBER PREPAY_LINE_NUMBER
, INVOICE_INCLUDES_PREPAY_FLAG INVOICE_INCLUDES_PREPAY_FLAG
, CORRECTED_INV_ID CORRECTED_INV_ID
, CORRECTED_LINE_NUMBER CORRECTED_LINE_NUMBER
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_ID PO_LINE_ID
, PO_RELEASE_ID PO_RELEASE_ID
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, FINAL_MATCH_FLAG FINAL_MATCH_FLAG
, ASSETS_TRACKING_FLAG ASSETS_TRACKING_FLAG
, ASSET_BOOK_TYPE_CODE ASSET_BOOK_TYPE_CODE
, ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, PA_QUANTITY PA_QUANTITY
, PA_CC_AR_INVOICE_ID PA_CC_AR_INVOICE_ID
, PA_CC_AR_INVOICE_LINE_NUM PA_CC_AR_INVOICE_LINE_NUM
, PA_CC_PROCESSED_CODE PA_CC_PROCESSED_CODE
, AWARD_ID AWARD_ID
, AWT_GROUP_ID AWT_GROUP_ID
, REFERENCE_1 REFERENCE_1
, REFERENCE_2 REFERENCE_2
, RECEIPT_VERIFIED_FLAG RECEIPT_VERIFIED_FLAG
, RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG
, RECEIPT_MISSING_FLAG RECEIPT_MISSING_FLAG
, JUSTIFICATION JUSTIFICATION
, EXPENSE_GROUP EXPENSE_GROUP
, START_EXPENSE_DATE START_EXPENSE_DATE
, END_EXPENSE_DATE END_EXPENSE_DATE
, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE
, RECEIPT_CONVERSION_RATE RECEIPT_CONVERSION_RATE
, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT
, DAILY_AMOUNT DAILY_AMOUNT
, WEB_PARAMETER_ID WEB_PARAMETER_ID
, ADJUSTMENT_REASON ADJUSTMENT_REASON
, MERCHANT_DOCUMENT_NUMBER MERCHANT_DOCUMENT_NUMBER
, MERCHANT_NAME#1 MERCHANT_NAME
, MERCHANT_REFERENCE MERCHANT_REFERENCE
, MERCHANT_TAX_REG_NUMBER MERCHANT_TAX_REG_NUMBER
, MERCHANT_TAXPAYER_ID MERCHANT_TAXPAYER_ID
, COUNTRY_OF_SUPPLY COUNTRY_OF_SUPPLY
, CREDIT_CARD_TRX_ID CREDIT_CARD_TRX_ID
, COMPANY_PREPAID_INVOICE_ID COMPANY_PREPAID_INVOICE_ID
, CC_REVERSAL_FLAG CC_REVERSAL_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, LINE_SELECTED_FOR_APPL_FLAG LINE_SELECTED_FOR_APPL_FLAG
, PREPAY_APPL_REQUEST_ID PREPAY_APPL_REQUEST_ID
, APPLICATION_ID APPLICATION_ID
, PRODUCT_TABLE PRODUCT_TABLE
, REFERENCE_KEY1 REFERENCE_KEY1
, REFERENCE_KEY2 REFERENCE_KEY2
, REFERENCE_KEY3 REFERENCE_KEY3
, REFERENCE_KEY4 REFERENCE_KEY4
, REFERENCE_KEY5 REFERENCE_KEY5
, PURCHASING_CATEGORY_ID PURCHASING_CATEGORY_ID
, COST_FACTOR_ID COST_FACTOR_ID
, CONTROL_AMOUNT CONTROL_AMOUNT
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, TOTAL_REC_TAX_AMOUNT TOTAL_REC_TAX_AMOUNT
, TOTAL_NREC_TAX_AMOUNT TOTAL_NREC_TAX_AMOUNT
, TOTAL_REC_TAX_AMT_FUNCL_CURR TOTAL_REC_TAX_AMT_FUNCL_CURR
, TOTAL_NREC_TAX_AMT_FUNCL_CURR TOTAL_NREC_TAX_AMT_FUNCL_CURR
, INCLUDED_TAX_AMOUNT INCLUDED_TAX_AMOUNT
, PRIMARY_INTENDED_USE PRIMARY_INTENDED_USE
, TAX_ALREADY_CALCULATED_FLAG TAX_ALREADY_CALCULATED_FLAG
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, PRODUCT_TYPE PRODUCT_TYPE
, PRODUCT_CATEGORY PRODUCT_CATEGORY
, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION
, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS
, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY
, SUMMARY_TAX_LINE_ID SUMMARY_TAX_LINE_ID
, TAX_REGIME_CODE TAX_REGIME_CODE
, TAX TAX
, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE
, TAX_STATUS_CODE TAX_STATUS_CODE
, TAX_RATE_ID TAX_RATE_ID
, TAX_RATE_CODE TAX_RATE_CODE
, TAX_RATE TAX_RATE
, TAX_CODE_ID TAX_CODE_ID
, HISTORICAL_FLAG HISTORICAL_FLAG
, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, SOURCE_EVENT_CLASS_CODE SOURCE_EVENT_CLASS_CODE
, SOURCE_ENTITY_CODE SOURCE_ENTITY_CODE
, SOURCE_TRX_ID SOURCE_TRX_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, SOURCE_TRX_LEVEL_TYPE SOURCE_TRX_LEVEL_TYPE
, RETAINED_AMOUNT RETAINED_AMOUNT
, RETAINED_AMOUNT_REMAINING RETAINED_AMOUNT_REMAINING
, RETAINED_INVOICE_ID RETAINED_INVOICE_ID
, RETAINED_LINE_NUMBER RETAINED_LINE_NUMBER
, LINE_SELECTED_FOR_RELEASE_FLAG LINE_SELECTED_FOR_RELEASE_FLAG
, LINE_OWNER_ROLE LINE_OWNER_ROLE
, DISPUTABLE_FLAG DISPUTABLE_FLAG
, RCV_SHIPMENT_LINE_ID RCV_SHIPMENT_LINE_ID
, AIL_INVOICE_ID AIL_INVOICE_ID
, AIL_DISTRIBUTION_LINE_NUMBER AIL_DISTRIBUTION_LINE_NUMBER
, AIL_INVOICE_ID2 AIL_INVOICE_ID2
, AIL_DISTRIBUTION_LINE_NUMBER2 AIL_DISTRIBUTION_LINE_NUMBER2
, AIL_INVOICE_ID3 AIL_INVOICE_ID3
, AIL_DISTRIBUTION_LINE_NUMBER3 AIL_DISTRIBUTION_LINE_NUMBER3
, AIL_INVOICE_ID4 AIL_INVOICE_ID4
, PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID
FROM "AP"."AP_INVOICE_LINES_ALL"