[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;
184: || ' sum(ohd.secondary_transaction_quantity) secondary_transaction_quantity, '
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 '
308:
309: IF p_date_type = 'EXPIRATION_DATE' THEN
310: SELECT expiration_action_code
311: INTO l_expiration_action_code
312: FROM mtl_lot_numbers
313: WHERE lot_number = l_lot_rec.lot_number
314: AND organization_id = p_organization_id
315: AND inventory_item_id = l_lot_rec.inventory_item_id;
316: END IF;