[Home] [Help]
1886: l_column_value := x_src_organization_code;
1887:
1888: SELECT ood.organization_id
1889: INTO x_src_organization_id
1890: FROM org_organization_definitions ood
1891: WHERE ood.organization_code = x_src_organization_code;
1892: END IF;
1893: ELSIF p_validation_flag = 'Y' THEN
1894: l_debug_info := 'Derive and validate Source Organization';
1910: INTO
1911: x_src_organization_code,
1912: x_src_organization_id
1913: FROM
1914: org_organization_definitions ood
1915: WHERE (
1916: x_src_organization_id IS NOT NULL
1917: AND ood.organization_id = x_src_organization_id
1918: )
4251: IF x_organization_id IS NOT NULL THEN
4252: x_organization_code := NULL;
4253: SELECT ood.operating_unit
4254: INTO x_org_id
4255: FROM org_organization_definitions ood
4256: WHERE ood.organization_id = x_organization_id;
4257: ELSIF x_organization_code IS NOT NULL THEN
4258: l_column_name := 'ORGANIZATION_CODE';
4259: l_column_value := x_organization_code;
4265: p_debug_info => l_debug_info);
4266:
4267: SELECT ood.organization_id, ood.operating_unit
4268: INTO x_organization_id, x_org_id
4269: FROM org_organization_definitions ood
4270: WHERE ood.organization_code = x_organization_code;
4271: END IF;
4272: ELSIF p_validation_flag = 'Y' THEN
4273: */ -- BUG#8971635
4319: x_LCM_FLOW,
4320: x_user_defined_ship_num_code,
4321: x_manual_ship_num_type,
4322: l_count_org_def_lcm
4323: FROM org_organization_definitions ood,
4324: inl_parameters ipa,
4325: rcv_parameters rp
4326: WHERE
4327: ipa.organization_id (+) = ood.organization_id
14602: (
14603: SELECT 1
14604: FROM
14605: rcv_transactions rt,
14606: org_organization_definitions ood
14607: WHERE
14608: rt.transaction_id = m.to_parent_table_id
14609: AND ood.organization_id = rt.organization_id
14610: )
14687: (
14688: SELECT 1
14689: FROM
14690: rcv_transactions rt,
14691: org_organization_definitions ood
14692: WHERE
14693: rt.transaction_id = mi.to_parent_table_id
14694: AND ood.organization_id = rt.organization_id
14695: )