DBA Data[Home] [Help]

APPS.INV_MWB_QUERY_MANAGER dependencies on MTL_PARAMETERS

Line 1482: FROM mtl_parameters

1478: --Bug 6834805
1479: if (nvl(g_org_id,-9999) <> rec.org_id) then
1480: SELECT organization_code
1481: INTO l_to_org
1482: FROM mtl_parameters
1483: WHERE organization_id = rec.org_id;
1484:
1485: UPDATE MTL_MWB_GTMP
1486: SET organization_code = l_to_org

Line 1510: FROM mtl_parameters

1506: --Bug 6834805
1507: if (nvl(g_own_org_id,-9999) <> rec.owning_org_id) then
1508: UPDATE MTL_MWB_GTMP
1509: SET owning_org = (SELECT organization_code
1510: FROM mtl_parameters
1511: WHERE organization_id = rec.owning_org_id)
1512: WHERE owning_org_id = rec.owning_org_id;
1513:
1514: g_own_org_id := rec.owning_org_id;