DBA Data[Home] [Help]

APPS.FLM_EXECUTION_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 1263: mtl_system_items msi

1259: msi.description,
1260: msi.revision_qty_control_code,
1261: msi.location_control_code
1262: from flm_exe_req_operations fero,
1263: mtl_system_items msi
1264: where fero.organization_id = p_org_id
1265: and fero.wip_entity_id = p_wip_ent_id
1266: and fero.inventory_item_id = msi.inventory_item_id
1267: and msi.organization_id = fero.organization_id

Line 1391: from mtl_system_items msi,

1387: into l_msiSubinv,
1388: l_msiLocatorID,
1389: l_wpSubinv,
1390: l_wpLocatorID
1391: from mtl_system_items msi,
1392: wip_parameters wp
1393: where msi.organization_id = wp.organization_id
1394: and msi.organization_id = p_orgID
1395: and msi.inventory_item_id = c_recorded_comps.inventory_item_id;

Line 1949: mtl_system_items msi

1945:
1946: CURSOR nontxn_comp_cnt IS
1947: select count(component_item_id) comp_cnt
1948: from bom_inventory_components bic,
1949: mtl_system_items msi
1950: where bill_sequence_id = l_bill_seq_id
1951: and msi.inventory_item_id = bic.component_item_id
1952: and bic.effectivity_date < nvl(l_bom_rev_date,sysdate)
1953: and ((bic.disable_date is null) or