VIEW: PO.PO_ACCRUAL_WRITE_OFFS_ALL#

Source

View Text - Preformatted

select WRITE_OFF_ID WRITE_OFF_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PERIOD_NAME PERIOD_NAME, WRITE_OFF_GL_DATE WRITE_OFF_GL_DATE, TRANSACTION_ORGANIZATION_ID TRANSACTION_ORGANIZATION_ID, ITEM_MASTER_ORGANIZATION_ID ITEM_MASTER_ORGANIZATION_ID, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID, ACCRUAL_CODE ACCRUAL_CODE, PO_TRANSACTION_TYPE PO_TRANSACTION_TYPE, TRANSACTION_DATE TRANSACTION_DATE, INVOICE_NUM INVOICE_NUM, RECEIPT_NUM RECEIPT_NUM, PO_TRANSACTION_ID PO_TRANSACTION_ID, INV_TRANSACTION_ID INV_TRANSACTION_ID, INV_TRANSACTION_TYPE_ID INV_TRANSACTION_TYPE_ID, WIP_TRANSACTION_ID WIP_TRANSACTION_ID, WIP_TRANSACTION_TYPE_ID WIP_TRANSACTION_TYPE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PO_UNIT_OF_MEASURE PO_UNIT_OF_MEASURE, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, NET_PO_LINE_QUANTITY NET_PO_LINE_QUANTITY, PO_HEADER_ID PO_HEADER_ID, PO_NUM PO_NUM, PO_LINE_NUM PO_LINE_NUM, PO_LINE_ID PO_LINE_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, VENDOR_ID VENDOR_ID, VENDOR_NAME VENDOR_NAME, TRANSACTION_UNIT_PRICE TRANSACTION_UNIT_PRICE, INVOICE_ID INVOICE_ID, INVOICE_LINE_NUM INVOICE_LINE_NUM, AVG_RECEIPT_PRICE AVG_RECEIPT_PRICE, TRANSACTION_AMOUNT TRANSACTION_AMOUNT, LINE_MATCH_ORDER LINE_MATCH_ORDER, TRANSACTION_SOURCE_CODE TRANSACTION_SOURCE_CODE, REASON_ID REASON_ID, COMMENTS COMMENTS, WRITE_OFF_CODE WRITE_OFF_CODE, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, INVOICE_PRICE_VARIANCE INVOICE_PRICE_VARIANCE, ORG_ID ORG_ID, ADJUSTMENT_TRANSACTION ADJUSTMENT_TRANSACTION, ENTERED_TRANSACTION_AMOUNT ENTERED_TRANSACTION_AMOUNT, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE from "PO"."PO_ACCRUAL_WRITE_OFFS_ALL"

View Text - HTML Formatted

SELECT WRITE_OFF_ID WRITE_OFF_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PERIOD_NAME PERIOD_NAME
, WRITE_OFF_GL_DATE WRITE_OFF_GL_DATE
, TRANSACTION_ORGANIZATION_ID TRANSACTION_ORGANIZATION_ID
, ITEM_MASTER_ORGANIZATION_ID ITEM_MASTER_ORGANIZATION_ID
, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, ACCRUAL_CODE ACCRUAL_CODE
, PO_TRANSACTION_TYPE PO_TRANSACTION_TYPE
, TRANSACTION_DATE TRANSACTION_DATE
, INVOICE_NUM INVOICE_NUM
, RECEIPT_NUM RECEIPT_NUM
, PO_TRANSACTION_ID PO_TRANSACTION_ID
, INV_TRANSACTION_ID INV_TRANSACTION_ID
, INV_TRANSACTION_TYPE_ID INV_TRANSACTION_TYPE_ID
, WIP_TRANSACTION_ID WIP_TRANSACTION_ID
, WIP_TRANSACTION_TYPE_ID WIP_TRANSACTION_TYPE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PO_UNIT_OF_MEASURE PO_UNIT_OF_MEASURE
, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, NET_PO_LINE_QUANTITY NET_PO_LINE_QUANTITY
, PO_HEADER_ID PO_HEADER_ID
, PO_NUM PO_NUM
, PO_LINE_NUM PO_LINE_NUM
, PO_LINE_ID PO_LINE_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, VENDOR_ID VENDOR_ID
, VENDOR_NAME VENDOR_NAME
, TRANSACTION_UNIT_PRICE TRANSACTION_UNIT_PRICE
, INVOICE_ID INVOICE_ID
, INVOICE_LINE_NUM INVOICE_LINE_NUM
, AVG_RECEIPT_PRICE AVG_RECEIPT_PRICE
, TRANSACTION_AMOUNT TRANSACTION_AMOUNT
, LINE_MATCH_ORDER LINE_MATCH_ORDER
, TRANSACTION_SOURCE_CODE TRANSACTION_SOURCE_CODE
, REASON_ID REASON_ID
, COMMENTS COMMENTS
, WRITE_OFF_CODE WRITE_OFF_CODE
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, INVOICE_PRICE_VARIANCE INVOICE_PRICE_VARIANCE
, ORG_ID ORG_ID
, ADJUSTMENT_TRANSACTION ADJUSTMENT_TRANSACTION
, ENTERED_TRANSACTION_AMOUNT ENTERED_TRANSACTION_AMOUNT
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
FROM "PO"."PO_ACCRUAL_WRITE_OFFS_ALL"