APPS.JMF_SHIKYU_PO_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 58: --| hr_organization_information, instead of |

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. |
62: --| 02/16/2006 vchu Bug fix for 4997572: Changed the |

Line 272: FROM HR_ORGANIZATION_INFORMATION hoi

268: INTO l_vendor_id
269: , l_vendor_site_id
270: , l_interface_header_id
271: , l_interface_line_id
272: FROM HR_ORGANIZATION_INFORMATION hoi
273: WHERE hoi.organization_id = l_subcontract_orders_rec.oem_organization_id
274: AND hoi.org_information_context = 'Customer/Supplier Association';
275:
276: IF g_log_enabled THEN

Line 297: -- set of books by joining with the hr_organization_information table,

293: AND ood.organization_id = l_subcontract_orders_rec.oem_organization_id;
294: */
295:
296: -- Bug 4912497: Modified this query to get the currency from the current
297: -- set of books by joining with the hr_organization_information table,
298: -- instead of the org_organization_definitions view, which has introduced
299: -- the FTS on FND_PRODUCT_GROUPS and GL_LEDGERS
300:
301: SELECT glb.currency_code

Line 303: FROM hr_organization_information hoi

299: -- the FTS on FND_PRODUCT_GROUPS and GL_LEDGERS
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;