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

Line 1930: FROM mtl_parameters mp

1926: 56, 57, 58, 24, 93, 66, 67,
1927: 68, 80, 94, 26, 28, 77)
1928: AND EXISTS
1929: (SELECT 'This is a Process Mfg Org'
1930: FROM mtl_parameters mp
1931: WHERE mp.process_enabled_flag = 'Y'
1932: AND mp.organization_id = mti.organization_id
1933: );
1934:

Line 3679: --mtl_parameters.

3675: inv_log_util.trace('Validating group Plann Org:Supplier' || l_count || ' failed', 'INV_TXN_MANAGER_GRP', 9);
3676: END IF;
3677:
3678: --if the planning _org is a inventory org it should be in
3679: --mtl_parameters.
3680:
3681: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3682: SET LAST_UPDATE_DATE = SYSDATE,
3683: LAST_UPDATED_BY = p_userid,

Line 3697: FROM mtl_parameters mp

3693: AND planning_tp_type = 2
3694: AND planning_organization_id <> ORGANIZATION_ID
3695: AND NOT EXISTS (
3696: SELECT NULL
3697: FROM mtl_parameters mp
3698: where
3699: mp.organization_id = mti.planning_organization_id);
3700:
3701:

Line 3928: FROM MTL_SYSTEM_ITEMS MSI, MTL_PARAMETERS MP

