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 2022: FROM mtl_parameters mp

2018: 56, 57, 58, 24, 93, 66, 67,
2019: 68, 80, 94, 26, 28, 77)
2020: AND EXISTS
2021: (SELECT 'This is a Process Mfg Org'
2022: FROM mtl_parameters mp
2023: WHERE mp.process_enabled_flag = 'Y'
2024: AND mp.organization_id = mti.organization_id
2025: );
2026:

Line 2629: FROM MTL_PARAMETERS MP

2625: WHERE TRANSACTION_HEADER_ID = p_header_id
2626: AND PROCESS_FLAG = 1
2627: AND ((((TRANSACTION_ACTION_ID in (1,2,3,30,31,5)
2628: AND EXISTS ( SELECT 'This is a Discrete Mfg Org'
2629: FROM MTL_PARAMETERS MP
2630: WHERE MP.PROCESS_ENABLED_FLAG = 'N'
2631: AND MP.ORGANIZATION_ID = MTI.ORGANIZATION_ID))
2632: OR (TRANSACTION_ACTION_ID in (1,2,3,30,31,5)
2633: AND NOT(TRANSACTION_SOURCE_TYPE_ID = 5 AND TRANSACTION_ACTION_ID in (1,31) /*Bug 14038473: Bypass subinventory validations for OPM Batches */

Line 2635: FROM MTL_PARAMETERS MP

2631: AND MP.ORGANIZATION_ID = MTI.ORGANIZATION_ID))
2632: OR (TRANSACTION_ACTION_ID in (1,2,3,30,31,5)
2633: AND NOT(TRANSACTION_SOURCE_TYPE_ID = 5 AND TRANSACTION_ACTION_ID in (1,31) /*Bug 14038473: Bypass subinventory validations for OPM Batches */
2634: AND EXISTS ( SELECT 'This is a Process Mfg Org'
2635: FROM MTL_PARAMETERS MP
2636: WHERE MP.PROCESS_ENABLED_FLAG = 'Y'
2637: AND MP.ORGANIZATION_ID = MTI.ORGANIZATION_ID))))
2638: AND EXISTS (
2639: SELECT 'X'

Line 2745: FROM MTL_PARAMETERS MP

2741: WHERE TRANSACTION_HEADER_ID = p_header_id
2742: AND PROCESS_FLAG = 1
2743: AND ((((TRANSACTION_ACTION_ID in (1,2,3,30,31,5)
2744: AND EXISTS ( SELECT 'This is a Discrete Mfg Org'
2745: FROM MTL_PARAMETERS MP
2746: WHERE MP.PROCESS_ENABLED_FLAG = 'N'
2747: AND MP.ORGANIZATION_ID = MTI.ORGANIZATION_ID))
2748: OR (TRANSACTION_ACTION_ID in (1,2,3,30,31,5)
2749: AND NOT(TRANSACTION_SOURCE_TYPE_ID = 5 AND TRANSACTION_ACTION_ID in (1,31) /*Bug 14038473: Bypass subinventory validations for OPM Batches */

Line 2751: FROM MTL_PARAMETERS MP

2747: AND MP.ORGANIZATION_ID = MTI.ORGANIZATION_ID))
2748: OR (TRANSACTION_ACTION_ID in (1,2,3,30,31,5)
2749: AND NOT(TRANSACTION_SOURCE_TYPE_ID = 5 AND TRANSACTION_ACTION_ID in (1,31) /*Bug 14038473: Bypass subinventory validations for OPM Batches */
2750: AND EXISTS ( SELECT 'This is a Process Mfg Org'
2751: FROM MTL_PARAMETERS MP
2752: WHERE MP.PROCESS_ENABLED_FLAG = 'Y'
2753: AND MP.ORGANIZATION_ID = MTI.ORGANIZATION_ID))))
2754: AND EXISTS (
2755: SELECT 'X'

Line 3866: --mtl_parameters.

3862: inv_log_util.trace('Validating group Plann Org:Supplier' || l_count || ' failed', 'INV_TXN_MANAGER_GRP', 9);
3863: END IF;
3864:
3865: --if the planning _org is a inventory org it should be in
3866: --mtl_parameters.
3867:
3868: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3869: SET LAST_UPDATE_DATE = SYSDATE,
3870: LAST_UPDATED_BY = p_userid,

Line 3884: FROM mtl_parameters mp

3880: AND planning_tp_type = 2
3881: AND planning_organization_id <> ORGANIZATION_ID
3882: AND NOT EXISTS (
3883: SELECT NULL
3884: FROM mtl_parameters mp
3885: where
3886: mp.organization_id = mti.planning_organization_id);
3887:
3888:

Line 4217: FROM MTL_SYSTEM_ITEMS MSI, MTL_PARAMETERS MP

4213: AND PROCESS_FLAG = 1
4214: AND ((REBUILD_ITEM_ID IS NOT NULL
4215: AND NOT EXISTS (
4216: SELECT NULL
4217: FROM MTL_SYSTEM_ITEMS MSI, MTL_PARAMETERS MP
4218: WHERE MSI.INVENTORY_ITEM_ID = MTI.REBUILD_ITEM_ID
4219: AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
4220: AND MP.MAINT_ORGANIZATION_ID = MTI.ORGANIZATION_ID
4221: AND MSI.EAM_ITEM_TYPE = 3

Line 4346: FROM mtl_parameters

4342: CURSOR get_org_copy_lot_flag IS
4343: SELECT copy_lot_attribute_flag,
4344: lot_number_generation,
4345: nvl(process_enabled_flag, 'N') --ADM bug 9959125
4346: FROM mtl_parameters
4347: WHERE organization_id = p_orgid;
4348:
4349: /* get item information */
4350: CURSOR c_get_item_info IS

Line 5567: FROM MTL_PARAMETERS

5563:
5564: BEGIN
5565: SELECT DECODE(NVL(PROJECT_REFERENCE_ENABLED, 2),1,1,0)
5566: INTO l_ltv_project_ref_enabled
5567: FROM MTL_PARAMETERS
5568: WHERE ORGANIZATION_ID = p_ltv_orgid ;
5569: EXCEPTION
5570: WHEN NO_DATA_FOUND THEN
5571: FND_MESSAGE.set_name('INV','INV_INT_ORGEXP');

Line 5720: l_primary_cost_method mtl_parameters.primary_cost_method%TYPE;

5716: FUNCTION get_costgrpid(p_org_id in NUMBER, p_subinv in VARCHAR2, p_locatorid in NUMBER)
5717: RETURN mtl_transactions_interface.cost_group_id%TYPE IS
5718: l_cost_group_id number;
5719: l_org_cost_group_id number;
5720: l_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
5721: l_project_enabled NUMBER;
5722: l_project_id NUMBER;
5723: BEGIN
5724: IF p_org_id is NULL then

Line 5733: FROM mtl_parameters

5729:
5730: BEGIN
5731: SELECT Nvl(project_reference_enabled,2), default_cost_group_id, primary_cost_method
5732: INTO l_project_enabled, l_org_cost_group_id, l_primary_cost_method
5733: FROM mtl_parameters
5734: WHERE organization_id = p_org_id
5735: and WMS_ENABLED_FLAG = 'N' ; -- Bug 8345339
5736: EXCEPTION
5737: WHEN no_data_found THEN

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

6588: l_cst_temp NUMBER;
6589: l_reqstid NUMBER;
6590:
6591: l_result NUMBER;
6592: l_lcm_enabled_org mtl_parameters.lcm_enabled_flag%type := 'N';
6593:
6594:
6595: /* WMS installed -- Installed:1, not installed: 0 */
6596: wms_installed NUMBER;

Line 6906: FROM mtl_parameters

6902: AND TRANSACTION_COST <0
6903: and exists
6904: (
6905: SELECT organization_id
6906: FROM mtl_parameters
6907: WHERE organization_id = MTI.organization_id
6908: and NVL(process_enabled_flag, 'N') ='N'
6909: );
6910:

Line 7071: FROM MTL_PARAMETERS P,

7067: l_resloc,
7068: l_shlfcode,
7069: l_shlfdays,
7070: l_lotuniq
7071: FROM MTL_PARAMETERS P,
7072: MTL_SECONDARY_INVENTORIES S,
7073: MTL_SYSTEM_ITEMS I
7074: WHERE I.INVENTORY_ITEM_ID = l_itemid
7075: AND S.SECONDARY_INVENTORY_NAME = l_subinv

Line 7175: FROM MTL_PARAMETERS

7171:
7172: BEGIN
7173: SELECT DECODE(NVL(PROJECT_REFERENCE_ENABLED, 2),1,1,0)
7174: INTO l_project_ref_enabled
7175: FROM MTL_PARAMETERS
7176: WHERE ORGANIZATION_ID = l_orgid ;
7177: EXCEPTION
7178: WHEN NO_DATA_FOUND THEN
7179: l_project_ref_enabled := 0;

Line 7289: FROM MTL_PARAMETERS P,

7285: INTO l_xlocctrl,
7286: l_xlotctrl,
7287: l_xserctrl,
7288: l_xresloc
7289: FROM MTL_PARAMETERS P,
7290: MTL_SECONDARY_INVENTORIES S,
7291: MTL_SYSTEM_ITEMS I
7292: WHERE I.INVENTORY_ITEM_ID = l_itemid
7293: AND S.SECONDARY_INVENTORY_NAME = l_xsubinv

Line 7436: FROM MTL_PARAMETERS

7432:
7433: BEGIN
7434: SELECT DECODE(NVL(PROJECT_REFERENCE_ENABLED, 2),1,1,0)
7435: INTO l_project_ref_enabled
7436: FROM MTL_PARAMETERS
7437: WHERE ORGANIZATION_ID = l_xorgid ;
7438: EXCEPTION
7439: WHEN NO_DATA_FOUND THEN
7440: l_project_ref_enabled := 0;

Line 7977: FROM MTL_PARAMETERS

7973: tev_flow_schedule = 0) THEN
7974:
7975: SELECT PRIMARY_COST_METHOD
7976: INTO l_primary_cost_method
7977: FROM MTL_PARAMETERS
7978: WHERE ORGANIZATION_ID = l_orgid ;
7979:
7980: IF ( l_avg_cost_update = 2 AND (l_primary_cost_method = 2 OR
7981: l_primary_cost_method = 5 OR

Line 8624: FROM mtl_parameters mp_from, mtl_parameters mp_to

8620: -- Get process mfg org flag for from and to orgs
8621: --
8622: SELECT mp_from.process_enabled_flag, mp_to.process_enabled_flag
8623: INTO l_process_enabled_flag_from, l_process_enabled_flag_to
8624: FROM mtl_parameters mp_from, mtl_parameters mp_to
8625: WHERE mp_from.organization_id = l_orgid
8626: AND mp_to.organization_id = l_xorgid;
8627:
8628: --

Line 8840: FROM MTL_PARAMETERS

8836: AND TRANSACTION_ACTION_ID NOT IN (5,6,24,30,50,51,52) -- Added 7025628
8837: AND COST_GROUP_ID IS NOT NULL
8838: AND COST_GROUP_ID <> l_temp_cost_group_id
8839: AND EXISTS ( SELECT 1 -- Bug 8345339 Changes Start
8840: FROM MTL_PARAMETERS
8841: WHERE ORGANIZATION_ID = l_orgid
8842: AND WMS_ENABLED_FLAG = 'N'); -- Bug 8345339 Changes End
8843:
8844: IF (l_debug = 1) THEN

Line 8878: FROM MTL_PARAMETERS

8874: AND TRANSACTION_ACTION_ID IN (2,3,21,5)
8875: AND TRANSFER_COST_GROUP_ID IS NOT NULL
8876: AND TRANSFER_COST_GROUP_ID <> l_temp_xfer_cost_group_id
8877: AND EXISTS ( SELECT 1 -- Bug 8345339 Changes Start
8878: FROM MTL_PARAMETERS
8879: WHERE ORGANIZATION_ID = l_cg_org
8880: AND WMS_ENABLED_FLAG = 'N'); -- Bug 8345339 Changes End
8881:
8882: IF (l_debug = 1) THEN

Line 14180: FROM MTL_PARAMETERS MP,

14176: 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,
14177: p_line_rec_type.TRANSFER_LOCATOR,
14178: p_line_rec_type.transaction_date,
14179: MP.NEGATIVE_INV_RECEIPT_CODE
14180: FROM MTL_PARAMETERS MP,
14181: MTL_SYSTEM_ITEMS MSI
14182: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
14183: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
14184: AND p_line_rec_type.PROCESS_FLAG = 1

Line 14226: MTL_PARAMETERS MP,

14222: p_line_rec_type.TRANSFER_LOCATOR,
14223: p_line_rec_type.transaction_date,
14224: MP.NEGATIVE_INV_RECEIPT_CODE
14225: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,
14226: MTL_PARAMETERS MP,
14227: MTL_SYSTEM_ITEMS MSI
14228: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
14229: --AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
14230: AND MTLI.TRANSACTION_INTERFACE_ID = p_line_rec_type.TRANSACTION_INTERFACE_ID