[Home] [Help]
View: AP_TRIAL_BALANCE_MRC_V
Product: | AP - Payables |
Description: | - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT INVOICE_ID
, ACCOUNTING_DATE
, PAYMENT_AMOUNT
, DISTRIBUTION_AMOUNT
, DISTRIBUTION_LINE_NUMBER
FROM AP_MC_TRIAL_BALANCE
WHERE SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99 )
Columns
Name |
INVOICE_ID |
ACCOUNTING_DATE |
PAYMENT_AMOUNT |
DISTRIBUTION_AMOUNT |
DISTRIBUTION_LINE_NUMBER |