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.EAM_COMMON_UTILITIES_PVT dependencies on MTL_PARAMETERS

Line 65: FROM mtl_parameters MP

61: l_organization_code VARCHAR2(3) ;
62: l_stmt_num NUMBER;
63: CURSOR c_org_code( p_org_id IN NUMBER) IS
64: SELECT MP.organization_code
65: FROM mtl_parameters MP
66: WHERE mp.organization_id = p_org_id ;
67:
68: BEGIN
69: -- Standard Start of API savepoint

Line 229: FROM mtl_system_items_kfv msikfv, mtl_parameters mp

225: l_stmt_num := 70;
226:
227: SELECT msikfv.inventory_item_id
228: INTO l_inventory_item_id
229: FROM mtl_system_items_kfv msikfv, mtl_parameters mp
230: WHERE msikfv.organization_id = mp.organization_id
231: AND mp.maint_organization_id = l_organization_id
232: AND msikfv.concatenated_segments = l_concatenated_segments
233: AND rownum = 1;

Line 571: FROM MTL_PARAMETERS

567:
568: l_stmt_num := 60;
569: SELECT SERIAL_NUMBER_GENERATION
570: INTO l_serial_generation
571: FROM MTL_PARAMETERS
572: WHERE ORGANIZATION_ID = p_organization_id;
573:
574:
575: IF (l_serial_generation = 1) THEN

Line 578: | Get the serial prefix and the start number from MTL_PARAMETERS.

574:
575: IF (l_serial_generation = 1) THEN
576: /*----------------------------------------------------------------+
577: | Serial number generation is set to the org level.
578: | Get the serial prefix and the start number from MTL_PARAMETERS.
579: +--------------------------------------------------------------*/
580:
581: l_stmt_num := 70;
582: SELECT AUTO_SERIAL_ALPHA_PREFIX,

Line 586: FROM MTL_PARAMETERS

582: SELECT AUTO_SERIAL_ALPHA_PREFIX,
583: START_AUTO_SERIAL_NUMBER
584: INTO l_asset_prefix,
585: l_asset_number
586: FROM MTL_PARAMETERS
587: WHERE ORGANIZATION_ID = p_organization_id
588: FOR UPDATE OF START_AUTO_SERIAL_NUMBER;
589:
590:

Line 632: FROM MTL_PARAMETERS

628: if (l_concat_asset_number is not null) then
629: l_stmt_num := 90;
630: SELECT SERIAL_NUMBER_TYPE
631: INTO l_serial_number_type
632: FROM MTL_PARAMETERS
633: WHERE ORGANIZATION_ID = p_organization_id;
634:
635: /* for item level uniqueness */
636: -- bug 3718290: Changing serial_number_type from 1 to 4 below.

Line 658: MTL_SYSTEM_ITEMS msi, MTL_PARAMETERS mp

654: Check for item start_serial_number in all orgs for that item */
655: ELSE
656: select count(*) into l_count
657: from
658: MTL_SYSTEM_ITEMS msi, MTL_PARAMETERS mp
659: where
660: msi.organization_id=mp.organization_id and
661: mp.serial_number_generation = 2 and
662: msi.inventory_item_id=p_inventory_item_id and

Line 689: MTL_PARAMETERS P

685: l_stmt_num := 120;
686: SELECT count(*)
687: INTO l_count
688: FROM MTL_SERIAL_NUMBERS S,
689: MTL_PARAMETERS P
690: WHERE S.CURRENT_ORGANIZATION_ID = P.ORGANIZATION_ID
691: AND S.SERIAL_NUMBER = l_concat_asset_number
692: AND P.SERIAL_NUMBER_TYPE = 3;
693:

Line 710: MTL_PARAMETERS mp

706: /* Fix Case 4*/
707: elsif (l_serial_generation = 1) then
708: select count(*) into l_count
709: from
710: MTL_PARAMETERS mp
711: where
712: mp.organization_id=p_organization_id and
713: mp.auto_serial_alpha_prefix=l_asset_prefix and
714: mp.start_auto_serial_number-1=l_asset_number;

Line 740: MTL_SYSTEM_ITEMS msi, MTL_PARAMETERS mp

736: /* Fix Case 5*/
737: /* check in orgs with item level serial number generation */
738: select count(*) into l_count
739: from
740: MTL_SYSTEM_ITEMS msi, MTL_PARAMETERS mp
741: where
742: msi.organization_id=mp.organization_id and
743: mp.serial_number_generation = 2 and
744: msi.inventory_item_id=p_inventory_item_id and

Line 754: MTL_PARAMETERS mp

