APPS.INV_OPM_ITEM_MIGRATION dependencies on MTL_PARAMETERS

Line 446: FROM mtl_parameters

442: process_enabled_flag, organization_code
443: INTO l_cost_of_sales_account, l_sales_account,
444: l_expense_account, l_encumbrance_account,
445: l_process_enabled_flag, l_organization_code
446: FROM mtl_parameters
447: WHERE organization_id = p_organization_id
448: AND rownum = 1;
449:
450: IF ( l_process_enabled_flag <> 'Y') THEN

Line 1124: FROM mtl_parameters mo, mtl_parameters co

1120: 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED',
1121: 'MTL_SYSTEM_ITEMS.START_AUTO_LOT_NUMBER') AND
1122: EXISTS (
1123: SELECT 1
1124: FROM mtl_parameters mo, mtl_parameters co
1125: WHERE
1126: mo.organization_id = co.master_organization_id AND
1127: Decode(mo.process_orgn_code, NULL, 'N', 'Y') <> Decode(co.process_orgn_code, NULL, 'N', 'Y'));
1128: BEGIN

Line 1510: FROM mtl_parameters

1506: BEGIN
1507: l_migrated_ind_m := -1;
1508: SELECT master_organization_id
1509: INTO l_master_organization_id
1510: FROM mtl_parameters
1511: WHERE
1512: organization_id = p_organization_id;
1513:
1514: -- Select and lock the row to avoid errors associated with running this routine in

Line 2087: mtl_parameters b

2083: select a.inventory_item_id ,
2084: a.organization_id ,
2085: a.segment1 item_no
2086: from mtl_system_items a,
2087: mtl_parameters b
2088: where a.organization_id = b.organization_id
2089: and b.process_enabled_flag = 'Y'
2090: and b.organization_code = p_organization_code
2091: and not exists (

Line 2094: mtl_parameters mp

2090: and b.organization_code = p_organization_code
2091: and not exists (
2092: select 1
2093: from ic_item_mst_b_mig ic,
2094: mtl_parameters mp
2095: where ic.organization_id = mp.organization_id
2096: and mp.organization_code = p_organization_code
2097: and mp.process_enabled_flag = 'Y'
2098: and a.inventory_item_id = ic.inventory_item_id