R12 SLA Details Queries for Inventory (Item Level) and Financials
$30-250 USD
Đã đóng
Đã đăng vào gần 12 năm trước
$30-250 USD
Thanh toán khi bàn giao
This is for Oracle R12 (12.1.3) verison SLA Details.
Need SLA Details Query Posted to GL by following Modules to Match Module Total with GL Summary Value.
1. Inventory (OM, INV, PM, PO, CST)
2. Payables
3. Receivables
4. Fixed Assets
5. Cash Management
Two Details Queries to compare with GL
1. Inventory
2. Financials (AR,AP,FA,CM)
Please send your approach for the solution to assign this job to you.
thanks
HI, I am new Freelancer.I work as an IT professional.I expertise in Oracle/PLSQL. I can do this project if given some more details on the scope and deliverable of the project.
Hi,
We have already delivered this kind of work recently where in we were sending SLA transaction details and GL details to one of the external systems.
Please provide more details.
Looking forward to work with you
we can link the tables as shown below
xla_transaction_entities ent,
xla_ae_headers aeh,
xla_ae_lines ael
where ent.application_id = 200
and inv.invoice_id = ent.source_id_int_1
and ent.entity_code = 'AP_INVOICES'
and ent.entity_id = aeh.entity_id
and aeh.ae_header_id = ael.ae_header_id