APPS.INV_MWB_QUERY_MANAGER dependencies on MTL_PARAMETERS

Line 1529: FROM mtl_parameters

1525: --Bug 6834805
1526: if (nvl(g_org_id,-9999) <> rec.org_id) then
1527: SELECT organization_code
1528: INTO l_to_org
1529: FROM mtl_parameters
1530: WHERE organization_id = rec.org_id;
1531:
1532: UPDATE MTL_MWB_GTMP
1533: SET organization_code = l_to_org

Line 1557: FROM mtl_parameters

1553: --Bug 6834805
1554: if (nvl(g_own_org_id,-9999) <> rec.owning_org_id) then
1555: UPDATE MTL_MWB_GTMP
1556: SET owning_org = (SELECT organization_code
1557: FROM mtl_parameters
1558: WHERE organization_id = rec.owning_org_id)
1559: WHERE owning_org_id = rec.owning_org_id;
1560:
1561: g_own_org_id := rec.owning_org_id;

Line 1570: FROM mtl_parameters

1566: IF rec.from_org_id IS NOT NULL THEN
1567: --from org
1568: SELECT organization_code
1569: INTO l_from_org_code
1570: FROM mtl_parameters
1571: WHERE organization_id = rec.from_org_id;
1572:
1573: UPDATE MTL_MWB_GTMP
1574: SET from_org = l_from_org_code

Line 1581: FROM mtl_parameters

1577: --to org
1578: IF rec.to_org_id IS NOT NULL THEN
1579: SELECT organization_code
1580: INTO l_to_org_code
1581: FROM mtl_parameters
1582: WHERE organization_id = rec.to_org_id;
1583:
1584: UPDATE MTL_MWB_GTMP
1585: SET to_org = l_to_org_code

Line 2125: FROM mtl_parameters

2121:
2122: IF (NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id) IS NOT NULL) THEN
2123: SELECT DECODE(wms_enabled_flag, 'Y', 1, 0)
2124: INTO inv_mwb_globals.g_wms_enabled_flag
2125: FROM mtl_parameters
2126: WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id);
2127: END IF;
2128:
2129: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'wms_enabled_flag '||inv_mwb_globals.g_wms_enabled_flag);