APPS.INL_SHIPMENT_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 4033: FROM org_organization_definitions ood

4029: p_procedure_name => l_program_name,
4030: p_debug_info => l_debug_info) ;
4031: SELECT set_of_books_id
4032: INTO l_sob_id
4033: FROM org_organization_definitions ood
4034: WHERE organization_id = l_inv_org_id;
4035: l_debug_info := 'Check Shipment Date against the Inventory Open Period';
4036: INL_LOGGING_PVT.Log_Statement (
4037: p_module_name => g_module_name,

Line 4172: FROM org_organization_definitions ood,

4168: p_procedure_name => l_program_name,
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';

Line 9735: --Bug#14044298 org_organization_definitions ood, --BUG#8468830

9731: --Bug#14044298 inl_charge_lines cl ,
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)

Line 9766: --Bug#14044298 org_organization_definitions ood, --BUG#8468830

9762: FROM
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

Line 10147: org_organization_definitions ood,

10143: ) ;
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;

Line 13353: org_organization_definitions ood

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;
13357: INL_LOGGING_PVT.Log_Variable (