[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
3962: SELECT z.master_organization_id,
3963: y.inventory_item_id
3964: FROM ic_item_mst_b_mig y,
3965: mtl_parameters z,
3966: hr_organization_information hoi
3967: WHERE y.item_id = a.item_id
3968: AND y.organization_id = z.organization_id
3969: AND hoi.organization_id = z.organization_id
3970: AND hoi.org_information_context = 'Accounting Information'
4777: SELECT z.master_organization_id,
4778: y.inventory_item_id
4779: FROM ic_item_mst_b_mig y,
4780: mtl_parameters z,
4781: hr_organization_information hoi
4782: WHERE y.item_id = a.item_id
4783: AND y.organization_id = z.organization_id
4784: AND hoi.organization_id = z.organization_id
4785: AND hoi.org_information_context = 'Accounting Information'
8893: FROM sy_orgn_mst a,
8894: ic_cldr_dtl b,
8895: ic_cldr_dtl c,
8896: org_acct_periods d,
8897: hr_organization_information hoi,
8898: ic_whse_mst e,
8899: gl_ledgers f
8900: WHERE a.orgn_code = b.orgn_code
8901: AND c.orgn_code = a.orgn_code
9700: SELECT z.master_organization_id,
9701: y.inventory_item_id
9702: FROM ic_item_mst_b_mig y,
9703: mtl_parameters z,
9704: hr_organization_information hoi
9705: WHERE y.item_id = a.item_id
9706: AND y.organization_id = z.organization_id
9707: AND hoi.organization_id = z.organization_id
9708: AND hoi.org_information_context = 'Accounting Information'
10420: SELECT z.master_organization_id,
10421: y.inventory_item_id
10422: FROM ic_item_mst_b_mig y,
10423: mtl_parameters z,
10424: hr_organization_information hoi
10425: WHERE y.item_id = a.item_id
10426: AND y.organization_id = z.organization_id
10427: AND hoi.organization_id = z.organization_id
10428: AND hoi.org_information_context = 'Accounting Information'
11077: SELECT z.master_organization_id,
11078: y.inventory_item_id
11079: FROM ic_item_mst_b_mig y,
11080: mtl_parameters z,
11081: hr_organization_information hoi
11082: WHERE y.item_id = a.item_id
11083: AND y.organization_id = z.organization_id
11084: AND hoi.organization_id = z.organization_id
11085: AND hoi.org_information_context = 'Accounting Information'
11173: SELECT z.master_organization_id,
11174: y.inventory_item_id
11175: FROM ic_item_mst_b_mig y,
11176: mtl_parameters z,
11177: hr_organization_information hoi,
11178: cm_rlup_ctl x
11179: WHERE y.item_id = a.item_id
11180: AND y.organization_id = z.organization_id
11181: AND hoi.organization_id = z.organization_id