3924: AND PROCESS_FLAG = 1
3925: AND ((REBUILD_ITEM_ID IS NOT NULL
3926: AND NOT EXISTS (
3927: SELECT NULL
3928: FROM MTL_SYSTEM_ITEMS MSI, MTL_PARAMETERS MP
3929: WHERE MSI.INVENTORY_ITEM_ID = MTI.REBUILD_ITEM_ID
3930: AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
3931: AND MP.MAINT_ORGANIZATION_ID = MTI.ORGANIZATION_ID
3932: AND MSI.EAM_ITEM_TYPE = 3

Line 4054: FROM mtl_parameters

4050: /* get copy lot attribute flag */
4051: CURSOR get_org_copy_lot_flag IS
4052: SELECT copy_lot_attribute_flag,
4053: lot_number_generation
4054: FROM mtl_parameters
4055: WHERE organization_id = p_orgid;
4056:
4057: /* get item information */
4058: CURSOR c_get_item_info IS

Line 5189: FROM MTL_PARAMETERS

5185:
5186: BEGIN
5187: SELECT DECODE(NVL(PROJECT_REFERENCE_ENABLED, 2),1,1,0)
5188: INTO l_ltv_project_ref_enabled
5189: FROM MTL_PARAMETERS
5190: WHERE ORGANIZATION_ID = p_ltv_orgid ;
5191: EXCEPTION
5192: WHEN NO_DATA_FOUND THEN
5193: FND_MESSAGE.set_name('INV','INV_INT_ORGEXP');

Line 5342: l_primary_cost_method mtl_parameters.primary_cost_method%TYPE;

5338: FUNCTION get_costgrpid(p_org_id in NUMBER, p_subinv in VARCHAR2, p_locatorid in NUMBER)
5339: RETURN mtl_transactions_interface.cost_group_id%TYPE IS
5340: l_cost_group_id number;
5341: l_org_cost_group_id number;
5342: l_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
5343: l_project_enabled NUMBER;
5344: l_project_id NUMBER;
5345: BEGIN
5346: IF p_org_id is NULL then

Line 5355: FROM mtl_parameters

5351:
5352: BEGIN
5353: SELECT Nvl(project_reference_enabled,2), default_cost_group_id, primary_cost_method
5354: INTO l_project_enabled, l_org_cost_group_id, l_primary_cost_method
5355: FROM mtl_parameters
5356: WHERE organization_id = p_org_id;
5357: EXCEPTION
5358: WHEN no_data_found THEN
5359: return NULL;

Line 6213: l_lcm_enabled_org mtl_parameters.lcm_enabled_flag%type := 'N';

6209: l_cst_temp NUMBER;
6210: l_reqstid NUMBER;
6211:
6212: l_result NUMBER;
6213: l_lcm_enabled_org mtl_parameters.lcm_enabled_flag%type := 'N';
6214:
6215:
6216: /* WMS installed -- Installed:1, not installed: 0 */
6217: wms_installed NUMBER;

Line 6591: FROM MTL_PARAMETERS P,

6587: l_resloc,
6588: l_shlfcode,
6589: l_shlfdays,
6590: l_lotuniq
6591: FROM MTL_PARAMETERS P,
6592: MTL_SECONDARY_INVENTORIES S,
6593: MTL_SYSTEM_ITEMS I
6594: WHERE I.INVENTORY_ITEM_ID = l_itemid
6595: AND S.SECONDARY_INVENTORY_NAME = l_subinv

Line 6649: FROM MTL_PARAMETERS

6645:
6646: BEGIN
6647: SELECT DECODE(NVL(PROJECT_REFERENCE_ENABLED, 2),1,1,0)
6648: INTO l_project_ref_enabled
6649: FROM MTL_PARAMETERS
6650: WHERE ORGANIZATION_ID = l_orgid ;
6651: EXCEPTION
6652: WHEN NO_DATA_FOUND THEN
6653: l_project_ref_enabled := 0;

Line 6807: FROM MTL_PARAMETERS P,

6803: INTO l_xlocctrl,
6804: l_xlotctrl,
6805: l_xserctrl,
6806: l_xresloc
6807: FROM MTL_PARAMETERS P,
6808: MTL_SECONDARY_INVENTORIES S,
6809: MTL_SYSTEM_ITEMS I
6810: WHERE I.INVENTORY_ITEM_ID = l_itemid
6811: AND S.SECONDARY_INVENTORY_NAME = l_xsubinv

Line 6912: FROM MTL_PARAMETERS

6908: mil as that of the already existing logical/physical locator */
6909: BEGIN
6910: SELECT DECODE(NVL(PROJECT_REFERENCE_ENABLED, 2),1,1,0)
6911: INTO l_project_ref_enabled
6912: FROM MTL_PARAMETERS
6913: WHERE ORGANIZATION_ID = l_xorgid ;
6914: EXCEPTION
6915: WHEN NO_DATA_FOUND THEN
6916: l_project_ref_enabled := 0;

Line 7393: from mtl_parameters

7389:
7390: Begin
7391: select nvl(lcm_enabled_flag,'N')
7392: into l_lcm_enabled_org
7393: from mtl_parameters
7394: where organization_id = l_orgid;
7395: Exception
7396: when others then
7397: inv_log_util.trace('Error in obtaining LCM Enabled Flag ', 'INV_TXN_MANAGER_GRP', 9);

Line 7547: FROM MTL_PARAMETERS

7543: tev_flow_schedule = 0) THEN
7544:
7545: SELECT PRIMARY_COST_METHOD
7546: INTO l_primary_cost_method
7547: FROM MTL_PARAMETERS
7548: WHERE ORGANIZATION_ID = l_orgid ;
7549:
7550: IF ( l_avg_cost_update = 2 AND (l_primary_cost_method = 2 OR
7551: l_primary_cost_method = 5 OR

Line 8127: FROM mtl_parameters mp_from, mtl_parameters mp_to

8123: -- Get process mfg org flag for from and to orgs
8124: --
8125: SELECT mp_from.process_enabled_flag, mp_to.process_enabled_flag
8126: INTO l_process_enabled_flag_from, l_process_enabled_flag_to
8127: FROM mtl_parameters mp_from, mtl_parameters mp_to
8128: WHERE mp_from.organization_id = l_orgid
8129: AND mp_to.organization_id = l_xorgid;
8130:
8131: --

Line 13609: FROM MTL_PARAMETERS MP,

13605: decode(p_line_rec_type.TRANSACTION_ACTION_ID,2,p_line_rec_type.TRANSFER_SUBINVENTORY,28,p_line_rec_type.TRANSFER_SUBINVENTORY,null) TRANSFER_SUBINVENTORY,
13606: p_line_rec_type.TRANSFER_LOCATOR,
13607: p_line_rec_type.transaction_date,
13608: MP.NEGATIVE_INV_RECEIPT_CODE
13609: FROM MTL_PARAMETERS MP,
13610: MTL_SYSTEM_ITEMS MSI
13611: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
13612: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
13613: AND p_line_rec_type.PROCESS_FLAG = 1

Line 13655: MTL_PARAMETERS MP,

13651: p_line_rec_type.TRANSFER_LOCATOR,
13652: p_line_rec_type.transaction_date,
13653: MP.NEGATIVE_INV_RECEIPT_CODE
13654: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,
13655: MTL_PARAMETERS MP,
13656: MTL_SYSTEM_ITEMS MSI
13657: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
13658: --AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
13659: AND MTLI.TRANSACTION_INTERFACE_ID = p_line_rec_type.TRANSACTION_INTERFACE_ID