DBA Data[Home] [Help]

APPS.JAI_OM_RMA_PKG dependencies on MTL_SYSTEM_ITEMS

Line 452: FROM mtl_system_items

448: FROM wsh_delivery_details wdd
449: WHERE wdd.delivery_detail_id = TO_NUMBER(pn_delivery_detail_id)
450: AND (wdd.inventory_item_id IN
451: (SELECT inventory_item_id
452: FROM mtl_system_items
453: WHERE base_item_id = p_inventory_item_id
454: AND bom_item_type = 4) OR
455: wdd.inventory_item_id = p_inventory_item_id)
456: AND wdd.shipped_quantity IS NOT NULL)

Line 472: FROM mtl_system_items

468: AND rctla.inventory_item_id = p_inventory_item_id
469: AND wdd.delivery_detail_id = TO_NUMBER(rctla.interface_line_attribute3)
470: AND (wdd.inventory_item_id IN
471: (SELECT inventory_item_id
472: FROM mtl_system_items
473: WHERE base_item_id = p_inventory_item_id
474: AND bom_item_type = 4) OR
475: wdd.inventory_item_id = p_inventory_item_id)
476: AND wdd.shipped_quantity IS NOT NULL)