Product: | PO - Purchasing |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT TRANSACTION_UNIT_PRICE
, AVG_RECEIPT_PRICE
, TRANSACTION_AMOUNT
, TRANSACTION_SOURCE_CODE
, WRITE_OFF_FLAG
, WRITE_OFF_ID
, DESTINATION_TYPE_CODE
, REASON_ID
, COMMENTS
, PERIOD_NAME
, NET_PO_LINE_AMOUNT
, INVOICE_PRICE_VARIANCE
, AGING_DATE
, ORG_ID
, TRANSACTION_DATE
, INVENTORY_ITEM_ID
, TRANSACTION_QUANTITY
, PO_HEADER_ID
, PO_LINE_NUM
, PO_LINE_ID
, LINE_LOCATION_ID
, VENDOR_NAME
, INVOICE_ID
, INVOICE_LINE_NUM
, LINE_MATCH_ORDER
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TRANSACTION_ORGANIZATION_ID
, VENDOR_ID
, ITEM_MASTER_ORGANIZATION_ID
, ACCRUAL_ACCOUNT_ID
, ACCRUAL_CODE
, PO_TRANSACTION_TYPE
, INVOICE_NUM
, RECEIPT_NUM
, PO_TRANSACTION_ID
, INV_TRANSACTION_ID
, INV_TRANSACTION_TYPE_ID
, WIP_TRANSACTION_ID
, WIP_TRANSACTION_TYPE_ID
, PO_UNIT_OF_MEASURE
, PRIMARY_UNIT_OF_MEASURE
, NET_PO_LINE_QUANTITY
, PO_NUM
, PO_DISTRIBUTION_ID
, VENDOR_NAME_ALT
, ADJUSTMENT_TRANSACTION
, ENTERED_TRANSACTION_AMOUNT
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
FROM PO_ACCRUAL_RECONCILE_TEMP_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)