APPS.BOM_ROUTINGHEADER_PVT dependencies on MTL_PARAMETERS

Line 47: From mtl_parameters

43: nvl(P_Alternate , 'PRIMARY ALT');
44:
45: cursor l_parameter_csr(P_Code varchar2) is
46: Select organization_id
47: From mtl_parameters
48: Where organization_code = P_Code;
49: cursor l_line_csr(P_Organization_Id number, P_Code varchar2) is
50: Select line_id
51: From wip_lines

Line 326: From mtl_parameters

322: Select 1 dummy
323: From dual
324: Where not exists (
325: Select null
326: From mtl_parameters
327: Where organization_id = P_OrgId);
328: Cursor l_alternate_csr (P_OrgId number, P_Alt varchar2) is
329: Select 1 dummy
330: From dual

Line 423: mtl_parameters mp

419: msi.restrict_locators_code,
420: msi.location_control_code,
421: mp.stock_locator_control_code
422: from mtl_system_items msi,
423: mtl_parameters mp
424: where msi.inventory_item_id = P_ItemId
425: and msi.organization_id = P_OrgId
426: and mp.organization_id = msi.organization_id;
427: Cursor l_NonRestrictedSubinv_csr (P_SubInv varchar2, P_OrgId number,

Line 1292: from mtl_parameters mp

1288: l_UserId,
1289: l_LoginId,
1290: sysdate,
1291: sysdate
1292: from mtl_parameters mp
1293: where mp.organization_id = l_routing_rec.organization_id
1294: and not exists (
1295: select null
1296: from mtl_rtg_item_revisions