[Home] [Help]
127: p_source_type IN VARCHAR2
128: )
129: IS
130: SELECT to_number(a.org_information2) legal_entity_id
131: FROM hr_organization_information a, gl_plcy_mst b
132: WHERE a.organization_id = b.org_id
133: AND b.co_code = p_co_code
134: AND p_source_type = 'O'
135: and a.org_information_context = 'Operating Unit Information'
217: p_organization_id IN NUMBER
218: )
219: IS
220: SELECT to_number(a.org_information2) legal_entity_id
221: FROM hr_organization_information a
222: WHERE a.organization_id = p_organization_id
223: AND a.org_information_context = 'Accounting Information';
224:
225: BEGIN
300: p_whse_code IN VARCHAR2
301: )
302: IS
303: SELECT to_number(a.org_information2) legal_entity_id
304: FROM hr_organization_information a, ic_whse_mst b
305: WHERE a.organization_id = decode(nvl(b.subinventory_ind_flag, 'N'), 'Y', b.organization_id, b.mtl_organization_id)
306: AND b.whse_code = p_whse_code
307: AND a.org_information_context = 'Accounting Information';
308:
1826: SELECT to_number(org_information2),
1827: to_number(org_information3)
1828: INTO l_legal_entity_id,
1829: l_ledger_id
1830: FROM hr_organization_information
1831: WHERE org_information_context = 'Operating Unit Information'
1832: AND organization_id = i.org_id;
1833: EXCEPTION
1834: WHEN OTHERS THEN
1839: L_legal_entity_id := i.legal_entity_id;
1840: BEGIN
1841: SELECT to_number(org_information3)
1842: INTO l_ledger_id
1843: FROM hr_organization_information
1844: WHERE org_information_context = 'Operating Unit Information'
1845: AND organization_id = i.org_id;
1846: EXCEPTION
1847: WHEN OTHERS THEN
3985: SELECT z.master_organization_id,
3986: y.inventory_item_id
3987: FROM ic_item_mst_b_mig y,
3988: mtl_parameters z,
3989: hr_organization_information hoi
3990: WHERE y.item_id = a.item_id
3991: AND y.organization_id = z.organization_id
3992: AND hoi.organization_id = z.organization_id
3993: AND hoi.org_information_context = 'Accounting Information'
4800: SELECT z.master_organization_id,
4801: y.inventory_item_id
4802: FROM ic_item_mst_b_mig y,
4803: mtl_parameters z,
4804: hr_organization_information hoi
4805: WHERE y.item_id = a.item_id
4806: AND y.organization_id = z.organization_id
4807: AND hoi.organization_id = z.organization_id
4808: AND hoi.org_information_context = 'Accounting Information'
9003: FROM sy_orgn_mst a,
9004: ic_cldr_dtl b,
9005: ic_cldr_dtl c,
9006: org_acct_periods d,
9007: hr_organization_information hoi,
9008: ic_whse_mst e,
9009: gl_ledgers f
9010: WHERE a.co_code = b.orgn_code /* Bug 10339562 - Changed a.orgn_code to a.co_code */
9011: AND c.orgn_code = a.co_code /* Bug 10339562 - Changed a.orgn_code to a.co_code */
10027: SELECT z.master_organization_id,
10028: y.inventory_item_id
10029: FROM ic_item_mst_b_mig y,
10030: mtl_parameters z,
10031: hr_organization_information hoi
10032: WHERE y.item_id = a.item_id
10033: AND y.organization_id = z.organization_id
10034: AND hoi.organization_id = z.organization_id
10035: AND hoi.org_information_context = 'Accounting Information'
10749: SELECT z.master_organization_id,
10750: y.inventory_item_id
10751: FROM ic_item_mst_b_mig y,
10752: mtl_parameters z,
10753: hr_organization_information hoi
10754: WHERE y.item_id = a.item_id
10755: AND y.organization_id = z.organization_id
10756: AND hoi.organization_id = z.organization_id
10757: AND hoi.org_information_context = 'Accounting Information'
11408: SELECT z.master_organization_id,
11409: y.inventory_item_id
11410: FROM ic_item_mst_b_mig y,
11411: mtl_parameters z,
11412: hr_organization_information hoi
11413: WHERE y.item_id = a.item_id
11414: AND y.organization_id = z.organization_id
11415: AND hoi.organization_id = z.organization_id
11416: AND hoi.org_information_context = 'Accounting Information'
11504: SELECT z.master_organization_id,
11505: y.inventory_item_id
11506: FROM ic_item_mst_b_mig y,
11507: mtl_parameters z,
11508: hr_organization_information hoi,
11509: cm_rlup_ctl x
11510: WHERE y.item_id = a.item_id
11511: AND y.organization_id = z.organization_id
11512: AND hoi.organization_id = z.organization_id