APPS.INV_LOT_SERIAL_DATE_EVENT_PKG dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 38: , mtl_onhand_quantities_detail ohd;

34: , expiration_date date_column
35: FROM mtl_lot_numbers mln
36: , mtl_parameters mtp
37: , mtl_system_items_kfv msi
38: , mtl_onhand_quantities_detail ohd;
39:
40: CURSOR cur_serial_template IS
41: SELECT mtp.organization_code
42: , msi.inventory_item_id

Line 189: || ' mtl_onhand_quantities_detail ohd ';

185: || p_date_type
186: || ' date_column ';
187: l_lot_table_list :=
188: ' mtl_lot_numbers mln, mtl_parameters mtp, mtl_system_items_kfv msi, '
189: || ' mtl_onhand_quantities_detail ohd ';
190: l_lot_where_clause :=
191: ' mtp.organization_id = :b_organization_id '
192: || ' and mtp.organization_id = msi.organization_id '
193: || ' and mln.organization_id = msi.organization_id '