Tuesday, December 27, 2011
Gl BALANCE
INSERT INTO gl_interface
(ledger_id,
date_created,
actual_flag,
currency_code,
period_name,
segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
entered_dr,
entered_cr,
user_je_category_name,
user_je_source_name,
status,
accounting_date,
created_by,
code_combination_id,
USER_CURRENCY_CONVERSION_TYPE,
currency_conversion_date
)
VALUES (cv_int.ledger_id,--2021,--cv_int.ledger_id,
SYSDATE,
cv_int.actual_flag,
cv_int.currency_code,
cv_int.period_name,
cv_int.segment1,
cv_int.segment2,
cv_int.segment3,
cv_int.segment4,
cv_int.segment5,
cv_int.segment6,
cv_int.segment7,
cv_int.segment8,
cv_int.closing_balance_dr,
cv_int.closing_balance_cr,
cv_int.user_je_category_name,
cv_int.user_je_source_name,
'POSTED',
cv_int.accounting_date,
fnd_global.user_id,
cv_int.code_combination_id,
cv_int.USER_CURRENCY_CONVERSION_TYPE,
cv_int.currency_conversion_date
);
Labels:
GL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment