DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 3283: FROM mtl_material_transactions_temp

3279: order by Repl_Sequence_id;
3280:
3281: CURSOR c_mmtt_rec IS
3282: SELECT transaction_temp_id
3283: FROM mtl_material_transactions_temp
3284: WHERE move_order_line_id = l_mo_line_id;
3285:
3286: BEGIN
3287: --Note: by the time this API is called p_consol_item_repl_tbl(i).final_replenishment_qty

Line 4109: FROM mtl_material_transactions_temp

4105: ,COUNT(*)
4106: INTO l_prim_quantity_detailed
4107: ,l_quantity_detailed_conv
4108: ,l_num_detail_recs
4109: FROM mtl_material_transactions_temp
4110: WHERE move_order_line_id = l_x_trolin_tbl(1).line_id;
4111:
4112: IF (l_debug = 1) THEN
4113: print_debug('primary l_quantity detailed is :'|| l_prim_quantity_detailed);

Line 7014: FROM mtl_material_transactions_temp

7010:
7011:
7012: CURSOR c_mmtt_rec IS
7013: SELECT transaction_temp_id
7014: FROM mtl_material_transactions_temp
7015: WHERE move_order_line_id = l_mo_line_id;
7016:
7017: BEGIN
7018:

Line 7321: FROM mtl_material_transactions_temp

7317: ,COUNT(*)
7318: INTO l_prim_quantity_detailed
7319: ,l_quantity_detailed_conv
7320: ,l_num_detail_recs
7321: FROM mtl_material_transactions_temp
7322: WHERE move_order_line_id = l_open_repl_mo.line_id;
7323:
7324: IF (l_debug = 1) THEN
7325: print_debug('primary l_quantity detailed is '|| l_prim_quantity_detailed);