DBA Data[Home] [Help]

APPS.BOMPVALB dependencies on MTL_PARAMETERS

Line 79: from mtl_parameters

75: stmt_num := 1; /* Check for valid org id */
76: BEGIN
77: select organization_id
78: into dummy_id
79: from mtl_parameters
80: where organization_id = c1rec.OI;
81: EXCEPTION
82: when NO_DATA_FOUND then
83: ret_code := INVPUOPI.mtl_log_interface_err(

Line 746: from mtl_parameters mp1, mtl_parameters mp2

742: */
743: begin
744: select 1
745: into cnt
746: from mtl_parameters mp1, mtl_parameters mp2
747: where mp1.organization_id = org_id
748: and mp2.organization_id = cmn_org_id
749: and mp1.master_organization_id = mp2.master_organization_id;
750: exception

Line 1790: from mtl_parameters

1786: */
1787: /* Org level */
1788: select stock_locator_control_code
1789: into org_loc
1790: from mtl_parameters
1791: where organization_id = c1rec.OI;
1792:
1793: if (org_loc = 1) and (c1rec.SLI is not null) then
1794: raise write_loc_error;

Line 3547: from mtl_parameters

3543: stmt_num := 2;
3544: BEGIN
3545: select organization_id
3546: into dummy_id
3547: from mtl_parameters
3548: where organization_id = c0rec.OI;
3549: EXCEPTION
3550: when NO_DATA_FOUND then
3551: ret_code := INVPUOPI.mtl_log_interface_err(