DBA Data[Home] [Help]

APPS.FLM_MMM_CALCULATION dependencies on MTL_SYSTEM_ITEMS_B

Line 230: FROM MTL_SYSTEM_ITEMS_B KFV,

226: CURSOR po_order_entries IS
227: SELECT distinct
228: MR1.INVENTORY_ITEM_ID item_id,
229: WL.LINE_ID
230: FROM MTL_SYSTEM_ITEMS_B KFV,
231: MRP_SYSTEM_ITEMS RSI1,
232: MRP_PLANS MP1,
233: MRP_RECOMMENDATIONS MR1,
234: WIP_LINES WL

Line 349: FROM mtl_system_items_b

345:
346: -- cursor to retrieve product_family_item_id for given item_id
347: CURSOR product_family(i_inventory_item_id IN NUMBER) IS
348: SELECT product_family_item_id
349: FROM mtl_system_items_b
350: WHERE organization_id = i_organization_id
351: AND inventory_item_id = i_inventory_item_id;
352:
353: BEGIN