APPS.JMF_SHIKYU_PO_PVT dependencies on GL_SETS_OF_BOOKS

Line 57: --| gl_sets_of_books table with |

53: --| concurrent request completes sooner, |
54: --| which should be the normal case. |
55: --| 02/08/2006 vchu Bug fix for 4912497: Modified the query |
56: --| to get the currency by joining the |
57: --| gl_sets_of_books table with |
58: --| hr_organization_information, instead of |
59: --| the org_organization_definitions view, |
60: --| which has introduced Full Table Scan on |
61: --| FND_PRODUCT_GROUPS and GL_LEDGERS. |

Line 291: , gl_sets_of_books glb

287: /*
288: SELECT glb.currency_code
289: INTO l_currency_code
290: FROM org_organization_definitions ood
291: , gl_sets_of_books glb
292: WHERE ood.set_of_books_id = glb.set_of_books_id
293: AND ood.organization_id = l_subcontract_orders_rec.oem_organization_id;
294: */
295:

Line 304: , gl_sets_of_books glb

300:
301: SELECT glb.currency_code
302: INTO l_currency_code
303: FROM hr_organization_information hoi
304: , gl_sets_of_books glb
305: WHERE hoi.organization_id = l_subcontract_orders_rec.oem_organization_id
306: AND org_information_context = 'Accounting Information'
307: AND TO_NUMBER(hoi.org_information1) = glb.set_of_books_id;
308: