DBA Data[Home] [Help]

APPS.BOM_ROUTINGHEADER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 341: from mtl_system_items

337: Select 1 dummy
338: From dual
339: Where not exists (
340: select null
341: from mtl_system_items
342: where organization_id = P_Org
343: and inventory_item_id = P_Item);
344: Cursor l_DupRtgs_csr (P_RtgSeqId number, P_AssyId number,
345: P_OrgId number, P_Alternate varchar2) is

Line 375: From mtl_system_items

371: Select 1
372: From dual
373: Where not exists (
374: Select null
375: From mtl_system_items
376: Where organization_id = P_OrgId
377: and inventory_item_id = P_AssyId
378: and bom_item_type <> 3
379: and bom_enabled_flag = 'Y'

Line 422: from mtl_system_items msi,

418: msi.restrict_subinventories_code,
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;