DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 11305: from oe_gl_sets_of_books_v ogsob, org_organization_definitions ood, wms_wp_wave_headers_b wwh

11301: --12371804 get currency code once instead of fetching each time inside of loop
11302: --this is because a wave can only have orders from one org
11303: select currency_code
11304: into G_SOB_CURRENCY
11305: from oe_gl_sets_of_books_v ogsob, org_organization_definitions ood, wms_wp_wave_headers_b wwh
11306: where wwh.wave_header_id = p_wave_header_id
11307: and wwh.organization_id = ood.organization_id
11308: and ood.set_of_books_id = ogsob.set_of_books_id;
11309: for l_value in c_net_value loop