[Home] [Help]
31: , mln.gen_object_id
32: , ohd.primary_transaction_quantity
33: , ohd.secondary_transaction_quantity
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:
124: l_onhand_qty_uom VARCHAR2 (100);
125: l_attr_context fnd_descr_flex_col_usage_vl.descriptive_flex_context_code%TYPE;
126: l_attr_ctxt fnd_descr_flex_col_usage_vl.descriptive_flex_context_code%TYPE;
127: l_user_column_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
128: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE;
129: l_lookup_type mfg_lookups.lookup_type%TYPE := 'SERIAL_NUM_STATUS';
130: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
131: l_transaction_id NUMBER;
132: l_user_id NUMBER;
186: || ' sum(ohd.secondary_transaction_quantity) secondary_transaction_quantity, '
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 '
311:
312: IF p_date_type = 'EXPIRATION_DATE' THEN
313: SELECT expiration_action_code
314: INTO l_expiration_action_code
315: FROM mtl_lot_numbers
316: WHERE lot_number = l_lot_rec.lot_number
317: AND organization_id = p_organization_id
318: AND inventory_item_id = l_lot_rec.inventory_item_id;
319: END IF;