[Home] [Help]
4720: FROM mtl_parameters mp, org_organization_definitions ood
4721: WHERE mp.organization_Id = ood.organization_id
4722: -- jaramana on Feb 14, 2008
4723: -- Removed reference to CLIENT_INFO
4724: AND NVL(ood.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
4725: */
4726: AND EXISTS (
4727: SELECT 'X'
4728: FROM mtl_parameters mp, inv_organization_info_v io
4727: SELECT 'X'
4728: FROM mtl_parameters mp, inv_organization_info_v io
4729: WHERE mp.master_organization_id = M.organization_id AND
4730: mp.organization_Id = io.organization_id AND
4731: NVL(io.operating_unit, mo_global.get_current_org_id()) =
4732: mo_global.get_current_org_id()
4733: )
4734: AND C.inv_locator_id IN (
4735: SELECT
4728: FROM mtl_parameters mp, inv_organization_info_v io
4729: WHERE mp.master_organization_id = M.organization_id AND
4730: mp.organization_Id = io.organization_id AND
4731: NVL(io.operating_unit, mo_global.get_current_org_id()) =
4732: mo_global.get_current_org_id()
4733: )
4734: AND C.inv_locator_id IN (
4735: SELECT
4736: ILOC.inventory_location_id
4859: FROM mtl_parameters mp, org_organization_definitions ood
4860: WHERE mp.organization_Id = ood.organization_id
4861: -- jaramana on Feb 14, 2008
4862: -- Removed reference to CLIENT_INFO
4863: AND NVL(ood.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
4864: */
4865: AND EXISTS (
4866: SELECT 'X'
4867: FROM mtl_parameters mp, inv_organization_info_v io
4866: SELECT 'X'
4867: FROM mtl_parameters mp, inv_organization_info_v io
4868: WHERE mp.master_organization_id = M.organization_id AND
4869: mp.organization_Id = io.organization_id AND
4870: NVL(io.operating_unit, mo_global.get_current_org_id()) =
4871: mo_global.get_current_org_id()
4872: )
4873: AND C.inv_locator_id IN (
4874: SELECT
4867: FROM mtl_parameters mp, inv_organization_info_v io
4868: WHERE mp.master_organization_id = M.organization_id AND
4869: mp.organization_Id = io.organization_id AND
4870: NVL(io.operating_unit, mo_global.get_current_org_id()) =
4871: mo_global.get_current_org_id()
4872: )
4873: AND C.inv_locator_id IN (
4874: SELECT
4875: ILOC.inventory_location_id
5581: SELECT 'X'
5582: FROM mtl_parameters mp, inv_organization_info_v io
5583: WHERE mp.master_organization_id = M.organization_id AND
5584: mp.organization_Id = io.organization_id AND
5585: NVL(io.operating_unit, mo_global.get_current_org_id()) =
5586: mo_global.get_current_org_id()
5587: )
5588: --Plus those units could be installed
5589: UNION ALL
5582: FROM mtl_parameters mp, inv_organization_info_v io
5583: WHERE mp.master_organization_id = M.organization_id AND
5584: mp.organization_Id = io.organization_id AND
5585: NVL(io.operating_unit, mo_global.get_current_org_id()) =
5586: mo_global.get_current_org_id()
5587: )
5588: --Plus those units could be installed
5589: UNION ALL
5590: SELECT
5696: SELECT 'X'
5697: FROM mtl_parameters mp, inv_organization_info_v io
5698: WHERE mp.master_organization_id = M.organization_id AND
5699: mp.organization_Id = io.organization_id AND
5700: NVL(io.operating_unit, mo_global.get_current_org_id()) =
5701: mo_global.get_current_org_id()
5702: )
5703: AND ahl_util_uc_pkg.IS_UNIT_QUARANTINED(U.uc_header_id , null) =
5704: FND_API.G_FALSE
5697: FROM mtl_parameters mp, inv_organization_info_v io
5698: WHERE mp.master_organization_id = M.organization_id AND
5699: mp.organization_Id = io.organization_id AND
5700: NVL(io.operating_unit, mo_global.get_current_org_id()) =
5701: mo_global.get_current_org_id()
5702: )
5703: AND ahl_util_uc_pkg.IS_UNIT_QUARANTINED(U.uc_header_id , null) =
5704: FND_API.G_FALSE
5705: ORDER BY 2;
6780: AND (EXISTS (SELECT 'X'
6781: FROM mtl_parameters mp, inv_organization_info_v io
6782: WHERE mp.master_organization_id = MSIK.organization_id
6783: AND mp.organization_Id = io.organization_id
6784: AND NVL(io.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
6785: )
6786: -- Org Filtering: If p_supply_location_type is INVENTORY, filter by the org by the passed in p_organization_name
6787: AND CII.inv_organization_id = HAOUT.organization_id(+)
6788: AND HAOUT.language = USERENV('LANG')
6847: FROM mtl_parameters mp,
6848: inv_organization_info_v io
6849: WHERE mp.master_organization_id = MSIK.organization_id
6850: AND mp.organization_Id = io.organization_id
6851: AND NVL(io.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
6852: )
6853: -- Do not get quarantined units
6854: AND ahl_util_uc_pkg.IS_UNIT_QUARANTINED(U.uc_header_id , null) = FND_API.G_FALSE
6855: -- Org Filtering: If p_supply_location_type is INVENTORY, filter by the org by the passed in p_organization_name
7143: AND (EXISTS (SELECT 'X'
7144: FROM mtl_parameters mp, inv_organization_info_v io
7145: WHERE mp.master_organization_id = MSIK.organization_id
7146: AND mp.organization_Id = io.organization_id
7147: AND NVL(io.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
7148: )
7149: --Plus those units could be installed
7150: UNION ALL
7151: SELECT CII.inventory_item_id
7194: FROM mtl_parameters mp,
7195: inv_organization_info_v io
7196: WHERE mp.master_organization_id = MSIK.organization_id
7197: AND mp.organization_Id = io.organization_id
7198: AND NVL(io.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
7199: )
7200: -- Do not get quarantined units
7201: AND ahl_util_uc_pkg.IS_UNIT_QUARANTINED(U.uc_header_id , null) = FND_API.G_FALSE;
7202: