APPS.WMS_BULK_PICK dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 855: select mtl_material_transactions_s.NEXTVAL

851: mydebug('BULK_PICK:create_sub_transfer:get the rec for the child:'||l_mmtt_rec.transaction_temp_id,
852: l_api_name);
853: END IF;
854:
855: select mtl_material_transactions_s.NEXTVAL
856: into l_new_temp_id
857: from dual;
858:
859: l_mmtt_rec.primary_quantity := p_pri_qty;

Line 1122: SELECT mtl_material_transactions_s.NEXTVAL

1118: END IF;
1119:
1120: -- processed child lines will get a new header id
1121:
1122: SELECT mtl_material_transactions_s.NEXTVAL
1123: INTO x_new_txn_hdr_id
1124: FROM DUAL;
1125:
1126: IF (l_debug = 1) THEN

Line 1315: select mtl_material_transactions_s.NEXTVAL

1311: l_child_txn_temp_id := c_mmtt_line.transaction_temp_id;
1312: l_link_mtlt_needed := 'N';
1313: ELSE -- qty in mmtt > qty processed ,split anyway, will be cleaned up later on
1314:
1315: select mtl_material_transactions_s.NEXTVAL
1316: into l_new_temp_id
1317: from dual;
1318:
1319: IF (l_debug = 1) THEN mydebug('split the child line with the new temp id '||l_new_temp_id,l_api_name);

Line 1533: select mtl_material_transactions_s.NEXTVAL

1529: l_child_pri_qty := 0;
1530:
1531: EXIT WHEN l_parent_txn_qty = 0;
1532: ELSE -- Current Child Qty is greater than Parent Picked Qty
1533: select mtl_material_transactions_s.NEXTVAL
1534: into l_new_temp_id
1535: from dual;
1536:
1537: split_child_mmtt(l_child_txn_temp_id,