eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_DIAGNOSTICS_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 6121: FROM mtl_secondary_inventories mssi,

6117: l_instance_rec.instance_usage_code = 'IN_INVENTORY'
6118: THEN
6119: SELECT nvl(mssi.location_id, haou.location_id)
6120: INTO l_instance_rec.location_id
6121: FROM mtl_secondary_inventories mssi,
6122: hr_all_organization_units haou
6123: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
6124: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
6125: AND haou.organization_id = mssi.organization_id;

Line 6223: FROM mtl_secondary_inventories mssi,

6219: THEN
6220:
6221: SELECT nvl(mssi.location_id, haou.location_id)
6222: INTO l_instance_rec.location_id
6223: FROM mtl_secondary_inventories mssi,
6224: hr_all_organization_units haou
6225: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
6226: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
6227: AND haou.organization_id = mssi.organization_id;

Line 6408: FROM mtl_secondary_inventories mssi,

6404: l_instance_rec.object_version_number := 1.0;
6405:
6406: SELECT nvl(mssi.location_id, haou.location_id)
6407: INTO l_instance_rec.location_id
6408: FROM mtl_secondary_inventories mssi,
6409: hr_all_organization_units haou
6410: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
6411: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
6412: AND haou.organization_id = mssi.organization_id;

Line 6704: FROM mtl_secondary_inventories mssi,

6700: l_instance_rec.object_version_number := 1.0;
6701:
6702: SELECT nvl(mssi.location_id, haou.location_id)
6703: INTO l_instance_rec.location_id
6704: FROM mtl_secondary_inventories mssi,
6705: hr_all_organization_units haou
6706: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
6707: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
6708: AND haou.organization_id = mssi.organization_id;

Line 7648: FROM mtl_secondary_inventories mssi,

7644: AND organization_id = inv_rec.xfer_organization_id;
7645:
7646: SELECT nvl(mssi.location_id, haou.location_id)
7647: INTO l_inv_location_id
7648: FROM mtl_secondary_inventories mssi,
7649: hr_all_organization_units haou
7650: WHERE mssi.organization_id = inv_rec.organization_id
7651: AND mssi.secondary_inventory_name = inv_rec.subinv_code
7652: AND haou.organization_id = mssi.organization_id;

Line 7822: FROM mtl_secondary_inventories mssi,

7818: l_instance_rec.inv_subinventory_name:= inv_rec.subinv_code;
7819:
7820: SELECT nvl(mssi.location_id, haou.location_id)
7821: INTO l_instance_rec.location_id
7822: FROM mtl_secondary_inventories mssi,
7823: hr_all_organization_units haou
7824: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
7825: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
7826: AND haou.organization_id = mssi.organization_id;

Line 8385: FROM mtl_secondary_inventories mssi,

8381: l_instance_rec.object_version_number := 1.0;
8382:
8383: SELECT nvl(mssi.location_id, haou.location_id)
8384: INTO l_instance_rec.location_id
8385: FROM mtl_secondary_inventories mssi,
8386: hr_all_organization_units haou
8387: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
8388: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
8389: AND haou.organization_id = mssi.organization_id;

Line 8452: FROM mtl_secondary_inventories mssi,

8448: l_instance_rec.inv_subinventory_name:= inv_rec.subinv_code;
8449:
8450: SELECT nvl(mssi.location_id, haou.location_id)
8451: INTO l_instance_rec.location_id
8452: FROM mtl_secondary_inventories mssi,
8453: hr_all_organization_units haou
8454: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
8455: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
8456: AND haou.organization_id = mssi.organization_id;

Line 8977: FROM mtl_secondary_inventories

8973: -- get inv location id from the subinv/org definition
8974: BEGIN
8975: SELECT location_id
8976: INTO l_instance_rec.location_id
8977: FROM mtl_secondary_inventories
8978: WHERE secondary_inventory_name = l_instance_rec.inv_subinventory_name
8979: AND organization_id = l_instance_rec.vld_organization_id;
8980:
8981: IF l_instance_rec.location_id is null THEN

Line 12461: -- Get the Location ID from MTL_SECONDARY_INVENTORIES

12457: --
12458: Raise Process_next;
12459: END IF;
12460: -- If instance is not found then Create the Instance
12461: -- Get the Location ID from MTL_SECONDARY_INVENTORIES
12462: v_location_id := NULL;
12463: Begin
12464: select location_id
12465: into v_location_id

Line 12466: from MTL_SECONDARY_INVENTORIES

12462: v_location_id := NULL;
12463: Begin
12464: select location_id
12465: into v_location_id
12466: from MTL_SECONDARY_INVENTORIES
12467: where organization_id = organization_id_mig(i)
12468: and secondary_inventory_name = subinv_mig(i);
12469: Exception
12470: when no_data_found then

Line 12943: -- Get the Location ID from MTL_SECONDARY_INVENTORIES

12939: --
12940: Raise Process_next;
12941: END IF;
12942: -- If instance not found then Create the Instance
12943: -- Get the Location ID from MTL_SECONDARY_INVENTORIES
12944: v_location_id := NULL;
12945: Begin
12946: select location_id
12947: into v_location_id

Line 12948: from MTL_SECONDARY_INVENTORIES

12944: v_location_id := NULL;
12945: Begin
12946: select location_id
12947: into v_location_id
12948: from MTL_SECONDARY_INVENTORIES
12949: where organization_id = organization_id_mig(i)
12950: and secondary_inventory_name = subinv_mig(i);
12951: Exception
12952: when no_data_found then

Line 13514: FROM mtl_secondary_inventories mssi,

13510: l_instance_rec.object_version_number := 1.0;
13511:
13512: SELECT nvl(mssi.location_id, haou.location_id)
13513: INTO l_instance_rec.location_id
13514: FROM mtl_secondary_inventories mssi,
13515: hr_all_organization_units haou
13516: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
13517: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
13518: AND haou.organization_id = mssi.organization_id;

Line 13781: -- Get the Location ID from MTL_SECONDARY_INVENTORIES

13777: ' Under Organization '||to_char(organization_id_mig(i));
13778: Out(v_err_msg);
13779: Raise Process_next;
13780: END IF;
13781: -- Get the Location ID from MTL_SECONDARY_INVENTORIES
13782: Begin
13783: select location_id
13784: into v_location_id
13785: from MTL_SECONDARY_INVENTORIES

Line 13785: from MTL_SECONDARY_INVENTORIES

13781: -- Get the Location ID from MTL_SECONDARY_INVENTORIES
13782: Begin
13783: select location_id
13784: into v_location_id
13785: from MTL_SECONDARY_INVENTORIES
13786: where organization_id = organization_id_mig(i)
13787: and secondary_inventory_name = subinv_mig(i);
13788: Exception
13789: when no_data_found then