750: /* Fix Case 6*/
751: /* check in orgs with org level serial number generation */
752: select count(*) into l_count
753: from
754: MTL_PARAMETERS mp
755: where
756: mp.serial_number_generation = 1 and
757: mp.auto_serial_alpha_prefix=l_asset_prefix and
758: mp.start_auto_serial_number-1=l_asset_number;

Line 800: MTL_SYSTEM_ITEMS msi, MTL_PARAMETERS mp

796: l_success := FND_API.G_FALSE;
797: ELSE
798: SELECT count(*) INTO l_count
799: FROM
800: MTL_SYSTEM_ITEMS msi, MTL_PARAMETERS mp
801: WHERE
802: msi.organization_id=mp.organization_id AND
803: mp.serial_number_generation = 2 AND
804: msi.inventory_item_id=p_inventory_item_id AND

Line 837: | Get the serial prefix and the start number from MTL_PARAMETERS.

833:
834: IF (l_serial_generation = 1) THEN
835: /*----------------------------------------------------------------+
836: | Serial number generation is set to the org level.
837: | Get the serial prefix and the start number from MTL_PARAMETERS.
838: +--------------------------------------------------------------*/
839: l_stmt_num := 140;
840: UPDATE MTL_PARAMETERS
841: SET AUTO_SERIAL_ALPHA_PREFIX = l_asset_prefix,

Line 840: UPDATE MTL_PARAMETERS

836: | Serial number generation is set to the org level.
837: | Get the serial prefix and the start number from MTL_PARAMETERS.
838: +--------------------------------------------------------------*/
839: l_stmt_num := 140;
840: UPDATE MTL_PARAMETERS
841: SET AUTO_SERIAL_ALPHA_PREFIX = l_asset_prefix,
842: START_AUTO_SERIAL_NUMBER = l_asset_number
843: WHERE ORGANIZATION_ID = p_organization_id;
844: -- fix for bug 2860820. This ensures that the asset number

Line 967: mtl_parameters mp,

963: IF (p_resp_id IS NOT NULL) THEN
964: select count(*)
965: into x_boolean
966: from org_access_view oav,
967: mtl_parameters mp,
968: wip_eam_parameters wep
969: where oav.organization_id = mp.organization_id
970: and oav.responsibility_id = p_resp_id
971: and oav.resp_application_id = p_resp_app_id

Line 1109: from csi_item_instances cii, mtl_system_items msi, mtl_parameters mp

1105: ) return boolean is
1106: l_count number;
1107: begin
1108: select count(*) into l_count
1109: from csi_item_instances cii, mtl_system_items msi, mtl_parameters mp
1110: where cii.last_vld_organization_id=mp.organization_id
1111: and msi.organization_id = cii.last_vld_organization_id
1112: and mp.maint_organization_id = p_organization_id
1113: and cii.inventory_item_id=p_inventory_item_id

Line 1362: from csi_item_instances cii, mtl_system_items msi, mtl_parameters mp

1358: from EAM UIs, I'm not specifically testing for the type of work order
1359: this row may represent */
1360:
1361: select count(*) into l_count
1362: from csi_item_instances cii, mtl_system_items msi, mtl_parameters mp
1363: where
1364: msi.organization_id=cii.last_vld_organization_id and
1365: msi.inventory_item_id=cii.inventory_item_id and
1366: cii.instance_id = p_maintenance_object_id and

Line 1381: from mtl_system_items msi, mtl_parameters mp

1377: return false;
1378: end if;
1379:
1380: select count(*) into l_count
1381: from mtl_system_items msi, mtl_parameters mp
1382: where
1383: msi.inventory_item_id=p_maintenance_object_id
1384: and msi.eam_item_type=p_eam_item_type
1385: and msi.organization_id=mp.organization_id

Line 1516: FROM csi_item_instances cii, mtl_parameters mp

1512:
1513: if (p_maintenance_object_type=3) then
1514: SELECT mp.maint_organization_id, cii.inventory_item_id, cii.serial_number
1515: INTO x_organization_id, x_inventory_item_id, x_serial_number
1516: FROM csi_item_instances cii, mtl_parameters mp
1517: WHERE cii.instance_id=p_maintenance_object_id
1518: AND cii.last_vld_organization_id = mp.organization_id;
1519: elsif (p_maintenance_object_type=2) then
1520: select inventory_item_id

Line 2359: from bom_departments bd, mtl_parameters mp

2355:
2356: return l_dept_id;
2357: else
2358: select bd.department_id into l_dept_id
2359: from bom_departments bd, mtl_parameters mp
2360: where bd.department_code = p_dept_code
2361: and mp.organization_code = p_org_code
2362: and bd.organization_id = mp.organization_id;
2363: