DBA Data[Home] [Help]

APPS.INV_COST_GROUP_UPDATE dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 2429: SELECT mtl_material_transactions_s.NEXTVAL

2425: l_cg_quantity_table(l_cost_group_id).new_transaction_temp_id := p_mmtt_rec.transaction_temp_id;
2426: l_cg_quantity_table(l_cost_group_id).update_mmtt := TRUE;
2427: ELSE
2428: -- otherwise generate a new_transaction_temp_id
2429: SELECT mtl_material_transactions_s.NEXTVAL
2430: INTO l_transaction_temp_id
2431: FROM dual;
2432: l_cg_quantity_table(l_cost_group_id).new_transaction_temp_id := l_transaction_temp_id;
2433: l_cg_quantity_table(l_cost_group_id).update_mmtt := FALSE;

Line 2912: SELECT mtl_material_transactions_s.NEXTVAL

2908: l_cg_quantity_table(rec_msn.cost_group_id).new_transaction_temp_id := p_mmtt_rec.transaction_temp_id;
2909: l_cg_quantity_table(rec_msn.cost_group_id).update_mmtt := TRUE;
2910: ELSE
2911: -- otherwise generate a new_transaction_temp_id
2912: SELECT mtl_material_transactions_s.NEXTVAL
2913: INTO l_transaction_temp_id
2914: FROM dual;
2915: IF (l_debug = 1) THEN
2916: print_debug('l_transaction_temp_id: ' || l_transaction_temp_id);

Line 3470: SELECT mtl_material_transactions_s.NEXTVAL

3466: --Bug 3390284
3467: lot_cg_qty_table(rec_msn.cost_group_id).quantity := lot_cg_qty_table(rec_msn.cost_group_id).quantity + 1;
3468: --Bug 3390284
3469: ELSE
3470: SELECT mtl_material_transactions_s.NEXTVAL
3471: INTO l_transaction_temp_id
3472: FROM dual;
3473:
3474: l_serial_table(l_sti).new_serial_transaction_temp_id:= l_transaction_temp_id;

Line 3522: SELECT mtl_material_transactions_s.NEXTVAL

3518: --l_serial_table(l_sti).lot_number := rec_mtlt.lot_number;
3519: l_serial_table(l_sti).cost_group_id := rec_msn.cost_group_id;
3520: l_serial_table(l_sti).quantity := 1;
3521:
3522: SELECT mtl_material_transactions_s.NEXTVAL
3523: INTO l_transaction_temp_id
3524: FROM dual;
3525:
3526: --3390284

Line 3579: SELECT mtl_material_transactions_s.NEXTVAL

3575: l_cg_quantity_table(rec_msn.cost_group_id).new_transaction_temp_id := p_mmtt_rec.transaction_temp_id;
3576: l_cg_quantity_table(rec_msn.cost_group_id).update_mmtt := TRUE;
3577: ELSE
3578: -- otherwise generate a new_transaction_temp_id
3579: SELECT mtl_material_transactions_s.NEXTVAL
3580: INTO l_transaction_temp_id
3581: FROM dual;
3582: l_cg_quantity_table(rec_msn.cost_group_id).new_transaction_temp_id := l_transaction_temp_id;
3583: l_cg_quantity_table(rec_msn.cost_group_id).update_mmtt := FALSE;