DBA Data[Home] [Help]

APPS.INV_OPM_ITEM_MIGRATION dependencies on MTL_PARAMETERS

Line 376: FROM mtl_parameters

372: process_enabled_flag, organization_code
373: INTO l_cost_of_sales_account, l_sales_account,
374: l_expense_account, l_encumbrance_account,
375: l_process_enabled_flag, l_organization_code
376: FROM mtl_parameters
377: WHERE organization_id = p_organization_id
378: AND rownum = 1;
379:
380: IF ( l_process_enabled_flag <> 'Y') THEN

Line 1037: FROM mtl_parameters mo, mtl_parameters co

1033: 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED',
1034: 'MTL_SYSTEM_ITEMS.START_AUTO_LOT_NUMBER') AND
1035: EXISTS (
1036: SELECT 1
1037: FROM mtl_parameters mo, mtl_parameters co
1038: WHERE
1039: mo.organization_id = co.master_organization_id AND
1040: Decode(mo.process_orgn_code, NULL, 'N', 'Y') <> Decode(co.process_orgn_code, NULL, 'N', 'Y'));
1041: BEGIN

Line 1412: FROM mtl_parameters

1408: BEGIN
1409: l_migrated_ind_m := -1;
1410: SELECT master_organization_id
1411: INTO l_master_organization_id
1412: FROM mtl_parameters
1413: WHERE
1414: organization_id = p_organization_id;
1415:
1416: -- Select and lock the row to avoid errors associated with running this routine in