DBA Data[Home] [Help]

APPS.INL_SHIPMENT_PVT dependencies on GL_SETS_OF_BOOKS

Line 4173: gl_sets_of_books gsb

4169: p_debug_info => l_debug_info) ;
4170: SELECT gsb.currency_code
4171: INTO l_func_curr_code
4172: FROM org_organization_definitions ood,
4173: gl_sets_of_books gsb
4174: WHERE gsb.set_of_books_id = ood.set_of_books_id
4175: AND organization_id = l_inv_org_id;
4176: l_debug_info := 'Get Country from Location';
4177: INL_LOGGING_PVT.Log_Statement (

Line 9736: --Bug#14044298 gl_sets_of_books gsb --BUG#8468830

9732: --Bug#14044298 inl_ship_lines sl ,
9733: inl_ship_headers sh ,
9734: inl_corr_matches_v m
9735: --Bug#14044298 org_organization_definitions ood, --BUG#8468830
9736: --Bug#14044298 gl_sets_of_books gsb --BUG#8468830
9737: WHERE
9738: sh.ship_header_id = p_ship_header_id
9739: --Bug#14044298 cl.charge_line_id (+) = DECODE (m.to_parent_table_name, 'INL_CHARGE_LINES', m.to_parent_table_id, NULL)
9740: --Bug#14044298 AND sl.ship_line_id (+) = DECODE (m.to_parent_table_name, 'INL_SHIP_LINES', m.to_parent_table_id, NULL)

Line 9767: --Bug#14044298 gl_sets_of_books gsb --BUG#8468830

9763: inl_ship_headers sh,
9764: inl_match_amounts ma,
9765: inl_corr_matches_v m
9766: --Bug#14044298 org_organization_definitions ood, --BUG#8468830
9767: --Bug#14044298 gl_sets_of_books gsb --BUG#8468830
9768: WHERE
9769: sh.ship_header_id = p_ship_header_id
9770: AND ma.match_amount_id = m.match_amount_id
9771: AND m.ship_header_id = p_ship_header_id

Line 10148: gl_sets_of_books gsb

10144: SELECT gsb.currency_code
10145: INTO l_func_currency_code
10146: FROM
10147: org_organization_definitions ood,
10148: gl_sets_of_books gsb
10149: WHERE
10150: gsb.set_of_books_id = ood.set_of_books_id
10151: AND ood.organization_id = r_match(i).organization_id;
10152: INL_LOGGING_PVT.Log_Variable (

Line 13352: gl_sets_of_books gsb,

13348: -- Get the functional currency code
13349: SELECT gsb.currency_code
13350: INTO l_func_currency_code
13351: FROM inl_ship_headers_all ish,
13352: gl_sets_of_books gsb,
13353: org_organization_definitions ood
13354: WHERE ish.organization_id = ood.organization_id
13355: AND gsb.set_of_books_id = ood.set_of_books_id
13356: AND ish.ship_header_id = p_ship_header_id;