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 191: || ' mtl_onhand_quantities_detail ohd ';

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