DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 3371: FROM mtl_material_transactions_temp

3367: order by Repl_Sequence_id;
3368:
3369: CURSOR c_mmtt_rec IS
3370: SELECT transaction_temp_id
3371: FROM mtl_material_transactions_temp
3372: WHERE move_order_line_id = l_mo_line_id;
3373:
3374: BEGIN
3375: --Note: by the time this API is called p_consol_item_repl_tbl(i).final_replenishment_qty

Line 4229: FROM mtl_material_transactions_temp

4225: ,COUNT(*)
4226: INTO l_prim_quantity_detailed
4227: ,l_quantity_detailed_conv
4228: ,l_num_detail_recs
4229: FROM mtl_material_transactions_temp
4230: WHERE move_order_line_id = l_x_trolin_tbl(1).line_id;
4231:
4232: IF (l_debug = 1) THEN
4233: print_debug('primary l_quantity detailed is :'|| l_prim_quantity_detailed);

Line 7189: FROM mtl_material_transactions_temp

7185:
7186:
7187: CURSOR c_mmtt_rec IS
7188: SELECT transaction_temp_id
7189: FROM mtl_material_transactions_temp
7190: WHERE move_order_line_id = l_mo_line_id;
7191:
7192: BEGIN
7193:

Line 7496: FROM mtl_material_transactions_temp

7492: ,COUNT(*)
7493: INTO l_prim_quantity_detailed
7494: ,l_quantity_detailed_conv
7495: ,l_num_detail_recs
7496: FROM mtl_material_transactions_temp
7497: WHERE move_order_line_id = l_open_repl_mo.line_id;
7498:
7499: IF (l_debug = 1) THEN
7500: print_debug('primary l_quantity detailed is '|| l_prim_quantity_detailed);