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 12456: -- Get the Location ID from MTL_SECONDARY_INVENTORIES

12452: --
12453: Raise Process_next;
12454: END IF;
12455: -- If instance is not found then Create the Instance
12456: -- Get the Location ID from MTL_SECONDARY_INVENTORIES
12457: v_location_id := NULL;
12458: Begin
12459: select location_id
12460: into v_location_id

Line 12461: from MTL_SECONDARY_INVENTORIES

12457: v_location_id := NULL;
12458: Begin
12459: select location_id
12460: into v_location_id
12461: from MTL_SECONDARY_INVENTORIES
12462: where organization_id = organization_id_mig(i)
12463: and secondary_inventory_name = subinv_mig(i);
12464: Exception
12465: when no_data_found then

Line 12938: -- Get the Location ID from MTL_SECONDARY_INVENTORIES

12934: --
12935: Raise Process_next;
12936: END IF;
12937: -- If instance not found then Create the Instance
12938: -- Get the Location ID from MTL_SECONDARY_INVENTORIES
12939: v_location_id := NULL;
12940: Begin
12941: select location_id
12942: into v_location_id

Line 12943: from MTL_SECONDARY_INVENTORIES

12939: v_location_id := NULL;
12940: Begin
12941: select location_id
12942: into v_location_id
12943: from MTL_SECONDARY_INVENTORIES
12944: where organization_id = organization_id_mig(i)
12945: and secondary_inventory_name = subinv_mig(i);
12946: Exception
12947: when no_data_found then

Line 13509: FROM mtl_secondary_inventories mssi,

13505: l_instance_rec.object_version_number := 1.0;
13506:
13507: SELECT nvl(mssi.location_id, haou.location_id)
13508: INTO l_instance_rec.location_id
13509: FROM mtl_secondary_inventories mssi,
13510: hr_all_organization_units haou
13511: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
13512: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
13513: AND haou.organization_id = mssi.organization_id;

Line 13776: -- Get the Location ID from MTL_SECONDARY_INVENTORIES

13772: ' Under Organization '||to_char(organization_id_mig(i));
13773: Out(v_err_msg);
13774: Raise Process_next;
13775: END IF;
13776: -- Get the Location ID from MTL_SECONDARY_INVENTORIES
13777: Begin
13778: select location_id
13779: into v_location_id
13780: from MTL_SECONDARY_INVENTORIES

Line 13780: from MTL_SECONDARY_INVENTORIES

13776: -- Get the Location ID from MTL_SECONDARY_INVENTORIES
13777: Begin
13778: select location_id
13779: into v_location_id
13780: from MTL_SECONDARY_INVENTORIES
13781: where organization_id = organization_id_mig(i)
13782: and secondary_inventory_name = subinv_mig(i);
13783: Exception
13784: when no_data_found then