DBA Data[Home] [Help]

APPS.FLM_EXECUTION_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 1483: mtl_system_items msi

1479: msi.description,
1480: msi.revision_qty_control_code,
1481: msi.location_control_code
1482: from flm_exe_req_operations fero,
1483: mtl_system_items msi
1484: where fero.organization_id = p_org_id
1485: and fero.wip_entity_id = p_wip_ent_id
1486: and fero.inventory_item_id = msi.inventory_item_id
1487: and msi.organization_id = fero.organization_id

Line 1611: from mtl_system_items msi,

1607: into l_msiSubinv,
1608: l_msiLocatorID,
1609: l_wpSubinv,
1610: l_wpLocatorID
1611: from mtl_system_items msi,
1612: wip_parameters wp
1613: where msi.organization_id = wp.organization_id
1614: and msi.organization_id = p_orgID
1615: and msi.inventory_item_id = c_recorded_comps.inventory_item_id;

Line 2169: mtl_system_items msi

2165:
2166: CURSOR nontxn_comp_cnt IS
2167: select count(component_item_id) comp_cnt
2168: from bom_inventory_components bic,
2169: mtl_system_items msi
2170: where bill_sequence_id = l_bill_seq_id
2171: and msi.inventory_item_id = bic.component_item_id
2172: and bic.effectivity_date < nvl(l_bom_rev_date,sysdate)
2173: and ((bic.disable_date is null) or